Font size:

Description:

This is a bundled training package. It contains training for each of the bundled items below:

Course Price
PostgreSQL Database Fundamentals Part #1 $74.95
PostgreSQL Database Fundamentals Part #2 $74.95

Bundle Price: $99.00
Total Savings: $50.90


PostgreSQL Database Fundamentals Part #1

The course covers the downloading, installation and configuration of the PostgreSQL RDBMS. In addition, the course discusses the key PostgreSQL DDL and DML SQL commands, and the deployment of various PostgreSQL table constraints.
  • 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

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.
  • 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
Register Now
PostgreSQL: Getting Started e-learning bundle
  • Course ID:
    271480
  • Duration:
    n/a
  • Price:
    $99