SQL 201 Curriculum - EssentialSQL Online Courses

SQL 201 Curriculum

The course consists of 4 modules covering 40 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.

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

 

Buy this Course Today