PostgreSQL Database Fundamentals Part #1

PostgreSQL Database Fundamentals Part #1

• start the course
• outline the PostgreSQL product
• download and install PostgreSQL
• login to the Administration Console and connect to the default database
• work with the components of the PostgreSQL architecture
• outline security fundamentals for PostgreSQL objects
• create database objects
• create schema objects
• define the various data types and understand the PRIMARY KEY constraint
• create a table
• add data to a table
• retrieve data from tables
• retrieve data using the Query builder tool
• work with SQL DML commands
• working with SQL DML CREATE command in PostgreSQL
• working with SQL DML commands in PostgreSQL
• work with default values for defined columns
• work with the ALTER TABLE command in PostgreSQL
• working with SQL DML INSERT INTO command in PostgreSQL
• working with SQL DML UPDATE and DELETE commands in PostgreSQL
• working with SQL DML SELECT command in PostgreSQL
• describe constraints in PostgreSQL
• work with the NOT NULL constraint
• work with the UNIQUE constraint
• work with CHECK constraints
• work with the SERIAL data type
• define and describe the PostgreSQL DDL commands

PostgreSQL Database Fundamentals Part #2

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