Veze, linkovi
Kompjuter biblioteka
Korpa
Learning PostgreSQL 11 - Third Edition

Baze podataka Baze podataka

Learning PostgreSQL 11 - Third Edition

Autor: Andrey Volkov, Salahadin Juba
Broj strana: 556
ISBN broj: 9781789535464
Izdavač: PACKT PUBLISHING PACKT PUBLISHING
Godina izdanja: 2019.

Pregleda (30 dana / ukupno): 31 / 181

                 
Twitter   Facebook   Linkedin   Pinterest   Email
                 
Predlog za prevod

 

  • Understand the basics of relational databases, relational algebra, and data modeling
  • Install a PostgreSQL server, create a database, and implement your data model
  • Create tables and views, define indexes and stored procedures, and implement triggers
  • Make use of advanced data types such as Arrays, hstore, and JSONB
  • Connect your Python applications to PostgreSQL and work with data efficiently
  • Identify bottlenecks to enhance reliability and performance of database applications

PostgreSQL is one of the most popular open source database management systems in the world, and it supports advanced features included in SQL standards. This book will familiarize you with the latest features in PostgreSQL 11, and get you up and running with building efficient PostgreSQL database solutions from scratch. Learning PostgreSQL, 11 begins by covering the concepts of relational databases and their core principles. You’ll explore the Data Definition Language (DDL) and commonly used DDL commands supported by ANSI SQL. You’ll also learn how to create tables, define integrity constraints, build indexes, and set up views and other schema objects. As you advance, you’ll come to understand Data Manipulation Language (DML) and server-side programming capabilities using PL/pgSQL, giving you a robust background to develop, tune, test, and troubleshoot your database application. The book will guide you in exploring NoSQL capabilities and connecting to your database to manipulate data objects. You’ll get to grips with using data warehousing in analytical solutions and reports, and scaling the database for high availability and performance. By the end of this book, you’ll have gained a thorough understanding of PostgreSQL 11 and developed the necessary skills to build efficient database solutions.

  • Monitor, secure, and fine-tune your PostgreSQL 11 database
  • Learn client-side and server-side programming using SQL and PL/pgSQL
  • Discover tips on implementing efficient database solutions

Table of contents

1 Relational Databases
Database management systems
Relational and object-relational databases
Relational algebra
Data modeling
Summary
Questions

2 PostgreSQL in Action
An overview of PostgreSQL
PostgreSQL capabilities
Installing PostgreSQL
Summary
Questions 

3 PostgreSQL Basic Building Blocks
Database coding
PostgreSQL object hierarchy
PostgreSQL database components
PostgreSQL native data types
The car web portal database
Summary
Questions

4 PostgreSQL Advanced Building Blocks
Views
Indexes
Functions
User-defined data types
Trigger and rule systems
Summary
Questions

5 SQL Language
SQL fundamentals
Querying data with SELECT statements
Changing the data in a database
Summary
Questions

6 Advanced Query Writing
Common table expressions
Window functions
Advanced SQL techniques
Summary
Questions

7 Server-Side Programming with PL/pgSQL
The SQL language and PL/pgSQL – a comparison
Functions and procedures – a comparison
PostgreSQL function parameters
The PostgreSQL PL/pgSQL control statements
Function predefined variables
Exception handling
Dynamic SQL
Summary
Questions

8 OLAP and Data Warehousing
OLTP and OLAP
Online analytical processing
Partitioning
Parallel query
Index-only scans
Summary
Questions

9 Beyond Conventional Data Types
Arrays
The hash store data structure
The JSON data structure
A PostgreSQL full-text search
Summary
Questions

10 Transactions and Concurrency Control
Transactions
Explicit locking
Transaction in functions and procedures
Summary
Questions

11 PostgreSQL Security
Authentication in PostgreSQL
Authentication best practices
PostgreSQL default access privileges
Role system and proxy authentication
PostgreSQL security levels
Encrypting data
Summary
Questions

12 The PostgreSQL Catalog
The system catalog
System catalog for administrators
Cleaning up the database
Tuning for performance 
Selective dump
Summary 
Questions 

13 Optimizing Database Performance
PostgreSQL configuration tuning
Tuning performance for write
Tuning performance for read 
Detecting problems in query plans
Common mistakes in writing queries
Table partitioning
Query rewriting
Summary
Questions

14 Testing
Technical requirements
Unit testing
Database-abstraction interfaces
Summary
Questions

15 Using PostgreSQL in Python Applications
Technical requirements
Python DB-API 2.0
Low-level database access with Psycopg 2
Alternative drivers for PostgreSQL
Object-relational mapping with SQLAlchemy
Summary
Questions

16 Scalability
Technical requirements
The problem of scalability and the CAP theorem
Data replication in PostgreSQL
Building a scalable PostgreSQL solution
Summary
Questions
Further reading

17 What's Next?
Fundamentals
Working with PostgreSQL software
Working with data in PostgreSQL databases
Summary

 

Budite prvi koji će ostaviti komentar.

Ostavite komentar Ostavite komentar

 

Preporučujemo

Everyday Data Structures

Everyday Data Structures

PostgreSQL Developers Guide

PostgreSQL Developers Guide

Veze, linkovi
Linkedin Twitter Facebook
 
     
 
© Sva prava pridržana, Kompjuter biblioteka, Beograd, Obalskih radnika 4a, Telefon: +381 11 252 0 272