Skip to content
Write a review
UdemySQLPaid courseAll LevelsCertificate

EssentialSQL: Subquery Magic - Master SQL Sub Queries. (Udemy.com)

Subquery MySql, PostgreSQL, SQLite, Microsoft SQL Server | TSQL | Correlated subquery | Inner query | Nested query

4.6
439 reviews

Created by: Kris Wenzel

Last updated June 2024

icon
What you will 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 sub query.
  • Solve complex problems, such as incorporating one query's results, into another's filter criteria.
  • How to write a correlated subquery (this is a big deal)
  • Solve problems, otherwise impossible to solve using SQL alone, using sub queries.

How it compares

Against the other 388 rated Udemy courses in SQL on CourseDuck:

  • Rating4.6 out of 5higher than 69% of them
  • Reviews439#219 of 389 by number of reviews
  • Length2.2 hoursshorter than 82% of them
  • Last updatedJune 2024more recently than 57% of them

icon
Course Description

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.
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!


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. Who this course is for:
  • Beginner SQL query authors curious about subqueries.
  • If you're struck writing subqueries or baffled by correlated subqueries, then this course is for you!
Read More All Levels All Levels product length iconTime: 2.2h

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

placeholder

Hello my name is Kris. I'm here because I am passionate about helping non-techie people to overcome their fear of learning SQL.
Let Me Help you Get Started on the Right Foot!
I know what it is like to not know where to start or whether the time spent learning is worth the effort. That is why I am here to help you to:
Get started in an easy to follow step-by-step manner.
Use your time wisely so you focus on what is important to learn to get the most value from your time.
Answer your questions. Really! Just post a comment and I'll respond. I'm here to help.
It wasn't long ago that I was helping a colleague with some reporting. She didn't know where to start and soon got overwhelmed and lost as she didn't know SQL.
I felt really bad, as she was under pressure to get some summary information to her boss, the built-in reports were falling short, and to make them better would require her to know SQL. At that time that seemed impossible! It in dawned on me, it doesn't have to be that way.
Then I discovered a way for anyone with the desire to easily learn SQL. I worked with my co-worker, started to teach her what I learned and soon she was able to write reports and answer her boss' questions without getting stressed or ploughing hours into manipulating data in Excel.
It hasn't always been easy. Sometimes the information seems abstract or too conceptual. In this case I've found out that a visual explanation is best. I really like to use diag

Read More

icon
More courses by Kris Wenzel

$11.99

$74.99

$54.99

$54.99

All courses by Kris Wenzel

icon
Reviews

4.6

439 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By Jonathan Roberts on 11/22/2020

So far, so good. A good refresher on subqueries.

By Joseph Piarulli on 11/8/2020

Easy to understand explanations and I can tell this will help me in mastering SQL subqueries for my job.

By Ravi Bidari on 10/10/2020

Good

By Yoseph Amhatsion on 9/4/2020

The course material is explained in detail. It's Amazing!

By Squirrelpatrick on 8/27/2020

Kris Wenzel teaches well and the course delivers, I am giving four stars as this is a quite a narrow topic and there isn't a great deal of material here.

By Shyam Shivakumar on 8/8/2020

More examples should be added.

By Mohammed Khan on 8/5/2020

Easy explanation.

By Aimee Guffey on 8/5/2020

Definitely feeling more confident in using subqueries. Can't wait to learn more!

By Mei Wu on 7/21/2020

Excellent instructions. Highly recommended!

By Rene Henriquez on 7/18/2020

good explanations but no practice problems to reinforce material

By Christophe Frick on 6/24/2020

I am learning new stuff. 6 of one half dozen of another examples between correlated and inner join don't really clarify the real world use case. Its all very "hello world" so far. I am not able to explain S demo as it isn't really a subquery to another table. in SQL a is basically not a missing or zero it is more of an unknown. So, Where Exists (Select ) is inherently true in the SQL definition of but kinda useless without a context to either how it might mislead you in the real world or be of value to you in the real world. I don't see the real world value of that demo at all without meaningful context. Really not helping on the Nulls. There is an actual definition of what is. It would help to start with that. IN is a list. Exists is true false. I think this was sort of over explained.

By Sue Nelson on 6/14/2020

Good match

Showing 12 of 116 reviews

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 92 / 100

EssentialSQL: Subquery Magic - Master SQL Sub Queries.
Visit course on Udemy Write a review
  • Video Duration: icon 2.2h
  • Price: $64.99
  • Provider: icon Udemy
  • Updated: icon June 2024
  • Level: All Levels All Levels
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com