PostgreSQL

Live Online (VILT) & Classroom Corporate Training Course

PostgreSQL is a powerful, open source, object-relational database system known for being reliable and precise. It runs on all major operating systems, including Linux, macOS, and Windows.
PostgreSQL Logo

How can we help you?

  • CloudLabs
    CloudLabs
  • Projects
    Projects
  • Assignments
    Assignments
  • 24x7 Support
    24x7 Support
  • Lifetime Access
    Lifetime Access
Box

Overview

PostgreSQL training teaches attendees how to build, query, program stored procedures in PL/pgSQL, and administer the popular, open source PostgreSQL database platform.

Box

Objectives

At the end of PostgreSQL training course, participants will be able to

  • Find PostgreSQL documentation and resources
  • Work with PostgreSQL functions and create own functions
  • Program with PL/pgSQL
  • Install and setup PostgreSQL securely
  • Work with basic administration tasks such as user creation, cataloging, and backing up
  • Use SLONY and PGPOOL
  • Work with inheritance in PostgreSQL
  • Use Tablespaces, EXPLAIN Statement, PITR and monitor the database
  • Tune the PostgreSQL Server
    • Box

    Prerequisites

    Participants must have a solid understanding of basic relational database principles and SQL SELECT statements prior to this training.

    Box

    Course Outline

    • History and Overview
    • PostgreSQL Major Features
    • PostgreSQL Limits
    • PostgreSQL Architecture
    • MVCC
    • Write Ahead Logs
    • The Background Writer
    • PostgreSQL Data Types

    • Overview
    • Binary Installation
    • Source Installation
    • Initializing a PostgreSQL cluster
    • Starting and stopping a PostgreSQL cluster
    • Automatic startup/shutdown

    • Access Control
    • Connection settings
    • Security and Authentication settings
    • Memory settings
    • Kernel resource settings
    • Log management
    • Background writer settings
    • Vacuum cost settings
    • Autovacuum settings

    • Command line parameters
    • Meta commands
    • Security

    • PostgreSQL Clusters
    • PostgreSQL Databases
    • Tables, Joins and Aggregates
    • PostgreSQL Indexes and Foreign Keys

    • Schemas
    • Tables, Views and Rules
    • Users, Groups and Roles
    • Tables and Sequences
    • Object Security

    • Vacuum
    • Tablespaces
    • Inheritance
    • Table Partitioning
    • Windowing Functions
    • Transactions
    • Concurrency Control
    • Functions and Operators
    • Type conversion
    • Full text search

    • Basic DML
    • COPY
    • Other Tools

    • Log Management
    • Query analysis
    • Routine Vacuuming
    • Recovering disk space
    • Managing Planner statistics
    • REINDEX

    • Database Logs
    • OS Process monitoring
    • The PostgreSQL Statistics Collector
    • Statistics Views
    • Statistics Functions

    • OS Tuning
    • Hardware configuration
    • Transaction logs
    • Tablespaces and Partitioning
    • Checkpoint tuning
    • Query tuning

    • The pg_dump utility
    • The pg_dumpall utility
    • Recovery options
    • Point In Time Recovery

    • The pg_upgrade utility
    • RPM based upgrades
    • Source based upgrades
    • Replication based upgrades
    • Rolling back

    • Streaming Replication
    • Synchronous Replication
    • Replication Slots
    • Failover management
    • Connection Poolers
    • HA configurations

    • Overview
    • Triggers

    • Overview
    • Event Triggers

    • Overview
    • SELECT Views
    • Updating a View
    • Materialized Views
    • Rules and privileges

    • Structure
    • Declarations
    • Expressions
    • Statements
    • Control Structures
    • Cursors
    • Errors and Messages
    • Trigger Procedures

    • PL/Perl
    • PL/Python
    • More…

    • Overview of additionally supplied modules
    Box

    Testimonials

    Shamsudeen Bawa

    Synergific Software Team has been very supportive, and working with them has been a best decision that we could ever made, They are just a call away. You guys are AWESOME, Thank You, Keep up the Good Work!!!

    Shamsudeen Bawa

    Vice President, J.P Morgan, CIS, USA

    Farhan Hafiz

    Synergific Software has been of great help and I plan to continue to use your services in the future for my business needs.

    Farhan Hafiz

    Data Architect, Fiserv

    Dr. Sahdev Singh

    I think Synergific Software is great. I liked that it was hassle free and easy to set up. Again, it's a great feature for a fast and cheap set up, which gives me peace of mind, as I know have a terms of use agreement.

    Dr. Sahdev Singh

    Under Secretary, Ministry of Law & Justice, Govt. of India

    M Chikanna Swamy

    I liked using Synergific Software very much. I thought the website was easy to navigate and the instructions for generating the terms was clear. I even recommended you on a Facebook Group I am a member of.

    M Chikanna Swamy

    Director & Learning Head, Mindtree