Introduction
- Course Overview
- Data Manipulation Verbs
- Courseware Overview
- Datasets Overview
Overview of SSMS and Query Writing
- Working with SSMS
- Using the SQL Editor
- Creating SSMS Script Projects
- Tips and Tricks with SSMS
- Adding Comments to Queries
- Understanding Batches and Scripts
Database Design Concepts
- What is SQL
- Database Diagrams
- Database Terminology Overview
Basic SELECT Statements
- The SELECT Statement
- Execution Order of SELECT Statements
- Ordering Results
- Additional SELECT Options
Working with Data Types
- Data Type Precedence
- String Related Data Types
- Numeric Data Types
- Date and Time Data Types
- Converting Between Data Types
- How to Find Help on Functions
- Understanding Data Type Conversion
Enhanced SELECT Statements
- Expressions
- Filtering Rows
- Comparison Operators
- Logical Operators
Handling NULL Data
- NULL vs Blank
- = vs IS NULL
- ISNULL function
- COALESCE
- Concatenating NULL Data
Aggregating and Grouping Data
- Aggregate Functions
- GROUP BY
- HAVING
- HAVING vs WHERE
Joining Multiple Tables
- JOINS
- INNER JOIN
- OUTER JOIN
- CROSS JOIN
- Joining Three or More Tables
- Self-join
- Alternate Syntax, Implicit Joins
- Set Operations
- Working with Multiple Set Operators
- Viewing Graphical Execution Plans
Built-in Functions Overview
- Working with Functions
- Mathematical Function Overview
- String Function Overview
- Date Time Function Overview
- Nesting Functions
Subqueries
- Subqueries
- Nested vs Correlated Subqueries
- Subqueries in the SELECT Clause
- Subqueries in the WHERE Clause
- EXISTS
- Subqueries in FROM Clause
- Alternatives to Subqueries