PostgreSQL Fundamentals: SQL Command Line

Go to class
Write Review

PostgreSQL Fundamentals: SQL Command Line provided by AWS Skill Builder is a comprehensive online course, which lasts for Less than 1 hour of material. Upon completion of the course, you can receive an e-certificate from AWS Skill Builder. The course is taught in Englishand is Free Certificate. Visit the course page at AWS Skill Builder for detailed price information.

Overview
  • Intended Audience

    This course is intended for:

    • Database administrators
    • Database developers
    • Database architects
    • Database engineers


    Course Objectives

    In this course, you will learn how to:

    • Use psql - The native, command-line client to postgresql


    Prerequisites

    We recommend that attendees of this course have the following prerequisites:

    • Taken the PostgreSQL Fundamentals course
    • Familiarity with relational databases


    Delivery Method

    This course is delivered through:

    • Digital training


    Duration

    15 minutes

    Course Outline

    This course covers the following concepts:

    • psql client
    • Create a test table
    • List All Tables
    • Describe Tables
    • Make a CSV
    • Expanded Output Mode
    • SET Parameters
    • psqlrc File
    • Prompts
    • Watching Queries
    • Using in Scripts