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
Resolve the captcha to access the links!