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 1
Introduction to databases
SQL & Hibernate
Level 1,
Lesson 0
The history of the emergence of databases: DB and DBMS. Popular DBMS and MySQL. Tables in a database: columns and columns.
SQL language
SQL & Hibernate
Level 1,
Lesson 1
Familiarization with the SQL language Advanced view of SQL query Comments in SQL queries Pronunciation of SQL
WHERE: conditions in SQL queries
SQL & Hibernate
Level 1,
Lesson 2
Value comparison: <, >, =, <> Logical operations AND, OR, NOT BETWEEN: range of values IN: list of values LIKE: pattern of strings
Data Display Control
SQL & Hibernate
Level 1,
Lesson 3
LIMIT, OFFSET, SELECT DISTINCT, ORDER BY, ORDER BY across multiple columns
The special null value
SQL & Hibernate
Level 1,
Lesson 4
No value Compare with NULL IS NULL and IS NOT NULL
Please enable JavaScript to continue using this application.