SQL for Data Analytics and Business Analytics

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Overview

Lecture 2: What is Analyst

Lecture 3: Introduction of SQL Server

Lecture 4: Datasets and Power Point Downloadable Resource

Lecture 5: SQL Server Interface

Lecture 6: Server and Database

Lecture 7: SQL Table, Record, Field

Chapter 2: SQL Table

Lecture 1: Create Table

Lecture 2: Create Table without Create Statement

Lecture 3: Delete Table

Lecture 4: Alter Table

Chapter 3: 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 4: Delete and Truncate

Lecture 1: Delete Data on Condition

Lecture 2: Delete Entire Data from Table

Chapter 5: Update Data

Lecture 1: Update Entire Field Data in Table

Lecture 2: Update Data on Condition

Lecture 3: Begin Transaction

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

Lecture 1: View Data

Lecture 2: View Distinct Data

Lecture 3: View Filtered Data

Chapter 7: 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: View Top and Bottom Records with TOP Clause

Chapter 8: SQL Order By

Lecture 1: Sort Data in Ascending or Descending Orders

Lecture 2: Sort Data In Ascending Orders

Lecture 3: Sort Data in Descending Orders

Chapter 9: Group By and Having

Lecture 1: Extract Distinct Data

Lecture 2: Aggregate Data with Group By

Lecture 3: Apply Condition with Having Clause

Chapter 10: 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 3rd Highest Sales

Chapter 11: 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 12: SQL Union

Lecture 1: Union

Lecture 2: Union ALL

Lecture 3: Intersect

Lecture 4: Except

Chapter 13: SQL Case Statement

Lecture 1: Create a Conditional Field

Chapter 14: Window Function and Common Table Expression (CTE)

Lecture 1: Row_Number Function

Lecture 2: Rank Function

Lecture 3: Dense_Rank Function

Lecture 4: Extract Product Name of 3rd Largest Sales