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