Programming

Introduction to Python Programming

• Why do we need Python?
• Program structure in Python

Execution steps

• Interactive Shell
• Executable or script files.
• User Interface or IDE

Memory management and Garbage collection

• Object creation and deletion
• Object properties

Data Types and Operations

• Numbers
• Strings
• List
• Tuple
• Dictionary
• Other Core Types

Statements and Syntax in Python

• Assignments,Expressions and prints
• If tests and Syntax Rules
• While and For Loops 
• Iterations and Comprehensions

File Operations

•  Opening a file
• Using File 
• Other File tools

Functions in Python

• Function definition and call
• Function Scope
• Arguments 
• Function Objects
• Anonymous Functions

Modules and Packages

• Module Creations and Usage
• Module Search Path
• Module Vs. Script
• Package Creation and Importaing

Classes in Python

• Classes and Instances
• Classes method  calls
• Inheritance and Compositions
• Static and Class Method
• Bound and Unbound Methods
• Operator Overloading
• Polymorphism

Exception Handling in Python Programming 

•  Default Exception Handler
• Catching Exceptions
• Raise an exception
• User defined exception

Advanced Python Concepts

• Decorators
• Catching Exception Handler
• Raise an exception
• User defined exception

Advanced Python Conncepts

• Decorators
• Generators
• Iterators
• Co-routines

Introduction to Matplotlib
Numpy
Panda’s 
Data connectivity with My SQL

SQL Overview

• Relational database concepts, specific products SQL syntax rules
• Data definition, data manipulation, and data control statements Getting acquainted with the course database and editor

SQL SELECT statements

• Clauses 
• The SELECT clause: columns and aliases, where expressions, order by expressions how null Values behave