Introduction to Python

• History & Need of Python
• Application of Python
• Advantage of Python
• Why Python for Data Science?
• Different Job Roles with Python
• Installing Python

Python Fundamentals

• Python Character Set
• Python Tokens
  • Keywords
  • Identifiers
  • Literals
  • Operators
  • Variables and Assignments
  • Comment in Python
  • Block and Indentation
  • Input and Output Operation in Python

Data Types

• Data Types in Python
  • Numbers
  • Float
  • Strings
  • List
  • Tuple
  • Set
  • Dictionary
  • Bool
• Type Casting in Python

Operators

• Define Operators
• Different Types of Operators
  • Arithmetic Operators
  • Relational Operators
  • Logical Or Conditional Operators
  • Assignment Operators

Conditional / Selection Statement

• Define Conditional Statement
• Types of Conditional Statements
  • If Statement
  • If Else Statement
  • If Elif Else Statement
  • Nested If Statement
  • Match Case Statement

Iteration/Looping Statement

• Define Loop
• Define Range Function
• Different Types of Loop Construct
  • for Loop
  • while Loop
  • while True Loop
  • Jump Statement

Strings

• Introduction to Python Strings
• Accessing Strings Elements
• f string in Python
• String Indexing
• String Slices
• String Functions and Methods

List

• Introduction to Python List
• Creating List
• Properties of List
• List Indexing
• List Slicing
• List Methods

Set

• Introduction to Python Set
• Creating Set
• Properties of Set
• Set Operations and Methods

Tuple

• Introduction to Python Tuple
• Creating Tuple
• Properties of Tuple
• Tuple Indexing
• Tuple Slicing
• Tuple Methods

Dictionary

• Introduction to Python Dictionary
• Creating Dictionary
• Properties of Dictionary
• Dictionary Key and Values
• Accessing Values in Dictionary
• Dictionary Methods

Exception Handling

• Define Exception in Exception Handling
• Define Syntax Error
• Define Logical Error
• Handling Errors using try, except and finally

Project

Methods or Functions

• Define Function & its Type
• System Define Function
• User Define Function
• Type of User Define Function
  • With Return type with Argument
  • With Return type without Argument
  • Without Return type with Argument
  • Without Return type without Argument

Introduction to OOPs Concept

• What is OOPs Concept?
• Advantages of OOPs.
• Access Specifiers/Modifiers
  • Public
  • Private
  • Protected
• Features of OOPs.

Class & Objects

• Define Class and Object
• How to create Class & Object?
• Program to Define Class & Object

Constructor

• Define Constructor
• How to create Constructor?
• Program to Define Constructor
• Types of Constructors
  • Default Constructor
  • Parameterized Constructor

Encapsulation & Abstraction

• Define Encapsulation
• Properties of Encapsulation
• Define Getter and Setter Method
• Program to Define Encapsulation
• Define Abstraction
• Program to Define Abstraction

Polymorphism

• Define Polymorphism
• Types of Polymorphism
• 1. Static Polymorphism (Compile Time)
  • Function Overloading
  • Program to define Function Overloading
• 2. Dynamic Polymorphism (Run Time)
  • Function Overriding
  • Program to Define Function Overriding
  • Super Function

Inheritance

• Define Inheritance
• Types of Inheritance
  • Single Level Inheritance
  • Multi-Level Inheritance
  • Multiple Inheritance
  • Hierarchical Inheritance
  • Hybrid Inheritance

File Handling

• Introduction to Data files
• Define File Handling Modes
• Create File in Python
• Open and Close File in Python
• Reading and Writing File in Python
• Delete File in Python

Project

MY SQL

• Introduction To My SQL
• Purpose Of DBMS
• Relational Database Model
• The Relational Model Terminology
  • Views
  • Structure Of Relational Database
• Brief History of MySQL

MY SQL

• MySQL Database System
• Starting MySQL
• MySQL And SQL
• Processing Capabilities Of SQL
• Data Definitional Language
• Classification Of SQL Statement
• SQL Command Syntax

MY SQL

• Table Creation and Data Manipulation Commands
• Introduction
• Databases In MySQL
• Creating Database
• Opening Database
• Removing Database
• Creating Table
• Data Integrity Through Constraints
• Changing Data with DML Commands
• Inserting Data into Table
• Modifying Data with Update Command
• Deleting Data with Delete Commands
• More DDL Commands
• Alter Table Command
• The Drop Table Command
• Group, View, Join in MySQL

PYTHON GUI (GRAPHICAL USER INTERFACE)PROGRAMMING

• Introduction To GUI Programming & It’s Importance
• GUI In Python – Widgets & Install & Setup Tkinter
• Tkinter Module- Import the Tkinter Module, Create GUI Main Application Window
  • Geometry
  • Title
  • Iconimage(Logo)
• Tkinter Programming- Add One Or More of The Above-Mentioned Widgets To The GUI Application Window, Call The Main Event Loop
• Python Tkinter Widgets
  • Entry, Label, Button, Canvas
  • Their Options
• Python Tkinter Geometry
  • Pack (), Grid (), Place ()
  • There Option

PYTHON GUI (GRAPHIC USER INTERFACE)PROGRAMMING

• Python Tkinter Widgets
• Frame, Listbox,
• Menu
• Message, Scale,
• Scrollbar, Text
• Toplevel, Spinbox,
• Panedwindow, Labelframe
• Tkmessagebox, Tree
• Their Options

DATABASES IN PYTHON & ITS CONNECTIVITY

• Python MySQL Database Access
• Install The MySQL Db and Other Packages & Communicating with MySQL
• Python Data Base Communications (PDBC)
  • Create Database Connection & Create, Insert, Read Operation
  • Connector Module, Connect () Method
  • Cursor Object Methods, Execute () Method
• Static Queries V/S Dynamic Queries, Transaction Management
• Python Data Base Communications (PDBC)
  • Fetchone(), Fetchmany(), Fetchall(), Static Queries V/S Dynamic Queries
• Login With Database Creation in MySQL
• Implement Configure Logging File
• Executing System
  • Insert & Update
  • Delete & Select Commands
• Python Network Programming Connecting
  • To a One Page to Second Page in Local Server
• Python Multithreaded Programming Create Single Page
• Thon Multithreaded Programming Create Single Page/Thread or Connect with Multipage or Thread by Tkinter Operations
• Garbage Collection – Remove Data from GUI Application to My SQL Databases
• Start Real Time Project (Library / Institute Management)