The course consists of 7 modules covering 30 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?
- Introduction to SSMS (SQL Server Management Studio)
- Arranging Windows in SSMS
- Exploring the Database using SSMS
- Creating and Running Queries
- Writing you First Query
- Filtering Your Results
- Sorting Results
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