AI Academy
Promotion
CodeGym University
Learning
Courses
Tasks
Surveys & Quizzes
Games
Help
Schedule
Community
Users
Forum
Chat
Articles
Success stories
Activity
Reviews
Subscriptions
Light theme
Lessons
Reviews
About us
Start
Start learning
Start learning now
My Progress
Courses
University
Quest Map
Lessons
SQL
SQL
Level 13
What are nested queries and why do we need them?
SQL SELF
Level 13,
Lesson 0
In this lesson, you'll find out what nested queries (or subqueries) in SQL are, why we need them, what types of nested queries exist, and how they help you solve tricky problems when working with databases.
Using
SELECT
inside
SELECT
SQL SELF
Level 13,
Lesson 1
Learn how to use subqueries in SELECT to calculate aggregates, create extra columns, and do analytics right in your SQL queries. Examples are for a university training database.
Filtering data with
IN
and
NOT IN
SQL SELF
Level 13,
Lesson 2
Learn how to use the
IN
and
NOT IN
operators in SQL to filter data efficiently, shorten long conditions, and make your queries more readable. We'll check out some examples, special cases with
NULL
, and some best practices.
Checking if Data Exists with
EXISTS
and
NOT EXISTS
SQL SELF
Level 13,
Lesson 3
Learn how to use the
EXISTS
and
NOT EXISTS
operators in SQL to efficiently check for data existence, compare with
IN
, and avoid common mistakes when working with subqueries. Examples, explanations, and real-world tasks — all in one lecture!
Views (`VIEW`) in PostgreSQL
SQL SELF
Level 13,
Lesson 4
Learn how to use views (VIEW) in PostgreSQL to make complex SQL queries simpler, boost code readability, reuse selections, and control access to data. Real-life examples, tips, and what you need to know about updatable VIEWs.
Please enable JavaScript to continue using this application.