Book

Learning PostgreSQL 11

This book will get you up and running with building efficient relational database solutions right from scratch with the newest features of PostgreSQL 11. You will learn the end-to-end working of relational databases and how to work with database structures. You will also be able to write essential SQL statements, perform data manipulation and do more, with the help of this book.

Offered byPackt Logo

Difficulty Level

Intermediate

Completion Time

18h32m

Language

English

About Book

Who Is This Book For?

This book is for you if you're interested in learning about PostgreSQL from scratch. Those looking to build solid database or data warehousing applications or wanting to get up to speed with the latest features of PostgreSQL 11 will also find this book useful. No prior knowledge of database programming or administration is required to get started.

Book content

chapters 18h32m 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

Transactions and Concurrency Control

PostgreSQL Security

The PostgreSQL Catalog

Optimizing Database Performance

Testing

Using PostgreSQL in Python Applications

Scalability

What's Next?

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