Ready recipes for solving practical problems when working with Oracle DBMS, DB2, SQL Server, MySQL and PostgreSQL are considered. Extracting records from tables, sorting query results, principles of working with multiple tables, and processing queries with metadata are described. Describes how to search for data using SQL, compiling reports and formatting result sets, and working with hierarchical queries. The use of window functions, generalized table expressions (GTE), collecting data into blocks, forming histograms, running sums and subtotals, and aggregation of a sliding range of values is considered. The traversal of a string and its parsing into symbols are described, and ways to simplify calculations within a string are given.

The second edition takes into account all changes in the syntax and architecture of current SQL implementations.

For programmers, developers and database administrators