Get Started Learning SQL Server Curriculum - EssentialSQL Online Courses

Get Started Learning SQL Server Curriculum

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.