Learn PostgreSQL
This book will get you up and running with the working of relational databases, data modeling, data manipulation, and more. You will learn to build efficient relational database solutions from scratch using the latest features of PostgreSQL 12 and 13. You’ll also be able to identify bottlenecks to enhance the performance of database applications.
Offered by
Difficulty Level
Intermediate
Completion Time
21h40m
Language
English
About Book
Who Is This Book For?
This Postgres book is for anyone interested in learning about the PostgreSQL database from scratch. Anyone looking to build robust data warehousing applications and scale the database for high-availability and performance using the latest features of PostgreSQL will also find this book useful. Although prior knowledge of PostgreSQL is not required, familiarity with databases is expected.
Learn PostgreSQL
- About Book
- Who Is This Book For?
- Book Content
Book content
chapters • 21h40m total length
Introduction to PostgreSQL 12
Getting to know your cluster
Managing users and connections
Basic Statements
Advanced Statements
Window Functions
Server Side Programming
Triggers and Rules
Partitioning
Users, Roles, and Database Security
Transactions, MVCC; WALs and Checkpoints
Extending the database: the Extension ecosystem
Indexes and Performance Optimization
Logging and Auditing
Backup and Restore
Configuring and Monitoring
Physical replication
Logical Replication
Useful Tools and Useful Extensions
Towards PostgreSQL 13
Related Resources
Access Ready-to-Use Books for Free!
Get instant access to a library of pre-built books—free trial, no credit card required. Start training your team in minutes!