Overview of Python Language

Installing Python and IDEs (e.g., PyCharm, VSCode, Jupyter Notebook)

Data types: int, float, str and boolean

Input/Output Operations

Declaring and initializing variables

Arithmetic Calculations

All about operators

Simple if

if…else

if…elif…else

while and for loops

break and continue statements

Nested loops

Loop Pattern and Series

Introduction to Lists

Indexing, Slicing and Operators

List Methods

Introduction to Tuple

Indexing, Slicing and Operators

Tuple Methods

String Introduction

Declaration and Initializing

Indexing, Slicing and Operators

Built-in string functions

Sets Introduction

Declaration and Initializing

Operators

Built-in functions

Dictionary Introduction

Declaration and Initializing

Built-in functions

Predefined functions

Userdefined Functions

Creating Modules

Importing Built-in Libraries and Modules

Introduction to Exception

Type of Exceptions

Try …… except block

Opening, closing, reading and writing text files

File Operations using os modules

NumPy Arrays

Multidimensional Arrays

Initializing, Indexing and Accessing

Pandas Series using List and Dictionary

Pandas Dataframe

Read CSV or Excel Files

Introduction to Matplot Library

Graph Plot

Bar Graph (Vertical and Horizontal)

Pie Graph

Introduction to Object-Oriented Programming (OOP)

Constructor

Read and Create SQL tables

Executing Queries: Insert, Update, Delete, Select

Creating window

Learning Widgets: Label, Entry, Spinbox, TkCalendar, Combobox, Radiobutton, Checkbox, etc.

Integration with Excel, Matplot and MySQL

Assignment Questions

Mini Project