PostgreSQL Administration Deep Dive

Focused View

Chris Behrens

3:12:15

14 View

1.Course.Introduction

477-5846-1 - Course Introduction.mp4

04:18

477-5846-2 - About the Training Architect.mp4

00:36

2.PostgreSQL.Overview

477-5847-1 - CentOS Installation.mp4

09:10

477-5847-2 - Ubuntu Installation.mp4

05:22

3.Technical.Overview

477-5848-1 - Database and RDBMS Introduction.mp4

06:16

477-5848-2 - PostgreSQL History.mp4

03:57

4.Installation.and.Setup

477-5849-1 - PostgreSQL Architecture.mp4

10:06

477-5849-2 - Clustering Discussion.mp4

09:43

477-5849-3 - Clients.mp4

04:05

477-5849-4 - Psql.mp4

13:01

5.Configuration

477-5850-1 - Server Configuration.mp4

15:54

477-5850-2 - Authentication and Authorization.mp4

06:38

477-5850-3 - Assigning Permissions.mp4

07:12

477-5850-4 - Database Configuration.mp4

05:13

6.Maintenance

477-5851-1 - Vacuuming.mp4

07:19

477-5851-2 - Indexes.mp4

03:10

477-5851-3 - Backup and Recovery.mp4

06:05

7.Troubleshooting

477-5852-1 - System Catalogs.mp4

04:12

477-5852-2 - Using pgAdmin.mp4

03:45

8.Working.with.Data

477-5853-1 - Database.mp4

03:34

477-5853-2 - Schema.mp4

02:29

477-5853-3 - Table.mp4

04:36

477-5853-4 - View.mp4

04:25

477-5853-5 - Index.mp4

05:16

9.Changing.Data

477-5854-1 - Select.mp4

11:45

477-5854-2 - Joins.mp4

06:22

10.Selecting.Data

477-5855-1 - Insert.mp4

05:58

477-5855-2 - Update.mp4

02:28

477-5855-3 - Delete.mp4

02:07

11.Programming

477-5856-1 - Whats Next.mp4

02:59

12.Conclusion

477-5857-1 - Stored Procedures.mp4

04:19

477-5857-2 - Triggers.mp4

05:01

477-5857-3 - Extending SQL.mp4

04:54

Description

Learn how to install, configure, use, and troubleshoot PostgreSQL — the world's most advanced open-source database.

What You'll Learn?

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

PostgreSQL

Database Programming

Chris Behrens

Instructor's Courses

Acloud Guru

View courses Acloud Guru

A Cloud Guru is an online training platform for people interested in Information Technology. Most of the courses offered prepare students to take certification exams for the three major cloud providers.