Module Name Contents of the module
● Need for programming
● Advantages of programming
● Overview of python
● Organizations using python
● Python Applications in various domains
Module 1: Introduction to Python
● Variables
● Operands and expressions
● Conditional statements
● Loops
● Structural pattern matching
● Accepting user input and eval function
● Files input/output functions
● Lists
Module 2: Sequences and File Operations ● Tuples
● Strings manipulation
● Sets and set operations
● Python dictionary
● User-defined functions
● Function parameters
● Different types of arguments
● Global variables
● Global keyword
● Lambda functions
● Built-in functions
Module 3: Functions and Object-oriented Programming ● Object-oriented concepts
● Public, protected and private attributes
● Class variable and instance variable
● Constructor and destructor
● Inheritance and its types
● Method resolution order
● Overloading and overriding
● Getter and setter methods
● Standard libraries
● Packages and import statements
● Reload function
Module 4: Working with Modules and Handling Exceptions
● Creating a module
● Important modules in python
● Sys module
● OS module
● Math module
● Date-time module
● Random module
● JSON module
● Regular expression
● Exception handling
● Basics of data analysis
● NumPy - Arrays
● Array operations
● Indexing, slicing, and Iterating
Module 5: Array Manipulation using NumPy ● NumPy array attributes
● Matrix product
● NumPy functions
● Array manipulation
● File handling using NumPy
● Introduction to Pandas
● Data structures in Pandas
● Series
● Data Frames
● Importing and exporting files in Python
● Basic functionalities of a data object
Module 6: Data Manipulation using Pandas
● Merging of data objects
● Pivoting a dataframe
● Concatenation of data objects
● Types of joins on data objects
● Data cleaning using Pandas
● Exploring datasets
● Why data visualization?
● Matplotlib library
● Seaborn
● Line plots
● Multiline plots
Module 7: Data Visualization using Matplotlib and ● Bar plot
Seaborn ● Histogram
● Pie chart
● Scatter plot
● Boxplot
● Saving charts
● Customizing visualizations
● Saving plots
● Grids
● Subplots
● Heatmaps
● Ipywidgets package
● Numeric widgets
● Boolean widgets
● Selection widgets
Module 8: GUI Programming ● String widgets
● Date picker
● Color picker
● Container widgets
● Creating a GUI application
● Use of Folium library
● Use of Pandas library
Module 9: Developing Web Maps and Representing ● Flow Chart of web map application
Information using Plots ● Developing web map using Folium and Pandas
● Reading Information from titanic dataset and represent It
using plots
● Beautiful Soup library
● Scrapy
● Requests library
● Scrap All hyperlinks from a webpage using Beautiful Soup
Module 10: Web Scraping and Computer Vision using and Requests
OpenCV ● Plotting charts using Bokeh
● Plotting scatterplots using Bokeh
● Image editing using OpenCV
● Face detection using OpenCV
● Motion detection and capturing video
● Basics of database management
● Python MySql
● Create database
● Create a table
● Insert into table
Module 11: Database Integration with Python ● Select query
● Where clause
● OrderBy clause
● Delete query
● Drop table
● Update query
● Limit clause
● Join and Self-Join
● MongoDB (Unstructured)
● Insert_one query
● Insert_many query
● Update_one query
● Update_many query
● Create_index query
● Drop_index query
● Delete and drop collections
● Limit query
● What is MySQL?
● What is SQL?
● SQL Basics
● How to Install MySQL on Windows10
Module 12 - Adavnced MySQL ● SQL vs MySQL
● Normalization
● Built-in functions
● Joins in SQL
● SQL Interview Preparation