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
Related courses
- React: Web Workers
- React: Advanced Code Challenges
- Responsible AI Framework for Your Enterprise AI Product
- Microsoft SQL Server 2019 Essential Training
- MongoDB Aggregation Pipeline: Advanced Data Analysis and Manipulation
- Learning Debian Linux
- Linux System Engineer: Advanced Disk Systems and System Backup
- V-Ray 3.0 for 3ds Max Essential Training
Related learn paths
- Introduction to Fundamental Skills for Data Work: Data Analysis and Interpretation
- Become a Data Analytics Specialist
- Building AI Products: Prototyping Essentials Professional Certificate
- Advance Your Skills in HTML
- Master Dashboards and Data Viz in Power BI
- Getting Started with AI and Machine Learning
- Master Microsoft Power BI
- Master Python for Data Science