Pragya Rathi

Starting date :- April 20,2025

SQL Content -

Section 1: Introduction to SQL

Section 2: Basic SQL Syntax

Section 3: Insert, Delete and Update statements

Section 4: Select , Where, Order by Clauses

Section 5: Aggregating Data

Section 6: Built-in functions- String/Date

Section 7: Case When, Set Operators

Section 8: Joins – Inner, Left, Right, Outer

Section 9: Joins- Self, Natural and Joins on more than 2 tables

Section 10: Sets(union ,union all ,intersect ,except)

Section 11: Advanced Joins and Table Operations

Section 12: CTE(common table expressions)

Section 14: Subquery

Section 15: Advanced Window Functions and Analytic Queries

Power BI Course Content:-

Section 1: Introduction to Power BI

Overview of Power BI

Installation and setup

Section 2: Data Loading and Transformation

Connecting to data sources

Data import and export

Data transformation with Power Query

Merging and appending queries

Section 3: Data Modeling

Creating relationships between tables

Defining calculated columns and measures

Using DAX functions

Section 4: Data Visualization

Building and customizing charts and graphs

Using tables and matrix visuals

Creating slicers and filters

Custom visuals

Section 5: Report and Dashboard Creation

Designing interactive reports

Building dashboards

Best practices for report layout and designs

Using Power BI service for report sharing