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