Search Engine



RedhatEnterpriseLinux Blog

LinuxCBT PostgreSQL Edition Free CBT Download

LinuxCBT PostgreSQL Edition Free CBT Download

LinuxCBT DBMS Edition feat. PostgreSQL focuses on the implementation of PostgreSQL DBMS.

PostgreSQL is a widely used open source ORDBMS engine due to its: non-commercial implications, flexible license, long academic development history @ UC Berkeley, object-oriented and relational nature, cross-platform prowess and considerable scalability.
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. PostgreSQL cost-effectively strengthen your SQL skills.

Course Objective

PostgreSQL - DBMS

    Introduction - Topology - Features
        Identify key systems to be used
        Discuss key PostgreSQL features

        Identify sources
        Download & Install
        Explore post-installation environment
'psql' - Terminal Monitor Usage   
        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 simultaneously to multiple destinations
        Generate log data
        Evaluate results
Data Types
    Enumerate supported data types
    Discuss pros and cons of various types
    Identify types in default configuration
    Compare and contrast intra-category types

SQL - Data Definition Language (DDL) - Constraints
    Use CREATE to generate objects
    Use DROP to remove objects
    Use ALTER to change structural 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 table data with Aggregate Functions
    Modify table data using UPDATE
    Remove table data using DELETE

    Discuss features and benefits
    Explore defaults
    Generate queries that hit and miss indices
    Create table indices
    Evaluate results

PostgreSQL - Functions
    Discuss features and benefits
    Explore built-in 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
    Use Revoke to unassign & test various privileges
    Create test users and apply various permissions
    Evaluate results

 DBMS Archival & Restoration
    Explore available tools & methods
    Archive: DBs & Tables
    Test restorations
    Restore cross-platform to Windows
    Restore cross-system to disparate distribution
    Evaluate results

    Peruse default clear-text environment with: TCPDump
    Construct SSH tunnels to 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


Post a Comment

Powered by Blogger.


Copyright © Redhat Enterprise linux. Original Concept and Design by My Blogger Themes
My name is Abdul Razaq but people call me Raziq. Here is my home page: I live in Quetta, Pakistan and work as an IT-Engineer.