وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

Master Meta-Commands in PostgreSQL

سرفصل های دوره

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.


01 - Introduction
  • 01 - Power up your Postgres skills with meta-commands
  • 02 - What you should know
  • 03 - What are meta-commands

  • 02 - 1. Introduction to Postgres Meta-Commands
  • 01 - How to access Postgres meta-commands
  • 02 - How to list Postgres meta-commands and a quick overview
  • 03 - Challenge List all databases
  • 04 - Solution List all databases

  • 03 - 2. Overview of Postgres Meta-Commands
  • 01 - Meta-commands for analyzing roles
  • 02 - Connecting and exploring a database with meta-commands
  • 03 - Challenge Listing Postgres meta-commands
  • 04 - Solution Listing Postgres meta-commands

  • 04 - 3. Managing User Access to Database Objects
  • 01 - What is a role
  • 02 - Changing a password for a role
  • 03 - Granting privileges to a role
  • 04 - Revoking privileges to a role
  • 05 - Challenge Managing permissions for a role
  • 06 - Solution Managing permissions for a role

  • 05 - 4. Analyzing Queries Performance
  • 01 - Measuring query execution time
  • 02 - Display execution plan for an SQL query
  • 03 - Setting configuration variables
  • 04 - Configure the output format of SQL queries
  • 05 - Challenge Output SQL queries to CSV
  • 06 - Solution Output SQL queries to CSV

  • 06 - 5. Importing, Backing Up, and Restoring
  • 01 - Importing data into tables
  • 02 - Backing up a database
  • 03 - Restoring a database
  • 04 - Challenge Back up and restore a database
  • 05 - Solution Back up and restore a database

  • 07 - Conclusion
  • 01 - Next steps
  • 45,900 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 33610
    حجم: 97 مگابایت
    مدت زمان: 59 دقیقه
    تاریخ انتشار: 7 فروردین 1403
    دیگر آموزش های این مدرس
    طراحی سایت و خدمات سئو

    45,900 تومان
    افزودن به سبد خرید