Master Meta-Commands in PostgreSQL
58mIntermediate2023-12-20
Authors
Doug Ortiz
Course details
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.
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.
Skills covered
PostgreSQLDatabase DevelopmentDatabase ManagementOpen SourceSoftware DevelopmentOne-Off
Concepts
0. Introduction
- 01 - Power up your Postgres skills with meta-commands
- 02 - What you should know
- 03 - What are meta-commands
1. Introduction to Postgres Meta-Commands
- 04 - How to access Postgres meta-commands
- 05 - How to list Postgres meta-commands and a quick overview
- 06 - Challenge - List all databases
- 07 - Solution - List all databases
2. Overview of Postgres Meta-Commands
- 08 - Meta-commands for analyzing roles
- 09 - Connecting and exploring a database with meta-commands
- 10 - Challenge - Listing Postgres meta-commands
- 11 - Solution - Listing Postgres meta-commands
3. Managing User Access to Database Objects
- 12 - What is a role
- 13 - Changing a password for a role
- 14 - Granting privileges to a role
- 15 - Revoking privileges to a role
- 16 - Challenge - Managing permissions for a role
- 17 - Solution - Managing permissions for a role
4. Analyzing Queries Performance
- 18 - Measuring query execution time
- 19 - Display execution plan for an SQL query
- 20 - Setting configuration variables
- 21 - Configure the output format of SQL queries
- 22 - Challenge - Output SQL queries to CSV
- 23 - Solution - Output SQL queries to CSV
5. Importing, Backing Up, and Restoring
- 24 - Importing data into tables
- 25 - Backing up a database
- 26 - Restoring a database
- 27 - Challenge - Back up and restore a database
- 28 - Solution - Back up and restore a database
Conclusion
- 29 - Next steps