Subquery Magic: Write awesome SQL, Master T-SQL Sub Queries (Udemy.com)
Take the mystery out of subqueries & take your SQL to the next level. Use SQL Server & write data driven nested queries.
Created by: Kris Wenzel
Produced in 2021
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.
Quality Score
Overall Score : 86 / 100
Course Description
- 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)
- 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. 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!
Instructor Details
- 4.3 Rating
116 Reviews
Kris Wenzel
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
Students also recommend
-
Intro to SQL: Querying and managing data (2015)
-
0.0 (0 Reviews)
-
Provider: Khan Academy
Time: 1h
Free
More courses by Kris Wenzel
Stored Procedures Unpacked: Learn to Code T-SQL Stored Procs (2021)
4.2 (94 Reviews)
- Provider: Udemy
- Time: 3.5h
$11.99
Reviews
- Video Duration:
2.5h - Price: 11.99 Track Price 11.99 Track Price
- Provider: Udemy
- Year:
2021 - Language:
English, English [Auto-generated] - Certificate:
Yes
30-Day Money-Back Guarantee
Udemy Coupon Price Tracker
