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 1
Introduction to databases
Module 4. Working with databases
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
Module 4. Working with databases
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
Module 4. Working with databases
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
Module 4. Working with databases
Level 1,
Lesson 3
LIMIT, OFFSET, SELECT DISTINCT, ORDER BY, ORDER BY across multiple columns
The special null value
Module 4. Working with databases
Level 1,
Lesson 4
No value Compare with NULL IS NULL and IS NOT NULL
Please enable JavaScript to continue using this application.