SQL Bootcamp for Business, Product, & Data Analysts

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Installation of SQL Server 2019 & SSMS

Lecture 3: Connect To Sql Server

Lecture 4: Create Sample Database (MediaStoreDb)

Lecture 5: Generate a Database Relationship Diagram

Chapter 2: SELECT

Lecture 1: Get all Customer Details

Lecture 2: Get all Album Details

Lecture 3: Get Customer Fields

Lecture 4: Get Track Fields

Lecture 5: Get Employee Fields

Chapter 3: Column Alias

Lecture 1: Display Customer Phone Number using Custom Field Name

Lecture 2: Display Track Unit Price using Custom Field Alias

Chapter 4: DISTINCT

Lecture 1: Get Customers Unique Countries

Lecture 2: Get Employee Titles

Chapter 5: WHERE (=,<>,>,<,>=,LIKE,BETWEEN,IN (OR/AND)

Lecture 1: Get Tracks having Track Length Condition

Lecture 2: Customers having Last Name Condition

Lecture 3: Tracks Starting With The Letters A – F

Lecture 4: Tracks Not Starting With The Letters A – F

Lecture 5: Get Invoices Between Two Dates

Lecture 6: Get Customers from California and Florida

Lecture 7: Get Management Level Employees

Lecture 8: Get IT Staff Level Employees

Lecture 9: Customers in USA, Canada with Custom Last Name

Lecture 10: Customers not from USA with Custom Last Name

Lecture 11: Customers Missing a State Code

Chapter 6: ORDER BY (ASC/DESC)

Lecture 1: Customers Living in Berlin Sorted

Lecture 2: Most Recent Orders between Two Dates

Lecture 3: Employees Sorted by Title and Last Name

Lecture 4: Tracks Having a Composer Sorted by Name

Chapter 7: TOP

Lecture 1: Last Five Invoices Created

Lecture 2: Top 10% of Tracks by Length

Lecture 3: First Ever Invoice Created

Chapter 8: Aggregates/GROUP BY (SUM,AVG,COUNT,MAX,MIN)

Lecture 1: Total Price of Each Invoice

Lecture 2: Total Price of Each Invoice with Condition

Lecture 3: Average Track Length

Lecture 4: Customer Count by Country

Lecture 5: Countries Having Less than 5 Customers

Lecture 6: Invoice Count per Customer

Lecture 7: Longest Running Track and Total Tracks

Lecture 8: Average Runtime, Total Price, Highest Bytes,Total Tracks (All Albums)

Lecture 9: Average Runtime, Total Price, Highest Bytes,Total Tracks (Per Album)

Chapter 9: Concatenation

Lecture 1: Customer Display Name (Last, First)

Lecture 2: Apply 50% Discount of Track's Unit Price

Chapter 10: Inner Queries/SubQueries

Lecture 1: Tracks Having Runtime Smaller than Average

Lecture 2: Customers with Invoices More Than Some Amount

Lecture 3: Tracks Having No Sales

Lecture 4: Genres Having No Sales

Chapter 11: Joins (INNER, LEFT, RIGHT)

Lecture 1: Customer, Invoice Info for Orders Placed Before March

Lecture 2: Invoice Details for a Specific Customer

Lecture 3: Total Daily Sales by Sales Agent

Lecture 4: Customers Having Zero Orders Placed

Lecture 5: Albums that Generated Zero Sales

Chapter 12: Stored Procedures

Lecture 1: Overview

Lecture 2: Create and Alter Your First Stored Procedure

Lecture 3: Excel GetCustomers Report