PostgreSQL Database Fundamentals Part #2 from Skillsoft

Online, Self-Paced

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

Implementation and Operation

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