• Online, Self-Paced
Course 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.

Learning Objectives

The PostgreSQL Foreign Key Constraint

  • start the course
  • describe the FOREIGN KEY - REFERENCES constraint
  • work with the FOREIGN KEY - REFERENCES constraint

The PostgreSQL SELECT Command

  • 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

PostgreSQL Views

  • create and work with PostgreSQL Views

PostgreSQL Table Indexes

  • create and work with table Indexes

PostgreSQL Security

  • work with object security in PostgreSQL
  • work with PostgreSQL Groups
  • describe the various object-sensitive privileges within PostgreSQL
  • work with Privilege configuration

PostgreSQL Administration

  • 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

Practice: Administer PostgreSQL, Use SELECT

  • work with PostgreSQL tables and manage the PostgreSQL RDBMS

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration
  • Systems Administration