Course Duration : 45days of Live Sessions

 About Course

This course is for those who want to learn python for software development, web development and data analysis. If you don’t have fundamental knowledge of python, you cannot start software development, web development and data analysis.

Python is a free and open source programming language that is really easy to learn. Python is used in many applications and it has a potential of generating jobs.  You should start learning python today.

Module I: Core Python Programming

• Introduction of Python Programming
• Installing Python – Python IDLE, Jupyter Notebook and Google Colab
• Writing Your First Python Program
• Data-types in Python
• Variables in Python – Declaration and Use
• Typecasting in Python
• Operators in Python –Arithmetic, Comparison, Logical , Assignment, Identity, Membership operators
• Taking User Input (Console)
• Conditional Statements – If else and Nested If else and elif
• Loops in Python – For Loop, While Loop & Nested Loops
• Python Collections (Arrays) – List, Tuple, Sets and Dictionary
• String Manipulation – Basic Operations, Slicing & Functions and Methods
• User Defined Functions – Defining, Calling, Types of Functions, Arguments, Recursion
• Lambda Function
• Importing Modules – Math / Time / Statistics / Calendar Module

Module II: Object Oriented Programming using Python

• Basics of Object Oriented Programming
• Creating Class and Object
• In built class methods and attributes
• Constructors in Python – Parameterized and Non-parameterized
• Inheritance in Python, Types of inheritance, Single / Multi-level / Multiple / Hybrid / Hierarchical
• Method Overriding/Overloading and Data Abstraction
• Encapsulation and Polymorphism
• Exception Handling

 Module III: Python Libraries 

• What is function and need of using Python library
• Data Analysis Libraries in Python such as NumPy (for scientific computing ) and Pandas for (data analysis / data manipulation)

• Data Visualization Libraries in Python such as Matplotlib for creating line plots , bar plots, pie charts, scatter plots and histogram

 Module IV: MySQL

• Introduction to DBMS (Data Base Management System)
• Need and Importance of DBMS and concept of RDBMS
• Introduction to SQL Language
• Installation of MySQL 8.0 software / Online SQL editors
• Introduction to SQL data types
• Commands in SQL
• Operators and Functions of SQL
• Types and usage of integrity constraints in SQL
• MySQL Workbench
• User Management like create user / drop user / show users / change user password
• Sub queries/ Stored procedures in SQL
• Joins and Views in SQL
• MySQL connectors
• Interview Questions and Assignments
• Online Examinations