Promotion
CodeGym University
Learning
Course
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
Quest map
Lessons
Level 3
Selecting data from multiple tables
SQL & Hibernate
Level 3,
Lesson 0
dependent table. Query on multiple tables. We remove meaningless lines.
Aliases
SQL & Hibernate
Level 3,
Lesson 1
Change the column names. Table aliases. primary key.
JOIN statement
SQL & Hibernate
Level 3,
Lesson 2
Prerequisites for the appearance of the JOIN operator. Introduction to the JOIN operator.
OUTER JOIN statement
SQL & Hibernate
Level 3,
Lesson 3
Reasons for OUTER JOIN. JOIN types. Interview question.
Subqueries
SQL & Hibernate
Level 3,
Lesson 4
Nested queries in SQL. Subquery with a scalar result. Subquery with a list of values.
Subqueries with tables
SQL & Hibernate
Level 3,
Lesson 5
The subquery returns a table. Using the WITH statement.
Please enable JavaScript to continue using this application.