1. Language Introduction and Installation

• Python history
• Python features
• python and pycharm installation.

2. Python Basics

• Print command
• Comments,escape sequences
• Variables
• Data types
• User interactive command, operators

3. Conditional and looping statements

• Selection statements
• Control statements
• Break and continue statements
• Nested loops

4. Data Structures in python

Introduction to user defined data structures and non-primitive data structures:list,

dictionaries, set,tuples, strings and sequences,accessing and modifying elements in data

structures,comprehension: list, set and dictionary.

5. Functions in Python

Defining functions, passing arguments to functions, different types of arguments, returning

values from functions, local and global namespace, lambda function, recursion, filter,

map,reduce, eval. Generators and decorators.

6. File Handling and Exception Handling

File processing, Reading and writing files using ‘with’ statements. What is an Exception?,

raising and catching exceptions and handling errors gracefully using try-catch-finally.

7. Object Oriented Programming

Introduction to OOPs, Classes and objects, inheritance and polymorphism, encapsulation

and abstraction.

8. Modules in Python

Introduction to modules, importing modules, creating and using modules.

9. Regular Expressions

Defining regular expressions, using regular expressions with python.

10.Pandas and Numpy

Introduction to Pandas library, reading and writing data with pandas, data cleaning and

exploration with pandas. Introduction to numpy, numpy basic operation.

11. Data Visualization with Matplotlib and seaborn

Introduction, basic and advanced plotting technique

1. Introduction to SQL

• Introduction to databases and database management system
• Overview of MySQL
• Installing and getting started with MySQL workbench.

2. SQL Database

• Creating databases
• Dropping databases
• Introduction to tables
• Data types in MySQL

3. Data Definition Language

• Introduction DDL commands
• Creating table
• Modifying table using ALTER, DROP, TRUNCATE, RENAME

4. Data Manipulation Language

• Overview of MySQL SELECT statement
• Retrieving data
• Filtering and sorting
• Joining and combining data
• Updating and deleting data
• Inserting data
• Constraints(PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL.

5. MySQL Functions and Joins

MySql built-in functions, inner, outer and self joins and combining data from multiple tables.

6. MySQL subqueries and views

Subqueries and nested queries,creating and using views, normalization and denormalization

7. MySQL stored procedures and triggers

Creating and using stored procedures and triggers, database security and user management.

Project

Build a simple database to help us manage the booking process of a sports complex. The sports complex has the following facilities: 

• 2 tennis courts
• 2 badminton courts,
• 2 multi-purpose fields
• 1 archery range.

Each facility can be booked for a duration of one hour. Only registered users are allowed to make a booking. After booking, the complex allows users to cancel their bookings latest by the day prior to the booked date. Cancellation is free. However, if this is the third (or more) consecutive cancellations, the complex imposes a $10 fine

1. PowerBI Introduction

• Introduction
• PowerBI
• Power query editor
• PowerBI service, 
• Installation and configuration of powerBI desktop
• Connecting to data sources and loading data

2. Data modeling in PowerBI

Understanding data modeling and relationships creating relationships between tables, building hierarchies and calculated columns, transforming using power query.

3. Data Visualization in PowerBI

Understanding data visualization best practices, building basic visualizations(charts, graphs, tables etc..), formatting and customizing visualizations.

4. Building Interactive reports 

Using filters and slicers to create interactive reports, building drill-through reports and drill-down visualizations, creating bookmarks and scenarios.

5. Creating Dashboards

Building dashboards with multiple visualizations, creating dashboards tiles and adding images, creating custom visuals using powerBI

6. Data Analytics with PowerBI 

Understanding data analytics and DAX language, creating DAX formulas and measures.

7. Project

Financial Performance analysis: to optimize financial reporting in a firm that provides customers to track their financial health and productivity. Create data models and visualizations, and dashboards and present the project results and insights.