EssentialSQL: Subquery Magic – Master SQL Sub Queries.

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

Created by: Kris Wenzel
Let me teach you SQL using simple to understand English.

Created by: Essential Sql
Learn everything you need to use SQL in your next project

What Will I Learn?

• Write subqueries to select data from multiple tables.
• Create subqueries to return a single value or multiple values.
• Use subqueries in the SELECT, FROM, WHERE, and HAVING clauses.
• Understand and use correlated subqueries, which depend on values from the outer query.
• Use subqueries to solve problems such as finding maximum or minimum values and records that don't have corresponding entries in other tables.
• Understand the difference between IN, EXISTS, and ANY/ALL operators in subqueries.
• How to use subqueries to create more complex queries and better understand the structure and relationships in a database.

Requirements

• You should already be familiar with SELECT, GROUP BY, and ORDER BY clauses
• If you can write a simple select statement, then you're ready for this course!
• No special equipment needed, all exercises are done online.
• Optional: Install a MySQL, PostgreSQL, or SQL Server learning lab on your own computer.

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!
• Business analysts looking more ways to write queries
• Recent college graduates looking to hone their SQL skills
• Job applicants looking for that extra edge with their next interview!