Advanced SQL and Power BI for Data Analyst and BI Developer

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction of Analyst

Lecture 2: SQL Server Installation

Lecture 3: Power BI Installation

Lecture 4: SQL Introduction and SQL Query writing

Lecture 5: Power BI Introduction, Import Data and Visualization

Chapter 2: SQL Server Object and Component

Lecture 1: SQL Server Interface

Lecture 2: Comment SQL Server Query

Lecture 3: Server and Database

Lecture 4: SQL Table, Record, Field

Chapter 3: SQL Table

Lecture 1: Create Table

Lecture 2: Create Table without Create Statement

Lecture 3: Delete Table

Lecture 4: Alter Table

Chapter 4: Data Insert, Import and Export

Lecture 1: Insert Data with Graphical User Interface

Lecture 2: Insert Data into Table

Lecture 3: Bulk Insert Data into Table

Lecture 4: Import Data into Table

Lecture 5: Export Data from Table

Chapter 5: Delete ,Truncate and Drop

Lecture 1: Define Delete, Truncate and Drop

Lecture 2: Delete Data on Condition

Lecture 3: Delete Entire Data from Table

Lecture 4: Drop Entire Table

Chapter 6: Update Data

Lecture 1: Update Entire Field Data in Table

Lecture 2: Update Data on Condition

Chapter 7: Select Statement to View Data (Where Clause)

Lecture 1: View Data

Lecture 2: View Distinct Data

Lecture 3: View Filtered Data

Chapter 8: Filter Data with Where Clause (And, Or, IN, Between, LIKE, TOP Operators)

Lecture 1: View Filtered Data with AND Operator

Lecture 2: View Filtered Data with OR Operator

Lecture 3: View Filtered Data with IN Operator

Lecture 4: View Filtered Data with BETWEEN Operator

Lecture 5: View Filtered Data with LIKE Operator

Lecture 6: SQL Top Clouse

Lecture 7: View Top Data with Live Scenario

Lecture 8: View Bottom Data with Live Scenario

Chapter 9: SQL Order By to Sort Data

Lecture 1: Sort Data in Ascending or Descending Orders

Lecture 2: Sort Data In Ascending Orders

Lecture 3: Sort Data in Descending Orders

Chapter 10: Group By and Having

Lecture 1: Extract Distinct Data

Lecture 2: Aggregate Data with Group By

Lecture 3: Apply Condition with Having Clause

Chapter 11: SQL Sub Query

Lecture 1: Extract Data of Max Value

Lecture 2: Extract Data of Min Value

Lecture 3: Extract Data more than Average Value

Lecture 4: Extract Product Name of 3rd Highest Sales

Lecture 5: Extract Name of 3rd Smallest Salary

Chapter 12: SQL Joins

Lecture 1: Introduction of Join

Lecture 2: Inner Join

Lecture 3: Left Join

Lecture 4: Right Join

Lecture 5: Full Join

Lecture 6: Cross Join

Lecture 7: Self Join

Chapter 13: SQL Union

Lecture 1: Union

Lecture 2: Union ALL

Lecture 3: Intersect

Lecture 4: Except

Chapter 14: SQL Case Statement

Lecture 1: Create a Conditional Field

Chapter 15: Common Table Expression (CTE)

Lecture 1: Row_Number

Lecture 2: Rank Function

Lecture 3: Dense_Rank Function

Lecture 4: Extract Product Name of 3rd Largest Sales

Lecture 5: Extract Product Name of 3rd Smallest Sales

Lecture 6: Extract Each Category Two Max Value Data

Lecture 7: Extract Each Category Two Min Value Data

Chapter 16: Power BI Introduction

Lecture 1: Introduction of Power BI

Lecture 2: ETL (Extract Transformation and Load)

Lecture 3: Dimension Table and Fact Table

Lecture 4: Star Schema vs Snowflake Schema

Chapter 17: Power Query

Lecture 1: Power Query Introduction

Lecture 2: Data Extraction Using Import and Direct Query Mode

Lecture 3: Manage Parameters

Lecture 4: Dynamic Calendar Table Using Parameters

Lecture 5: Join and Append

Lecture 6: Index Number and Group by

Lecture 7: Manage (Delete, Duplicate and Reference) Option

Lecture 8: Conditional Column

Lecture 9: Custom Column

Lecture 10: Choose Columns and Remove Columns

Chapter 18: Filters in Power BI

Lecture 1: Visual Level, Page Level, Report Level and Drill Through Filters

Chapter 19: Slicers in Power BI

Lecture 1: Basic of Slicer