EssentialSQL: Subquery Magic - Master SQL Sub Queries.
Subquery MySql, PostgreSQL, SQLite, Microsoft SQL Server | TSQL | Correlated subquery | Inner query | Nested query
4.56 (430 reviews)
3,813
students
2 hours
content
Jun 2024
last update
$69.99
regular price
What you will 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.
Related Topics
1590434
udemy ID
3/10/2018
course created date
3/9/2020
course indexed date
Bot
course submited by