Special offers now — see discounted courses.
day
:
hour
:
min
:
sec
See special offers
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

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

Related learn paths

About us

LyndaKade is a leading learning platform that helps people learn business, software, technology, and creative skills to achieve personal and professional goals.

Phone numberAparat ChannelTelegram SupportTelegram ChannelInstagram Page

All rights to this site belong to LyndaKade.

Terms of Service|Privacy Policy

نماد الکترونیک enamad در صورت اتصال با آی‌پی داخل کشور، نمایش داده خواهد شد.
logo-samandehi - لوگو ساماندهی
zarinpal
zibal