MySQL. Practical recipes. Aspin A.

The fundamental ideas of SQL and MySQL are set out. The basic principles of building queries and such basics of SQL as table associations, filtering data for creating advanced queries, formatting requests, building subsistence, generating tables, structuring requests and output of tables are considered. The principles of data analysis using MySQL data sets are described in detail.

Methods of performing complex queries to databases are presented. The use of simple mathematics and logic, multiple filters is shown, data aggregation techniques are described. It is announced how to conduct a sliding analysis, study the time series, as well as manage complex data arrays in MySQL.