MySQL. Practical Recipes

The fundamental ideas of SQL and MySQL are presented. Basic principles of query construction and fundamental aspects of SQL such as table joins, data filtering for creating complex queries, query formatting, subquery construction, generation of derived tables, structuring queries, and outputting tables are considered. Principles of data analysis using MySQL datasets are described in detail. Techniques for executing complex queries on databases are presented. The use of simple mathematics and logic, multiple filters, and data aggregation techniques are discussed. It explains how to conduct rolling analysis, study time series, and manage complex data arrays in MySQL.

For developers and database administrators, programmers