SQL. A Beginner's Course.

The book outlines the fundamentals of working with relational databases and the practical application of SQL in the most in-demand scenarios.
It discusses the principles of data storage, table structure, and methods of retrieving information. It provides a detailed description of... selection, filtering, sorting, grouping, and aggregation operations, working with text and numeric data, date processing, and the use of expressions and conditions. The mechanisms of joining tables, the features of various types of JOIN, and ways to combine selections are thoroughly examined.
It describes the creation and modification of tables, setting constraints, indexes, and auto-increment fields, as well as the principles of adding, updating, and deleting data.
Reference information is provided on data types, the order of query execution, plans and statistics, transactions and ACID requirements, as well as the basics of client-server architecture.

Author: Ольга Назина

Printhouse: BHV

Age restrictions: 12+

Year of publication: 2026

ISBN: 9785977521055

Number of pages: 576

Size: 233х165х27 mm

Cover type: soft

Weight: 744 g

ID: 1732815

The book outlines the fundamentals of working with relational databases and the practical application of SQL in the most in-demand scenarios.

It discusses the principles of data storage, table structure, and methods of retrieving information. It provides a detailed description of selection, filtering, sorting, grouping, and aggregation operations, working with text and numeric data, date processing, and the use of expressions and conditions. The mechanisms of joining tables, the features of various types of JOIN, and ways to combine selections are thoroughly examined.

It describes the creation and modification of tables, setting constraints, indexes, and auto-increment fields, as well as the principles of adding, updating, and deleting data.

Reference information is provided on data types, the order of query execution, plans and statistics, transactions and ACID requirements, as well as the basics of client-server architecture.

Sold out

€ 28.89

Sold out

€ 28.89