Learning PostgreSQL 10 - Second Edition: A beginner's guide to building high-performance PostgreSQL database solutions
Salahaldin Juba, Andrey Volkov · 2017 · 488 pages
As an Amazon Associate we earn from qualifying purchases. Some book links are affiliate links; you pay the same price and we may earn a small commission.
About this book
Leverage the power of PostgreSQL 10 to build powerful database and data warehousing applications.About This Book* Be introduced to the concept of relational databases and PostgreSQL, one of the fastest growing open source databases in the world* Learn client-side and server-side programming in PostgreSQL, and how to administer PostgreSQL databases* Discover tips on implementing efficient database solutions with PostgreSQL 10Who This Book Is ForIf 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.What You Will Learn* Understand the fundamentals of relational databases, relational algebra, and data modeling* Install a PostgreSQL cluster, create a database, and implement your data model* Create tables and views, define indexes, and implement triggers, stored procedures, and other schema objects* Use the Structured Query Language (SQL) to manipulate data in the database* Implement business logic on the server side with triggers and stored procedures using PL/pgSQL* Make use of advanced data types supported by PostgreSQL 10: Arrays, hstore, JSONB, and others* Develop OLAP database solutions using the most recent features of PostgreSQL 10* Connect your Python a
Appears in these reading paths
The Best Books to Learn PostgreSQL, In Order
Related reading guides
Reader reviews
Ratings and notes from readers — tagged with how deep into the subject they were.
Loading reviews…