Lessons

Change the column names. Table aliases. primary key.

Prerequisites for the appearance of the JOIN operator. Introduction to the JOIN operator.

Reasons for OUTER JOIN. JOIN types. Interview question.

Nested queries in SQL. Subquery with a scalar result. Subquery with a list of values.

The subquery returns a table. Using the WITH statement.

Introduction to data types in SQL. Numeric types in SQL. String types in SQL. Temporary types in SQL. Storing objects in SQL.

List of numeric functions. Arithmetic operations. bit operations. rounding functions.

List of functions for working with date and time Calling functions Grouping data by year and month

Looking for events in the last 30 days. How to find the difference between two dates.

List of string functions. Let's convert the string. Complex actions with strings.

The principle of constructing SQL lectures and everything, everything, everything Behind the brackets

Oracle. MySQL. PostgreSQL. NoSQL.