SQL

The Structured Query Language (SQL) is a powerful tool for working with tables in relational databases. Allows you to perform record selections and sorting, calculations, summaries, and join multiple data tables. You can also use SQL to add, edit, and delete records in a table, change their structure, and create new tables. The SQL language includes commonly used basic parts, common for all database systems.

The book covers the deviations of common systems from the SQL standard so that it is universally applicable (it is not oriented to a particular database system). Common systems include Access, MS SQL Server, MySQL, Postgre, or possibly. Visual Fox Pro). Attention is also paid to object-relational mapping.

Individual chapters are always accompanied by a series of examples for independent solutions. The files needed to develop examples in SQL Server and MySQL databases can be found on the Grada website (www.grada.cz). After mastering the book, everyone will be able to retrieve simple reports from the database, sort them according to various criteria, and constrain them according to simple conditions.

The publication may also be useful for web designers, or for the creators of web pages. advanced spreadsheet users. No prior knowledge of database systems is required; The principles of relational databases are described at the beginning of the book.