Microsoft SQL Server Essentials

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: What to expect from this course

Lecture 3: Defining a relational database

Chapter 2: Getting Started

Lecture 1: Installing the required tools

Lecture 2: Creating your first database

Lecture 3: Setting up the Adventure Works database

Chapter 3: Data Definition Language Basics

Lecture 1: Introduction to Data Definition Language (DDL)

Lecture 2: Creating a table using SSMS

Lecture 3: Creating a table using T-SQL

Chapter 4: Table Constraints In SQL Server

Lecture 1: Intro to table constraints in SQL Server

Lecture 2: Creating a primary key using SSMS GUI & T-SQL

Lecture 3: Creating a foreign key using T-SQL

Lecture 4: Creating a foreign key using SSMS

Chapter 5: Data Manipulation Language Basics

Lecture 1: Intro to Data Manipulation Language (DML)

Lecture 2: Data Manipulation Language Examples

Chapter 6: Filtering Queries In SQL Server

Lecture 1: Filtering queries using the WHERE clause

Lecture 2: Filtering queries using other conditions (Part 1)

Lecture 3: Filtering queries using other conditions (Part 2)

Chapter 7: All about the JOIN command

Lecture 1: Introducing the JOIN command

Lecture 2: Using the JOIN command (Part 1)

Lecture 3: Using the JOIN command (Part 2)

Lecture 4: Using the JOIN command (Part 3)

Chapter 8: Aggregate & Conditional Expressions In SQL Server

Lecture 1: Introducing Aggregate functions in SQL Server

Lecture 2: Using GROUP BY and HAVING commands

Lecture 3: Using the IF…ELSE conditional statements

Lecture 4: Using the CASE conditional statement in SQL Server

Chapter 9: Built-In Functions In SQL Server

Lecture 1: Using the DATE functions in SQL Server

Lecture 2: Using the STRING functions in SQL Server

Chapter 10: Subqueries, Views & Stored Procedures

Lecture 1: Writing your first subquery

Lecture 2: Working with Stored Procedures (Part 1)

Lecture 3: Working with Stored Procedures (Part 2)

Lecture 4: Creating, using and modifying Views in SQL Server

Chapter 11: Advanced SQL Server Concepts

Lecture 1: Introducing TRIGGERS in SQL Server

Lecture 2: AFTER INSERT and AFTER UPDATE Trigger Examples

Lecture 3: Automating Jobs with SQL Server Agent

Lecture 4: Optimizing Query performance in SQL Server

Chapter 12: Conclusion

Lecture 1: Conclusion