Master Meta-Commands in PostgreSQL

Master Meta-Commands in PostgreSQL

58mIntermediate2023-12-20

Authors

Doug Ortiz

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.

Skills covered

PostgreSQLDatabase DevelopmentDatabase ManagementOpen SourceSoftware DevelopmentOne-Off

Concepts

Introduction

  • Power up your Postgres skills with meta-commands
  • What you should know
  • What are meta-commands

Introduction to Postgres Meta-Commands

  • How to access Postgres meta-commands
  • How to list Postgres meta-commands and a quick overview
  • Challenge - List all databases
  • Solution - List all databases

Overview of Postgres Meta-Commands

  • Meta-commands for analyzing roles
  • Connecting and exploring a database with meta-commands
  • Challenge - Listing Postgres meta-commands
  • Solution - Listing Postgres meta-commands

Managing User Access to Database Objects

  • What is a role
  • Changing a password for a role
  • Granting privileges to a role
  • Revoking privileges to a role
  • Challenge - Managing permissions for a role
  • Solution - Managing permissions for a role

Analyzing Queries Performance

  • Measuring query execution time
  • Display execution plan for an SQL query
  • Setting configuration variables
  • Configure the output format of SQL queries
  • Challenge - Output SQL queries to CSV
  • Solution - Output SQL queries to CSV

Importing, Backing Up, and Restoring

  • Importing data into tables
  • Backing up a database
  • Restoring a database
  • Challenge - Back up and restore a database
  • Solution - Back up and restore a database

Conclusion

  • Next steps
40,000 Toman