Master Meta-Commands in PostgreSQL

Focused View

Doug Ortiz

58:31

14 View

01 - Introduction

01 - Power up your Postgres skills with meta-commands.mp4

00:35

02 - What you should know.mp4

01:58

03 - What are meta-commands.mp4

02:03

02 - 1. Introduction to Postgres Meta-Commands

01 - How to access Postgres meta-commands.mp4

01:26

02 - How to list Postgres meta-commands and a quick overview.mp4

01:38

03 - Challenge List all databases.mp4

01:38

04 - Solution List all databases.mp4

03:45

03 - 2. Overview of Postgres Meta-Commands

01 - Meta-commands for analyzing roles.mp4

02:13

02 - Connecting and exploring a database with meta-commands.mp4

02:36

03 - Challenge Listing Postgres meta-commands.mp4

01:16

04 - Solution Listing Postgres meta-commands.mp4

01:47

04 - 3. Managing User Access to Database Objects

01 - What is a role.mp4

01:40

02 - Changing a password for a role.mp4

01:43

03 - Granting privileges to a role.mp4

01:13

04 - Revoking privileges to a role.mp4

01:34

05 - Challenge Managing permissions for a role.mp4

01:33

06 - Solution Managing permissions for a role.mp4

01:33

05 - 4. Analyzing Queries Performance

01 - Measuring query execution time.mp4

01:31

02 - Display execution plan for an SQL query.mp4

02:42

03 - Setting configuration variables.mp4

02:51

04 - Configure the output format of SQL queries.mp4

02:31

05 - Challenge Output SQL queries to CSV.mp4

01:22

06 - Solution Output SQL queries to CSV.mp4

02:37

06 - 5. Importing, Backing Up, and Restoring

01 - Importing data into tables.mp4

02:24

02 - Backing up a database.mp4

02:34

03 - Restoring a database.mp4

03:25

04 - Challenge Back up and restore a database.mp4

00:43

05 - Solution Back up and restore a database.mp4

03:57

07 - Conclusion

01 - Next steps.mp4

01:43

Description

If you manage a relational database in PostgreSQL, you need to know how to utilize the extensive functionality and power of meta-commands. In this course, instructor Doug Ortiz provides a comprehensive overview of the concept of meta-commands and shows you how to start incorporating them into your everyday workflow to manage your database more efficiently and effectively.

Explore ways to streamline your productivity using meta-commands to manage user access to database objects, analyze query performance, and import, back up, and restore your data, as needed, to secure your data and prevent future loss. Along the way, test out your new skills in the practice challenges at the end of each section of the course.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

PostgreSQL

Doug Ortiz

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.