PostgreSQL E-Learning

Order this amazing, award-winning PostgreSQL E-Learning Training course online, 1 year 24/7 access to extensive interactive videos, speeches, hands-on tasks and progress monitoring. After the course you will receive a certificate of attendance.

The rapid development of data driven applications and commercial web applications requiring back end data support has led to the development of sophisticated database creation and management systems. As the uptake of cloud computing develops, the drive to control cost and improve services heats up, the utilization of consumption-based services and the selection and deployment of freeware applications has gained increasing popularity. PosgreSQL is a fully function RDBMS incorporating database cluster support and replication. Available as a multi-platform application, PostgreSQL can be downloaded, installed and operating as an RDBMS in a relatively short timespan. This course covers the installation and configuration of PostgreSQL, and the fundamentals of PosgreSQL SQL language support, as well as the configuration, administration and development of the supporting databases and tables.

Course content

PostgreSQL Database Fundamentals Part #1

PostgreSQL

Course: 41 Minutes

• Course Introduction
• What is PostgreSQL?
• Downloading and Installing
• Working with PostgreSQL Admin Console
• PostgreSQL Architecture
• PostgreSQL Security

Working with PostgreSQL objects

Course: 53 Minutes

• Creating Database Objects
• Creating Schema Objects
• Data Types and the PRIMARY KEY Constraint
• Creating Tables
• Adding Data to Tables
• Retrieving Data #1
• Retrieving Data #2

Working with PostgreSQL DDL & DML

Course: 59 Minutes

• Data Definition/Manipulation Language
• Working with SQL DDL - CREATE
• Working with SQL DDL - DROP, DELETE, and TRUNCATE
• Working with Default Values
• Working with SQL DDL - ALTER TABLE
• Working with SQL DML - INSERT INTO
• Working with SQL DML - |w - SELECT
• Working with SQL DML |w - UPDATE and DELETE

Working with PostgreSQL Constraints

Course: 31 Minutes

• Constraints
• Constraints - NOT NULL
• Constraints - UNIQUE
• Constraints - CHECK
• Using the SERIAL Data Type

Practice: Deploying PostgreSQL

Course: 5 Minutes

• Exercise: Deploying PostgreSQL

PostgreSQL Database Fundamentals Part #2

The PostgreSQL Foreign Key Constraint

Course: 17 Minutes

• Course Introduction
• Foreign Key Constraint
• FOREIGN KEYS

PostgreSQL SELECT Command

Course: 53 Minutes

• The SELECT Command
• The WHERE Clause #1
• The WHERE Clause #2
• The GROUP BY Clause
• The DISTINCT Option
• The ORDER BY Clause
• SELECT Item Functions

PostgreSQL Views

Course: 6 Minutes

• Working with Views

PostgreSQL Table Indexes

Course: 10 Minutes

• Working with Indexes

PostgreSQL Security

Course: 25 Minutes

• Roles and Users
• Groups
• Privileges in PostgreSQL
• PostgreSQL Privilege in Action

PostgreSQL Administration

Course: 46 Minutes

• Using the Command Line Prompt
• Using the VACUUM Options
• PostgreSQL Data Files
• Object Backup
• Object Restore
• Managing PostgreSQL Objects
• Scripts

Practice: Administer PostgreSQL, Use SELECT

Course: 6 Minutes

• Exercise: Administering PostgreSQL and Using SELECT