COURSE OUTLINEs

Module 1: Basic Excel

Workbook

Worksheet

Formatting

Find & Replace

Excel templates

Data Validation

Freeze Panes

Text to Column

Sort & Filter

Dates Function

Protect Cells

Locked Cells

Keyboard Shortcuts

Trim & Concatinate

Module 2: Intermediate Excel

Conditional Formatting

Finding Duplicate

Charts

Cell reference

Relative referebce

Multiple References

3D references

Named Ranges

Advanced Formatting

Working with Images

Module 3: Advanced Excel/Data Analysis Part 1

Proper,Upper,Lower

Trim, Len

Left,Mid,Right

Concat

Today,Now,Date and Time function

Year,Month, Day

Vlookup, Xlookup, Hlookup

Sumif,Sumifs

Countif,Countifs

Average,Averageifs

Logical

Module 4: Advanced Excel/Data Analysis Part 2

Power Query

Data modeling

Tables

Pivot Tables

Fields, Rows, Columns

Calculated Fields

Dashboard Report

Introduction to Python:

What is Power BI?

Why use Power BI?

Key Components of Power BI

Overview of Power BI Desktop

Demonstration of Power BI Desktop Functionalities 

Advanced Visualization Techniques

DAX Functions and Formulas

Measures and Coding

Power BI Report Creation Demonstration

Advanced Data Sources

Power BI Service

Advanced Report Design

Advanced Data Transformation

Getting Started – MySQL

MySQL in General.

Creating Databases

Exploring the MySQL Workbench. 

Retrieving Data from Table

SELECT Statement

The Select Clause

The Where Clause

The AND OR and NOT operators

The in Operator

Between Operator

Like Operator

REGEXP Operator

THE IS NULL Operator

The Order by Clause

The Limit Clause

Retrieving Data from Multiple Tables

Explaining the relationship between tables

Primary and Foreign Key Constraints

Inner Joins

Continuation of Retrieving Data from Multiple Tables

Joining across Databases

Self Joins

Joining Multiple tables

Compound Join Conditions

Implicit Join Syntax

Outer Joins

Outer Join between Multiple tables

Self-outer joins

The USING clause

Natural Joins

Cross Joins

Unions

Inserting, Updating, Deleting, and Subquery

Using sub-query

Column Attributes

Inserting a row

Inserting Multiple rows

Inserting hierarchical rows

Creating a copy of table

Updating a single row

Updating Multiple rows

Using sub queries in updates

Deleting rows

Restoring the databases

Summarizing Data, Writing Complex Queries, Essential MySQL Functions

The Rollup operator

The Having Clause

The Group by Clause

Aggregate Functions

Numeric Functions

String Functions

Date Functions in MYSQL

Formatting Dates and Time

Calculating Dates and Times

The IF NULL and COALESCE functions

The If Functions

The CASE operator

Others:

1. Views

Creating views

Altering or dropping views

Updatable views

The with option check clause

Other benefits of views

2. Stored Procedure

What is a stored Procedure?

Creating a stored Procedure

Creating a procedure using MYSQL Workbench

Dropping a stored Procedure

Parameters

Parameters with Default value

Parameter validation

Output Parameters

Variables

Functions

3. Data types

Introduction to Data types

String types

Integer types

Fixed point and Floating-point types

Boolean types

Enum and Set types

Date and time types

Blob types

JSON Type

Module 1: Introduction to Python

What is Python?

Installing Python and an Integrated Development Environment (IDE)

Writing and running your first Python program

Understanding the Python interpreter

Basic syntax and conventions

Variables, data types, and type conversion

Comments and documentation

Module 2: Control Structures

Conditional statements (if, elif, else)

Comparison and logical operators

Using loops (while, for)

Iterating through sequences (lists, tuples, strings)

Loop control statements (break, continue)

Nested loops and loop optimization

Module 3: Data Structures

Lists, tuples, and sets

Working with lists (slicing, methods)

Introduction to dictionaries

Common built-in functions

List comprehensions

Working with files (reading, writing, appending)

Module 4: Functions and Modules

Defining functions

Function parameters and arguments

Return statements and function scope

Built-in functions vs. user-defined functions

Creating and importing modules

Exploring Python's standard library