- Добавил: literator
- Дата: 30-12-2024, 03:42
- Комментариев: 0
Название: Essential PostgreSQL: Your guide to database design, query optimization, and administration
Автор: Swati Saxena
Издательство: BPB Publications
Год: 2025
Страниц: 342
Язык: английский
Формат: epub (true)
Размер: 15.5 MB
PostgreSQL, a robust and versatile relational database management system (RDBMS), is gaining immense popularity due to its reliability, scalability, and rich feature set. This book is your indispensable companion to mastering PostgreSQL, helping you become a great PostgreSQL developer and create amazing database-driven applications. This book provides a thorough introduction to PostgreSQL, covering the fundamentals of database creation and management to advanced topics like data modeling, query optimization, and performance tuning. Explore PostgreSQL’s powerful features, including multi-version concurrency control (MVCC), data types, constraints, and indexing. Learn how to install, configure, and apply PostgreSQL in real-world scenarios. You will also develop essential SQL skills to manipulate and analyze data, design efficient schemas with normalization, and use stored procedures and triggers to automate tasks effectively. This book is for anyone who wants to learn or improve their skills in using PostgreSQL.
Автор: Swati Saxena
Издательство: BPB Publications
Год: 2025
Страниц: 342
Язык: английский
Формат: epub (true)
Размер: 15.5 MB
PostgreSQL, a robust and versatile relational database management system (RDBMS), is gaining immense popularity due to its reliability, scalability, and rich feature set. This book is your indispensable companion to mastering PostgreSQL, helping you become a great PostgreSQL developer and create amazing database-driven applications. This book provides a thorough introduction to PostgreSQL, covering the fundamentals of database creation and management to advanced topics like data modeling, query optimization, and performance tuning. Explore PostgreSQL’s powerful features, including multi-version concurrency control (MVCC), data types, constraints, and indexing. Learn how to install, configure, and apply PostgreSQL in real-world scenarios. You will also develop essential SQL skills to manipulate and analyze data, design efficient schemas with normalization, and use stored procedures and triggers to automate tasks effectively. This book is for anyone who wants to learn or improve their skills in using PostgreSQL.