Sub Query Magic: 

Write T-SQL Subqueries Using SQL Server

Take the mystery out of subqueries and take your SQL to the next level

What Will I Learn?

  • Write subqueries and use them in various parts of a query, such as the FROM, WHERE, and HAVING clauses.
  • Gain the confidence to know when to use a subquery.

Description

In this Course you will Learn to:

  • Know and understand subqueries
  • Identify subqueries in SQL
  • Use subqueries in five different places in a SELECT statement
  • Write correlated subqueries (this is a big deal)


Nothing is worse than

  • Being excited to learn something new but not knowing where to start.
  • Wasting time learning the wrong features.
  • Being overwhelmed with options and not know which to use.


Imagine Having...

  • Knowledge - Knowing how to quickly use subqueries to take your SQL to the next level.
  • Confidence - Feeling good that you’re on the right track.
  • Accomplishment - Having a sense of accomplishment that you've learned something most can not.
  • Fun - Actually having fun learning SQL subqueries!


Who is the target audience?

  • Beginner SQL query authors curious about subqueries.
  • If you're struck writing subqueries or baffled by correlated subqueries, then this course is for you!Enter your text here...
Select Columns Layout