PostgreSQL Database Fundamentals Part #2

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

Prerequisite
None

Expected Duration
163 minutes

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.

Objective

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
  • MONTHLY SUBSCRIPTION

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.