In this Course you will Learn to:
Know and understand subqueries
Identify subqueries in SQL
Use subqueries in your select statement
Use subqueries in the WHERE clause with EXISTS and IN
Use subqueries with SUM, MAX and other Aggregate functions in GROUP BY and HAVING
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.
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!
By the time you ve completed this course you ll have an appreciation of subqueries, overcome your fear, and able to write correlated queries to make your SQL more robust.
Courses : 4
Specification: Subquery Magic: Write awesome SQL, Master T-SQL Sub Queries
17 reviews for Subquery Magic: Write awesome SQL, Master T-SQL Sub Queries