PostgreSQL Database Fundamentals Part #2


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description
This course details the SQL SELECT statement (command), and discusses PostgreSQL security. In addition, the course demonstrates the creation of PostgreSQL VIEWS and table INDEXES, and covers a number of essential database administration tasks.

Target Audience
Information workers interested in developing fundamental skills in the Sequel Query language (SQL) using the PostgreSQL Relational Database Management System (RDBMS) and database engine.

Prerequisites
None

Expected Duration (hours)
2.7

Lesson Objectives

PostgreSQL Database Fundamentals Part #2

  • start the course
  • describe the FOREIGN KEY - REFERENCES constraint
  • work with the FOREIGN KEY - REFERENCES constraint
  • describe the more advance options of the SELECT command
  • work with the WHERE clause
  • work with the WHERE clause
  • work with the GROUP BY clause
  • Use the DISTINCT option
  • utilize the ORDER BY clause
  • work with aggregate functions, operators and column labels
  • create and work with PostgreSQL Views
  • create and work with table Indexes
  • work with object security in PostgreSQL
  • work with PostgreSQL Groups
  • describe the various object-sensitive privileges within PostgreSQL
  • work with Privilege configuration
  • work with the command line option (psql)
  • work with the VACUUM command
  • work with the PostgreSQL data and configuration files
  • backup PostgreSQL objects
  • restore PostgreSQL object
  • remove database objects
  • work with scripts
  • work with reports
  • work with PostgreSQL tables and manage the PostgreSQL RDBMS

    • Course Number:
    df_post_a02_it_enus

    Expertise Level
    Beginner