MySQL
Adding rows to a table with identity column
INSERT statement
CHAR and VARCHAR
Notes about data types
DATEADD function
T-SQL Datetime functions
Equivalent of recursive CTEs
MySQL. Usage of query variables
INSERT statement
Data modification statements
ROW_NUMBER function
Ranking functions
DATEDIFF function
T-SQL Datetime functions
Equivalents for analytic functions
MySQL. Usage of query variables
Float(n)
Notes about data types
What do you need to work with the textbook?
Introduction
DATEPART function
T-SQL Datetime functions
FULL JOIN and MySQL
Using multiple tables in a query
Integer division
Notes about data types
Performance
MySQL. Usage of query variables
DELETE statement
Data modification statements
MySQL. Usage of query variables
Optimizing
Renaming the columns and calculations in the result set
SELECT statement
CONCAT function
New sql features
Exercise #10 (tips and solutions)
Tips and solutions
The sorting and NULL values
Getting summarizing values
Aggregate function to aggregate function
Getting summarizing values
STRING_AGG function
New sql features