Subscription

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Newsletter 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 (4):

Salahaldin Juba

Isabel Maria Duarte Rosa

Andrey Volkov

Sheldon Strauch

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

Database coding

The software engineering principles should be applied on database coding. This is important to keep the code clean and to speed development cycles. This section will address several issues such as naming convention, documentation, and version control.

If you are familiar with these concepts, feel free to skip the section. Some of these principles are:

Database naming conventions

A naming convention describes how names are to be formulated. Naming conventions allow some information to be derived based on patterns, which helps the developer to easily search for and predict the database object names. Database naming conventions should be standardized across the organization. There is a lot of debate on how to...

The rest of the chapter is locked

Tech Concepts

Programming languages

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

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 €18.99/month. Cancel anytime

Authors (4)

Salahaldin 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 Salahaldin Juba

Isabel Maria Duarte Rosa

Please write your Reviewer Biography here using the following guidelines. Please save this file as ISBN_Reviewer Bio_Reviewer Name. Dr. Isabel M.D. Rosa is a research associate at Imperial College London and one of the co-founders of Earthindicators technologies. She has a PhD in Computational Ecology from Imperial College London, and extensive experience in data mining and predictive modeling. For the last five years Dr. Rosa has been working as a researcher at Imperial College London. During her academic career Dr. Rosa acquired several skills, such as statistical analyses, programming (R, C++, Python), geographic information systems (ArcGIS and QGIS), and databases (PostgreSQL/PostGIS, SQLServer). Dr. Rosa is also the lead author, as well as co-author, of several scientific papers published in top-quality scientific journals such as Global Change Biology. Dr. Rosa has also presented her work at several international and national scientific conferences, and she is the lead coordinator of the London Land Use Forum.

See other products by Isabel Maria Duarte Rosa

Andrey 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 Andrey Volkov

Sheldon Strauch

Sheldon Strauch is a twenty-year veteran of software consulting at companies such as IBM, Sears, Ernst & Young, and Kraft Foods. He has a Bachelor's degree in Business Administration and leverages his technical skills to improve business' self-awareness. His interests include data gathering, management, and mining; maps and mapping; business intelligence; and the application of data analysis for continuous improvement. He is currently focused on the development of end-to-end data management and mining at Enova International, a financial services company located in Chicago. In his spare time, he enjoys the performing arts, particularly music, and traveling with his wife Marilyn.

See other products by Sheldon Strauch