Course curriculum

    1. Course Introduction

    2. Install SQL Server 2019

    3. Installing Adventureworks

    4. The Database Defined

    5. Using Management Studio

    6. The Query Editor

    7. Important Terms

    1. A Query is Like a Sentence

    2. DML vs DDL

    3. Write it Down

    4. Use Statement

    5. The Table Object

    6. What is a table?

    7. Inserting Data

    8. Table Relationships

    9. How are table related to one another?

    10. Formatting and Comments

    11. Terminology

    12. Data Definition Language

    13. Our First Stored Procedure

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

    15. Create a Stored Procedure for INSERT

    16. Input Parameters

    17. Terminology

    1. Anatomy of a SELECT Statement

    2. What does the WHERE clause do?

    3. Schemas

    4. Column Alias

    5. What is an alias?

    6. Derived Columns

    7. Using DATEDIFF

    8. What does the DATEDIFF function do?

    9. Creating a View

    10. What is a view?

    11. Operators

    12. What is an operator?

    13. The LIKE Operator

    14. NULLS

    15. What is a NULL value?

    16. Logical Comparisons

    17. Extended Filtering

    18. Parentheses

    1. Anatomy of a Function

    2. Scalar Functions

    3. Table-Valued Functions

    4. Table Value User Defined Functions

    5. Aggregate Functions

    6. Count All vs Count Distinct

    7. Conversion Functions

    1. Subqueries

    2. HAVING Clause

    3. Common Table Expressions

    1. Download AdventureWorksLT2008

    2. Question 1: SELECT

    3. Question 2: SELECT

    4. Question 3: SELECT

    5. Use the AdventureWorks2019 Database

    6. Question 1: Filtering Data

    7. Question 2: Filtering Data

    8. Question 3: Filtering Data

    9. Question 4: Filtering Data

    10. Question 5: Filtering Data

    11. Question 6: Filtering Data

    12. Question 7: Filtering Data

    13. Question 8: Filtering Data

    14. Question 9: NULLS

    15. Question 10: NULLS

    16. Question 11: NULLS

    17. Question 12: Sorting

    18. Question 13: Sorting

    19. Question 14: Functions and Expressions

    20. Question 15: Functions and Expressions

    21. Question 16: Functions and Expressions

    22. Question 17: Mathematical Operations

    23. Question 18: Mathematical Operations

    24. Question 19: Mathematical Operations

    25. Question 20: String Functions

    26. Question 21: String Functions

    27. Question 22: String Functions

    28. Question 23: String Functions

    29. Question 24: Date Functions

    30. Question 25: Date Functions

    31. Question 26: Date Functions

    32. Question 27: Date Functions

    33. Question 28: Date Functions

    34. SQL Server Cheat Sheet

    35. Answer Key

About this course

  • Free
  • 87 lessons
  • 2 hours of video content