Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Free Learning

You're reading from Learning PostgreSQL 10 A beginner's guide to building high-performance PostgreSQL database solutions

Product type Paperback

Published in Dec 2017

Publisher

ISBN-13 9781788392013

Length 488 pages

Edition 2nd Edition

Languages

Tools

PostgreSQL

Concepts

Database Programming

Authors (2):

Andrey Volkov

Salahaldin Juba

View More author details

Table of Contents (17) Chapters

Preface

1. Relational Databases FREE CHAPTER

2. PostgreSQL in Action

3. PostgreSQL Basic Building Blocks

4. PostgreSQL Advanced Building Blocks

5. SQL Language

6. Advanced Query Writing

7. Server-Side Programming with PL/pgSQL

8. OLAP and Data Warehousing

9. Beyond Conventional Data Types

10. Transactions and Concurrency Control

11. PostgreSQL Security

12. The PostgreSQL Catalog

13. Optimizing Database Performance

14. Testing

15. Using PostgreSQL in Python Applications

16. Scalability

The car web portal database

At this stage, one can convert the logical model of the car web portal presented in Chapter 01, Relational Databases, to a physical model. To help the developer to create a table, one can follow this minimal checklist:

What is the primary key?
What is the default value for each column?
What is the type of each column?
What are the constraints on each column or set of columns?
Are permissions set correctly on tables, sequences, and schemas?
Are foreign keys specified with the proper actions?
What is the data life cycle?
What are the operations allowed on the data?

To create the car web portal schema, the formal relational model will not be applied strictly. Also, surrogate keys will be used instead of natural keys. The advantages for using surrogate keys is as follows:

Natural keys can change; one can change the current email address to another...

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (2)

Juba

Salahaldin Juba has over than a decade of experience in the industry and academia, with a focus on database development for large-scale and enterprise applications. He holds a master's degree of science in environmental management with a distinction, and a bachelor's degree of engineering in computer systems. He is also a Microsoft Certified Solution Developer (MCSD). He has worked mainly with SQL server, PostgreSQL, and Greenplum databases. As a software engineer, he works mainly with defining ETL processes with external parties, promoting SQL best practices, designing OLTP and OLAP applications, and providing training and consultation services.

See other products by Juba

Volkov

Andrey Volkov studied information systems in banking, and started his career as a financial analyst at a commercial bank. He joined a data warehouse team, and after some time, he lead the team by taking the position of the data warehouse architect. There he worked mainly with Oracle database stack and used it to develop logical and physical models of financial and accounting data, implement them in the database, develop ETL processes, and perform analytical tasks. Now Andrey works as a senior database developer at a telecommunication provider. There, he works mainly with PostgreSQL databases, being responsible for data modeling, developing a data warehouse, reporting, and billing systems.

See other products by Volkov