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.

How can we help you?

Thanks for sharing your details. Our team will get in touch with you soon.
There was an error trying to send your message. Please try again later.

  • CloudLabs

  • Projects

  • Assignments

  • 24x7 Support

  • Lifetime Access

PostgreSQL

Overview

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

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

Prerequisites

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

Course Outline

Introduction and Architecture2021-06-28T12:39:11+05:30
  • History and Overview
  • PostgreSQL Major Features
  • PostgreSQL Limits
  • PostgreSQL Architecture
  • MVCC
  • Write Ahead Logs
  • The Background Writer
  • PostgreSQL Data Types
Installation2021-06-28T12:41:58+05:30
  • Overview
  • Binary Installation
  • Source Installation
  • Initializing a PostgreSQL cluster
  • Starting and stopping a PostgreSQL cluster
  • Automatic startup/shutdown
Configuration2021-06-28T12:42:05+05:30
  • Access Control
  • Connection settings
  • Security and Authentication settings
  • Memory settings
  • Kernel resource settings
  • Log management
  • Background writer settings
  • Vacuum cost settings
  • Autovacuum settings
Intro to psql2021-06-28T12:42:11+05:30
  • Command line parameters
  • Meta commands
  • Security
Managing PostgreSQL Databases2021-06-28T12:42:19+05:30
  • PostgreSQL Clusters
  • PostgreSQL Databases
  • Tables, Joins and Aggregates
  • PostgreSQL Indexes and Foreign Keys
Roles and Security2021-06-28T12:42:28+05:30
  • Schemas
  • Tables, Views and Rules
  • Users, Groups and Roles
  • Tables and Sequences
  • Object Security
Tablespaces, Partitioning, and Advanced Features2021-06-28T12:42:36+05:30
  • Vacuum
  • Tablespaces
  • Inheritance
  • Table Partitioning
  • Windowing Functions
  • Transactions
  • Concurrency Control
  • Functions and Operators
  • Type conversion
  • Full text search
Moving Data with PostgreSQL2021-06-28T12:42:44+05:30
  • Basic DML
  • COPY
  • Other Tools
Routine DBA Tasks and Best Practices2021-06-28T12:42:52+05:30
  • Log Management
  • Query analysis
  • Routine Vacuuming
  • Recovering disk space
  • Managing Planner statistics
  • REINDEX
Monitoring and Statistics2021-06-28T12:45:28+05:30
  • Database Logs
  • OS Process monitoring
  • The PostgreSQL Statistics Collector
  • Statistics Views
  • Statistics Functions
Performance Tuning2021-06-28T12:45:35+05:30
  • OS Tuning
  • Hardware configuration
  • Transaction logs
  • Tablespaces and Partitioning
  • Checkpoint tuning
  • Query tuning
Backup and Recovery2021-06-28T12:45:42+05:30
  • The pg_dump utility
  • The pg_dumpall utility
  • Recovery options
  • Point In Time Recovery
PostgreSQL Upgrades2021-06-28T12:45:50+05:30
  • The pg_upgrade utility
  • RPM based upgrades
  • Source based upgrades
  • Replication based upgrades
  • Rolling back
Replication and HA2021-06-28T12:45:55+05:30
  • Streaming Replication
  • Synchronous Replication
  • Replication Slots
  • Failover management
  • Connection Poolers
  • HA configurations
Triggers2021-06-28T12:46:02+05:30
  • Overview
  • Triggers
Event Triggers2021-06-28T12:46:08+05:30
  • Overview
  • Event Triggers
RULEs2021-06-28T12:46:18+05:30
  • Overview
  • SELECT Views
  • Updating a View
  • Materialized Views
  • Rules and privileges
The PL/pgSQL Language2021-06-28T12:47:27+05:30
  • Structure
  • Declarations
  • Expressions
  • Statements
  • Control Structures
  • Cursors
  • Errors and Messages
  • Trigger Procedures
Other Procedural Languages2021-06-28T12:47:33+05:30
  • PL/Perl
  • PL/Python
  • More…
PostgreSQL Contribs2021-06-28T12:47:38+05:30
  • Overview of additionally supplied modules
2023-01-06T15:28:16+05:30

Go to Top