PostgreSQL Administration Deep Dive

PostgreSQL Administration Deep Dive

English | MP4 | AVC 1920×1080 | AAC 44KHz 2ch | 5h 12m | 1.24 GB

PostgreSQL is the world’s most advanced open source database. With a focus on being open source, standards compliant, and extensible it has become a popular choice across a wide variety of use cases.

In this course we cover how to install, configure, use, and troubleshoot PostgreSQL. Whether you’ve worked with other databases before or are wanting to use PostgreSQL as your first, this course has something for everyone.

Table of Contents

Course.Introduction
1 Course Introduction
2 About the Training Architect

PostgreSQL.Overview
3 CentOS Installation
4 Ubuntu Installation

Technical.Overview
5 Database and RDBMS Introduction
6 PostgreSQL History

Installation.and.Setup
7 PostgreSQL Architecture
8 Clustering Discussion
9 Clients
10 Psql

Configuration
11 Server Configuration
12 Authentication and Authorization
13 Assigning Permissions
14 Database Configuration

Maintenance
15 Vacuuming
16 Indexes
17 Backup and Recovery

Troubleshooting
18 System Catalogs
19 Using pgAdmin

Working.with.Data
20 Database
21 Schema
22 Table
23 View
24 Index

Changing.Data
25 Select
26 Joins

Selecting.Data
27 Insert
28 Update
29 Delete

Programming
30 What’s Next

Conclusion
31 Stored Procedures
32 Triggers
33 Extending SQL