SQL 201

Already a member with access to this course? Click here to login

What Will I learn?

  • Understand the difference between an inner and outer join.
  • How to use set operators such as UNION, INTERSECT, and EXCEPT.
  • Know when to use a join versus a subquery.
  • Correlated subqueries and their use.
  • How to combine rows from two or more tables into a single result.
  • How to combine columns from two or more tables into a single result.
  • First, Second, and Third Normal form concepts.
  • When to use an outer join.
  • The types of joins and when to use them.
  • Subquery Exists, Any, and All operators

Requirements

The get the most out of this class you should have a basic understanding of SQL.  If you can query a table and sort the results, you’re good-to-go.

Who is the Target Audience?

This course is meant for business analysts, DBA’s, or programmers that want to take their SQL to the next level.

SQL 201 consists of training for people of all skill levels whether you’re a developer or if you’ve never written a single JOIN. This course will benefit you and dramatically boost your confidence writing SQL, allow you to write queries you never thought possible, and take your career to the next level.

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.  You can see the full curriculum here.

Purchase this Course