Introduction to Python Programming

• Introduction to Python Programming
• Comparison with other programming language
• Installing Python and pip
• Scope of Python in Production
• Working with IDE and interpreter
• Features of Python
• Python Versions
• Creating your first python program
• Python keywords and identifiers
• Python Variables
• Type of Conversion

Data Types, Operators, Strings, Conditional statements & Loops

• Python Data Types
• Operators
• Arithmetic operators
• Relational operators
• Conditional operators
• Logical operators
• Bitwise operators
• Introduction to string
• Basic string operation
• String functions and methods
• Deleting a string
• String manipulation and concatenation
• Conditional Statements
• What are conditional statements?
• Working with "if" condition
• Working with "if-else" condition
• Working with "if-elif" condition
• Nested if condition
• Loops
• Introduction to Loops concept
• Working with 'while' loop
• Working with 'for' loop
• Nested loop
• Break statement and Continue statement
• Practical examples for each topic

Sequence of Data (Data Types)

• Python Lists
• Lists are mutable
• Getting to Lists
• List indices
• Traversing a list
• List operations, slices and methods
• Map, filter and reduce
• Deleting elements
• Python Tuples
• Creating Tuples
• Advantages of Tuple over List
• Comparing tuples
• Deleting a Tuple
• Slicing of Tuple
• Built-in functions with Tuple
• Sets
• How to create a set?
• Iteration Over Sets
• Python Set Methods
• Python Set Operations
• Union of sets
• Dictionaries
• How to create a dictionary?
• Python Dictionary Method Copying dictionary
• Delete Keys from the dictionary
• Dictionary len() Method
• Python List cmp() Method
• Programming examples for all type of data types

Functions

• What is a function?
• How to define and call a function in Python?
• Types of Functions
• How Function Return Value?
• Types of Arguments in Functions
• Rules to define a function in Python
• Nested Functions
• Call By Value, Call by Reference
• map(), filter(), reduce() functions
• Anonymous Functions/Lambda functions

Modules, Packages, Date & Time

Python Module

• What is a Module?
• Types of Modules
• The import Statement
• The ..import Statement
• ..import * Statement
• Creating User defined Modules

Python Packages

• What is a Package?
• Introduction to Packages?
• Importing module from a package
• Creating a Package
• Popular Python Packages
• Python Date and time
• How to Use Date & Date Time Class
• How to Format Time Output
• Calendar in Python
• The Time Module
• Python Calendar Module
• Practical examples

File and Error Handling

• Python File Handling
• What is a data, Information File?
• How to create a Text Fill and Append Data to a File and Read a File
• Closing a file
• Read, read line, read lines, write, write lines
• Renaming and Deleting Files
• Directories in Python
• Python Error Handling
• Python Errors
• Common Runtime Errors in PYTHON
• Chain of importance Of Exception
• Exception Handling
• Try & Except
• Try, Except & else
• Python Custom Exceptions
• Ignore Errors
• Practical Examples

Classes and Objects

• Introduction to OOPs Programming
• Object Oriented Programming System
• OOPS Principles
• Define Classes
• Creating Objects
• Class variables and Instance Variables Constructors
• Basic concept of Object and Classes
• Access Modifiers
• How to define Python classes
• Python Namespace-
• What is Inheritance?
• Types of Inheritance?
• Polymorphism
• Encapsulation
• Abstraction
• Interfaces

Database Communication

• What is Database?
• Types of Databases?
• What is DBMS, RDBMS?
• Working with MysqlDB
• How to create a database?
• How to upload data into table
• Integration of database and output of other program
• Creation of MariaDB users
• Working with remote database storage
• Altering the table using python

GUI Tkinter

• Python GUI - Tkinter
• Introduction
• Components and Events
• Adding Controls
• Entry Widget, Text Widget, Radio Button, Check Button
• List Boxes, Menus, ComboBox

• Networking in python

• Regular Expressions

• Reading from CSV files writing to CSV
• Read and writing to JSON
• Reading and writing to Excel file.

• MySQL Features
• MySQL Versions
• MySQL Data Types
• MySQL Variables
• Install MySQL
• MySQL Connection
• User Management
• MySQL Create User
• MySQL Drop User
• MySQL Show Users
• Change User Password
• MySQL Database
• MySQL Create Database
• MySQL Select Database
• MySQL Show Databases
• MySQL Drop Database
• MySQL Copy Database

• MySQL CREATE Table
• MySQL ALTER Table
• MySQL Show Tables
• MySQL Rename Table
• MySQL TRUNCATE Table
• MySQL Describe Table
• MySQL DROP Table
• MySQL Copy Table
• MySQL Add/Delete Column
• MySQL Show Columns
• MySQL Rename Column
• MySQL Views
• MySQL Queries
• MySQL Queries
• MySQL Constraints
• MySQL INSERT Record
• MySQL UPDATE Record
• MySQL DELETE Record
• MySQL SELECT Record
• MySQL Indexes
• MySQL Create Index
• MySQL Drop Index
• MySQL Show Indexes
• MySQL Unique Index
• MySQL Clauses
• MySQL WHERE
• MySQL DISTINCT
• MySQL FROM
• MySQL ORDER BY
• MySQL GROUP BY
• MySQL HAVING
• MySQL Privileges
• MySQL Grant Privilege
• MySQL Revoke Privilege

• MySQL IF()
• MySQL IFNULL()
• MySQL NULLIF()
• MySQL CASE
• MySQL IF Statement
• MySQL Conditions
• MySQLAND
• MySQL OR
• MySQL AND OR
• MySQL Boolean
• MySQL LIKE
• MySQL IN
• MySQLANY
• MySQL Exists
• MySQL NOT
• MySQL Not Equal
• MySQL IS NULL
• MySQL IS NOT NULL
• MySQL BETWEEN
• MySQLJoin
• MySQLJOIN
• MySQL Inner Join
• MySQL Left Join
• MySQL Right Join
• MySQL CROSS JOIN
• MySQL SELF JOIN
• MySQL EquiJoin
• MySQL Natural Join
• LeftJoin vs RightJoin
• MySQL Key
• MySQL Unique Key
• MySQL Primary Key
• MySQL Foreign Key
• MySQL Composite Key

• Introduction
• What is a Web Framework?
• What is Micro-framework?
• What is Flask?
• What is WSGI?
• What is Jinja 2?
• Why Flask?
• Templates in Flask