You will be able to:

• Install, configure and administer a PostgreSQL Cluster.
• Ensure security and compliance through proper use of schema and user privileges.
• Safeguard your data and the ability to recover from disasters using automated backup strategies, complete with SQL Dumps, File System Backups, and Point-In-Time Recovery (PITR), optimized with parallelization.
• Reduce downtime and meet recovery point objectives by restoring from those backups with precision and speed.
• Design and manage PostgreSQL Databases with optimal indexing for highly performant and concurrent operations.
• Create customized database functions and triggers for a variety of needs and scenarios.
• Handle structured and unstructured data using PostgreSQL’s powerful JSON capabilities.

Class Pricing:

• $299 USD for Free members
• $239 USD for Essential & Advantage members (ask for your coupon code)
• FREE for Prime members (just ask to be registered)

Class Outline:

Session 1

• History and Installation

  • Postgresql History

  • Ubuntu Installation

  • Upgrade Information

  • Cluster Details and Basic Management

    • Disk Layout

    • Basic Administration Tasks Using PSQL and Various Binaries

      • Overview of PSQL and PGAdmin

      • Overview of PostgreSQL Cluster Components

      • Useful Binaries for Basic Administration

• Accessing Your Data
  • Making Your Postgresql Cluster Accessible Remotely
  • Basic SELECT
  • DML
  • DDL
  • Overview of Basic Data Types, NULL, and NOSQL Data Types
• Database Objects
  • Creating a Table
    • Primary Keys and Serial Data Type
    • Foreign Key Constraints
    • Constraints Available - Column Constraints & Table Constraints
    • Indexes
    • Temporary Tables
    • Views

Session 2

• Server Side Programming and PL/PgSQL
  • Structure of PL/pgSQL 
  • Functions (SQL and PL/PgSQL)
  • PL/PgSQL Control Structures
  • Triggers and Rules (Event Triggers as well)
  • Procedures
• Transactions, MVCC, WALS and VACUUMing
  • Implicit and Explicit Transactions
    • Transaction Properties, XID Wraparound Problem
    • Transaction Isolation Levels 
    • MVCC and How It Works
  • WALs (Write Ahead Logs) and How Postgresql Handles Persistency and Consistency
  • VACUUM-Manual and Automatic
  • Explain, Explain Analyze and Updating Statistics
• Logging and Auditing
• Backup and Restore

Details: 

Class Hours: There are 4 hours of live, interactive class training divided into two 2-hour sessions.

Skill Level: Knowledge of basic Linux navigation, basic SQL concepts, and general database design is beneficial.

Class Structure: OraPub believes you learn more when you freely and actively engage during the training. This is why each session is full of live demonstrations, lots of Q&A time and hands-on action! If you miss a session, you are free to attend that session when the class is offered again.

Watching Recorded Sessions: Each session is recorded and used to create a unique web page just for your class. The recordings can be streamed using any device, but not downloaded. You can re-watch the videos as many times as you wish. The videos and your unique class web page will be available for three years!

Class Requirements:

You will need:

• An up-to-date modern browser such as Google Chrome, Microsoft Edge, Mozilla Firefox or Apple's Safari.
• The ability to connect to the online training over the internet, hosted by Zoom. You do not need a microphone.