If you Are / Will be Responsible for PostgreSQL and / or an environment of SQL Flavors (MS SQL, Oracle, MySQL, etc.), broaden your Knowledge of SQL implementations by Exploring PostgreSQL. The Benefits Will be Realized in Any SQL arena. Let LinuxCBT DBMS Edition feat. Cost-Effectively PostgreSQL Strengthen your SQL skills. Recommended Prerequisites for LinuxCBT DBMS Edition feat. PostgreSQL: Basic Experience with Linux | Unix or OS Any LinuxCBT Course / EL | SLES | Deb /) Open Mind & Determination to master Linux and related Open-source applications Basic Networking Concepts Understanding of Access to a PC to Follow the exercises
Content
PostgreSQL - DBMS

Introduction - Topology - Features
Identify Key Systems to be Used
Discuss Key features PostgreSQL
Installation
Identify sources
Download & Install
Explore Post-Installation environment
'psql' - Terminal Usage Monitor
Discuss features and Benefits
Connect to PostgreSQL instance
Explore usage
Access Control
Identify configuration
Explore default environment
Enable Subnet access
Evaluate results
Log Configuration
Discuss features and Benefits
peruse default Setup
Alter configuration to log to multiple destinations simultaneously
log data Generate
Evaluate results
Data Types
supported data types Enumerate
Discuss Pros and cons of Various types
Identify types in default configuration
and Compare contrast intra-Category types
SQL - Data Definition Language (DDL) - Constraints
Use CREATE to generate objects
Use DROP to Remove objects
Use ALTER to Structural Change Definitions of ojbects
Define constraints on DB objects to SUIT Storage Requirements
Evaluate results
SQL - Data Manipulation Language ( DML)
Populate tables with INSERT
Bulk-copy items to tables with COPY
Query tables using SELECT
Combine tables with JOINS
Define VIEWS on queries of Interest
Quantify data table with Aggregate Functions
Modify table data using UPDATE
table data using Remove DELETE
Indexes
Discuss features and Benefits
Explore defaults
Generate queries and Miss That hit indices
Create table indices
Evaluate results
PostgreSQL - Functions
and Benefits Discuss features
built-in Explore Functions
Apply Functions to data sets
Nest Functions
Evaluate results
Model: / var / log / messages
Create data Model
Generate SQL schema
& Transform Import data
Perform queries
Write Perl script to parse & transform: / var / log / messages for importation
Install 'libpg' & Update Perl script to Connect to PostgreSQL
Evaluate results
SQL Object Permissions
Extend access Control Discussions
Explore default permissions
Discuss PostgreSQL permissions set-
Use GRANT to assign Test & Various privileges
to Revoke Use unassign & Test Various privileges
Create users and Test Various permissions apply
Evaluate results
DBMS Archival & Restoration
Explore available tools & Methods
Archive: DBs & Tables
Test restorations
cross-platform Restore to Windows
Restore cross-System disparate distribution to
Evaluate results
Security
peruse default clear-text environment with: TCPDump
SSH tunnels to Construct Secure Transport Layer
Initiate 'psql' Sessions Across SSH tunnels
Bolster Security with SSL
Generate usage keys & update PostgreSQL configuration appropo
Test SSL Communications
Intercept SSL traffic with: TCPDump for Analysis
Evaluate results