Considered structured query language to interact with databases - SQL, since the available presentation of the theory of relations (relational theory) and ending with the administration of the database using queries. Practical examples are described in detail the basic structure of language, as well as various types of queries: simple, complex, recursive. It is shown how to perform calculations in a query using aggregate functions and conditional expressions. Consider the operation of sets of records, the connection tables, transactions, stored procedures and other. Attention is paid to administer the database using queries. In the second edition of the added material to work with databases through programs in PHP. Presents problems for independent solution.
show more...Just click on START button on Telegram Bot