Introduction to Python                      

• Using Python Interpreter
• Python script file
• Print Message to Standard Output
• variables and data types
• Reading Input from console
• Type Conversion
• Arithmetic Operators and Conditions

Python Data Structures

• Python Set
• Creating Set
• Adding/Removing elements to/from set
• Python Set Operations: Union, Intersection, Difference and Symmetric Difference
• Python Tuple
• Creating Tuple
• Understanding Difference between Tuple and List
• Accessing Elements in Tuple
• Python Dictionary
• Creating Dictionary
• Accessing / Changing / Deleting Elements in Dictionary
• Built-in Dictionary Methods and Functions

Control Flow

• Relational Operators
• if…else statement
• if…elif…else statement
• Logical operators
• While Loops
• break and continue statement
• Loops with else statement
• pass statement
• Python for loop
• Range Function

Lists

• Creating List
• Accessing elements from List
• Inserting and Deleting Elements from List
• List Slicing
• Joining two lists
• Repeating sequence
• Nested List
• Built-in List Methods and Functions
• Shallow and Deep copy
• List Comprehensions
• Conditionals on Comprehensions

Functions

• Defining Functions in Python
• Function Argument
• Function Returning single Values
• Functions with multiple parameter
• Function that returns Multiple Values
• Functions with Default arguments
• Named arguments
• Scope and Lifetime of Variables
• global specifier
• Functional programming tools: map (), reduce () and filter ()
• Lambda: short Anonymous functions
• Creating and importing modules
• Programming Examples & Assignments
• Recursion

Set and dictionary

• Creating a Set
• Adding and removing elements from set.
• Python set operations
• Creating a Dictionary
• Accessing elements of Dictionary
• Adding elements to Dictionary
• Deleting elements from a dictionary
• List as values of Dictionary
• Nested Dictionary.

RDBMS

• Introduction to databases and RDBMS
• Database creation
• Concept of relation and working examples
• Creating tables.
• Design view of the table,
• Alter table operations & Key Constraints
• Read, update and delete operations on tables.
• Working with nulls

Querying tables:

• Filtering & Sorting,
• Predicates and working examples
• Joins ,Insert, Update, Delete operations
• Scalar functions in SQL
• SQL set based operations and data aggregation
• Sub-queries in SQL
• Normalization and de-normalization
• Views and Temporary tables
• Transactions in SQL
• SQL programming
• Creating stored procedures
• Cursors in SQL

NUMPY

• NumPy
• Vectorized
• Operation
• Sub setting
• Broadcasting
• Matrix Calculation
• Numpy Functions

Pandas

• Introduction to pandas
• Panda Series
• Accessing Methods with Series
• Pandas Data frames
• Accessing Methods with Frames
• Pandas operation
• Sorting and Aggregation
• Merge and Concatenation
• Replace and Interplote

Data Cleaning

• Introduction to Data Cleaning
• Handling Missing Data
• Finding the outliers
• Handling the outliers

Matplotlib and Seaborn

• Introduction to Matplotlib
• Introduction to Seaborn
• Creating graphs using Matplotlib
• Customizing Plots
• Saving Plots
• Finding the outliers using the seaborn
• Handling the outliers