Microsoft SQL from scratch – Beginner to Expert

Course Curriculum

Chapter 1: Microsoft SQL Server Installation

Lecture 1: Introduction

Lecture 2: System Requirements

Lecture 3: Please Read

Lecture 4: Download Microsoft SQL Server Express

Lecture 5: What is SQL

Lecture 6: What is T-SQL

Lecture 7: What is SQL Server

Lecture 8: Basic Database Concepts

Lecture 9: Schema

Lecture 10: Install Microsoft SQL Server

Lecture 11: Download Sample Database

Lecture 12: Attach sample database

Lecture 13: Install SSMS ( SQL Server Management Studio)

Lecture 14: Exploring SSMS

Lecture 15: Using Intellisense

Lecture 16: Introduction to Normalization

Lecture 17: Using T-SQL GO command

Lecture 18: Using T-SQL TOP command

Lecture 19: T-SQL USE command

Chapter 2: Extracting Data using SQL

Lecture 1: Using SELECT to extract data

Lecture 2: Using Aliases with SELECT

Lecture 3: Using Case expressions

Lecture 4: Creating and extracting data from views

Lecture 5: Commenting your T-SQL code

Lecture 6: Removing duplicate records

Lecture 7: Using Stored Procedures

Chapter 3: Modifying Data with SQL

Lecture 1: Introduction

Lecture 2: Inserting new data using SQL

Lecture 3: Updating existing data using SQL

Lecture 4: Deleting (dropping) data using SQL

Lecture 5: Summary

Chapter 4: Sorting Data with SQL

Lecture 1: Introduction

Lecture 2: Using ORDER BY

Lecture 3: Sorting by ascending order

Lecture 4: Sorting by descending order

Lecture 5: Sorting by multiple columns

Lecture 6: Summary

Chapter 5: Filtering Data with SQL

Lecture 1: Introduction

Lecture 2: Filtering using basic equality filters

Lecture 3: Filtering using basic comparison filters

Lecture 4: Filtering using basic logical filters

Lecture 5: Filtering using string comparison filters

Lecture 6: Filtering using NULL comparison

Lecture 7: Summary

Chapter 6: Extracting Data From Multiple Tables

Lecture 1: Introduction to Table Joins

Lecture 2: Importance of Table Joins

Lecture 3: Extracting with INNER Join

Lecture 4: Extracting with LEFT OUTER Join

Lecture 5: Extracting with RIGHT OUTER Join

Lecture 6: Extracting with FULL OUTER Join

Lecture 7: Conclusion

Chapter 7: Aggregate Functions and Grouping Data

Lecture 1: Introduction

Lecture 2: Using COUNT Aggregate Function

Lecture 3: Using AVG Aggregate Function

Lecture 4: Using MAX Aggregate Function

Lecture 5: Using MIN Aggregate Function

Lecture 6: Using SUM Aggregate Function

Lecture 7: Using multiple aggregate functions

Lecture 8: Grouping Data

Lecture 9: Summary

Chapter 8: Real World Data Analysis and Business Intelligence using SQL

Lecture 1: Download Nortwind Database

Lecture 2: Attach Nortwind Database to SQL Server

Lecture 3: Build a query to show contact titles for customers

Lecture 4: Build query to show customers and employee count

Lecture 5: Analysing and extracting data from multiple data

Lecture 6: Build query to show Sales Reps

Lecture 7: Build a query to check specific products

Lecture 8: Build a query to check suppliers details

Lecture 9: Build query to checck least and most expensive product

Lecture 10: Build a query to check orders shipped

Lecture 11: Build a query to list shippers

Lecture 12: Build a query to show discontinued products

Lecture 13: Build query to check first order placed.

Lecture 14: Build query to check orders shipped to Latin America

Lecture 15: Build query to show sales reps in a country

Lecture 16: Build a query to check product stock

Lecture 17: Build a query to show countries with customers

Chapter 9: Some Exercises For You

Lecture 1: Exercise 1

Lecture 2: Exercise 2

Lecture 3: Exercise 3

Lecture 4: Excercise 4

Lecture 5: Exercise 5

Lecture 6: Exercise 6

Lecture 7: Exercise 7

Lecture 8: Thank You