Course curriculum

  • 1

    Introduction

    • Course Introduction

    • Install SQL Server 2019

    • Installing Adventureworks

    • The Database Defined

    • Using Management Studio

    • The Query Editor

    • Important Terms
  • 2

    Writing Transact-SQL Overview

    • A Query is Like a Sentence

    • DML vs DDL

    • Write it Down

    • Use Statement

    • The Table Object

    • What is a table?

    • Inserting Data

    • Table Relationships

    • How are table related to one another?

    • Formatting and Comments

    • Terminology

    • Data Definition Language

    • Our First Stored Procedure

    • What's the Syntax to create a stored procedure in SQL Server?

    • Create a Stored Procedure for INSERT

    • Input Parameters

    • Terminology
  • 3

    Data Manipulation Language

    • Anatomy of a SELECT Statement

    • What does the WHERE clause do?

    • Schemas

    • Column Alias

    • What is an alias?

    • Derived Columns

    • Using DATEDIFF

    • What does the DATEDIFF function do?

    • Creating a View

    • What is a view?

    • Operators

    • What is an operator?

    • The LIKE Operator

    • NULLS

    • What is a NULL value?

    • Logical Comparisons

    • Extended Filtering

    • Parentheses

  • 4

    Functions

    • Anatomy of a Function

    • Scalar Functions

    • Table-Valued Functions

    • Table Value User Defined Functions

    • Aggregate Functions

    • Count All vs Count Distinct

    • Conversion Functions
  • 5

    Advanced Transact

    • Subqueries

    • HAVING Clause

    • Common Table Expressions
  • 6

    Exercises

    • Download AdventureWorksLT2008

    • Question 1: SELECT

    • Question 2: SELECT

    • Question 3: SELECT

    • Use the AdventureWorks2019 Database

    • Question 1: Filtering Data

    • Question 2: Filtering Data

    • Question 3: Filtering Data

    • Question 4: Filtering Data

    • Question 5: Filtering Data

    • Question 6: Filtering Data

    • Question 7: Filtering Data

    • Question 8: Filtering Data

    • Question 9: NULLS

    • Question 10: NULLS

    • Question 11: NULLS

    • Question 12: Sorting

    • Question 13: Sorting

    • Question 14: Functions and Expressions

    • Question 15: Functions and Expressions

    • Question 16: Functions and Expressions

    • Question 17: Mathematical Operations

    • Question 18: Mathematical Operations

    • Question 19: Mathematical Operations

    • Question 20: String Functions

    • Question 21: String Functions

    • Question 22: String Functions

    • Question 23: String Functions

    • Question 24: Date Functions

    • Question 25: Date Functions

    • Question 26: Date Functions

    • Question 27: Date Functions

    • Question 28: Date Functions

    • SQL Server Cheat Sheet

    • Answer Key