PostgreSQL: SQL + PL/pgSQL for Those Who Want to Become Professionals

This book contains a description of the syntax and rules for applying all the main constructs of SQL and PL/pgSQL. The theoretical part is accompanied by a large number of visual examples, diverse practical tasks, and detailed analyses of their solutions. This allows you to understand which tasks are appropriate for using the respective elements discussed. Each chapter also includes a list of assignments of varying difficulty for self-solving, which will help reinforce theoretical knowledge and gain practical programming skills.

The book can be used both in the educational process when students of IT specialties study the subject "Databases" and for self-learning programming in the PostgreSQL DBMS environment. The material presented in this book is accessible to readers of any level of preparation, and therefore, with some effort, you will come closer to your goal – to become a professional.