The basics of database technologies. Tutorial

Postgres Professional presents a training course covering the theoretical foundations of databases, transactions management and ensuring data consistency, accessing access, issues of application interaction with DBMS. It is considered both the classic relational model of data and its expansion, including object ones. The book contains a brief introduction into the SQL language.
A reader who studies the basics of database technologies on this book will receive not only fundamental knowledge, but also an idea and how the theory is realized and practice. All information is illustrated by the example of a high -performance DBMS with open code PostgreSQL. Examples of code use a specially developed demonstration database. Practical tasks for each chapter help to fix the material covered.
The course is designed for data developers and DBMS, as well as for university students with basic programming training