The course consists of 11 modules covering 55 lessons. Each lesson includes video and written text. You can try the sample problem to see how you’re learning. If you have any questions, I’m here to help. Lesson reviews and quizzes are included to help you reinforce what you have learned.
SQL Overview:
- What is SQL Server?
- Writing you First Query
Writing SELECT Queries:
- Basic Structure
- Table Naming
- Duplicates
- Naming Columns and Expressions
Sorting:
- Sort Data Using ORDER BY
- Limit Results with TOP
- Paging with OFFSET and FETCH
Filtering Data:
- Using the WHERE Clause to Filter Results
- Filter Using Boolean Logic
- Pattern Matching
Data Types and Null Values
- Null Values
- Common SQL Data Types
- Esoteric Data Types
Built-In Functions
- Conversion Functions
- CASE Statement
- Logical Functions
- Math Functions
- String Functions
- Date Functions
Group and Summarize Your Data
- Aggregate Functions
- Grouping Data
- Filtering Grouped Data with HAVING
Tables and Relationships:
- Introduction to Tables and Relationships
- Introduction to Normalization
- First Normal Form
- Second Normal Form
- Third Normal Form
Set Operators:
- Introduction to Set Operators
- What is a Union?
- Union versus Union All
- Ordering Unioned Data
- Work with Three or More Unions
- What is Intersect?
- Intersect Two or More Tables
- What is Except?
- Examples Using Except
Joins:
- Introduction
- Cross Joins
- Introduction to Inner Joins
- Inner Join Table Aliases
- Self Joins
- Joining Two Or More Columns
- Non Equi Joins
- Outer Joins
- Left versus Right Outer Joins
- Full Outer Joins
- Uses for Full Outer Joins
Subqueries:
- Introduction to Subqueries
- Subqueries in Select List
- Subqueries as Select Expression
- Correlated Subquery Introduction
- Correlated Subquery with Two Tables
- Correlated Subquery Versus Inner Join
- Where IN Operator
- Where Exists Operator
- Where ANY Comparison Modifier
- Where ALL Comparison Modifier
- Subqueries in From – Derived Tables
- Subqueries in From – Derived Tables and Aggregate Functions
- Subqueries in From – Joining Derived Tables
- Subqueries in Having – Introduction
- Subqueries in Having -Correlated
There are two ways to continue, you can either purchase a monthly subscription or unlimited, lifetime usage.
 |
 |
