List of lectures for the course SQL, 14 quest level on JavaRush

Using subqueries in SELECT
SQL SELF
14 level,0 lecture
Learn how to use subqueries in SELECT to calculate aggregated values, count related records, and create dynamic columns right in your SQL queries. Detailed examples, optimization tips, and common pitfalls.
Open
Using subqueries in FROM
SQL SELF
14 level,1 lecture
Learn how to effectively use subqueries in the FROM clause to create on-the-fly temporary tables, perform complex aggregations, and simplify your SQL queries without having to create separate tables in your database.
Open
Using Subqueries in HAVING to Filter Aggregated Data
SQL SELF
14 level,2 lecture
In this lecture, you'll learn how to use subqueries in HAVING to filter aggregated data in SQL. We'll look at the difference between WHERE and HAVING, learn how to build complex analytical queries with subqueries, break down examples and common mistakes, and also talk about optimizing these queries.
Open
Examples of Complex Nested Queries: Combining EXISTS, IN, HAVING
SQL SELF
14 level,3 lecture
Learn how to combine subqueries with EXISTS, IN, and HAVING to solve tricky SQL problems. Using a university database as an example, we’ll break down how to filter, group, and optimize queries for real-world analytics tasks.
Open
Typical Mistakes When Working with Subqueries
SQL SELF
14 level,4 lecture
In this lecture, you'll learn about the most common mistakes when working with subqueries in SQL: from syntax slip-ups to logical traps and performance issues. We'll break down examples, explain why mistakes happen, and give you tips on how to avoid them.
Open