Book

Learning PostgreSQL 10

This book will familiarize you with the latest new features released in PostgreSQL 10, and get you up and running with building efficient PostgreSQL database solutions from scratch. You will get a complete overview of SQL, client and server side programming in PostgreSQL, as well as some important administration tasks.

Offered byPackt Logo

Difficulty Level

Intermediate

Completion Time

16h16m

Language

English

About Book

Who Is This Book For?

If you're interested in learning more about PostgreSQL, one of the most popular relational databases in the world, then this book is for you. Those looking to build solid database or data warehousing applications with PostgreSQL 10 will also find this book a useful resource. No prior knowledge of database programming or administration is required to get started with this book.

Book content

chapters 16h16m total length

Relational Databases

PostgreSQL in Action

PostgreSQL Basic Building Blocks

PostgreSQL Advanced Building Blocks

SQL Language

Advanced Query Writing

Server-Side Programming with PL/pgSQL

OLAP and Data Warehousing

Beyond Conventional Data types

Transaction isolation, locks and MVCC

PostgreSQL Security

The PostgreSQL System Catalog and System Administration Functions

Optimizing Database Performance

Testing

Using PostgreSQL in Python application

Scalability

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!

No credit card required