Flexi is a Video Recording of Live Online + Official Courseware + Hands-on Labs

Live Online
+
On Demand
=
Flexi

Postgresql Plus Advanced Server

Includes:

  1. 6 months access to recordings.
  2. Access via Laptop, Tab, Mobile, and Smart TV.
  3. Certificate of completion.
  4. Official Courseware
  5. Hands-on labs

We do not have a fresh Live Online Recording for the course. It can take 4-5 days to edit a recording. If your need is urgent, request for an un-edited version.


Postgresql Plus Advanced Server is a Rare course. Hence priced at $199. Other Flexis are for $99.
You can also purchase an annual plan for USD 999. For one year, all Flexi Videos will be free for you. Buy Annual Plan

Flexi Video

USD 199

Official Courseware

N/A

Hands-On-Labs

NA

Total

USD 199

100% Refund for Flexi Video (courseware is non-refundable) if user is not satisfied with the Video and seeks refund within 30 days of purchase.

Download Course Contents
Module 1: Introduction
  • History of PostgreSQL
  • Major Features
  • New Features of PostgreSQL
  • Multi Version Concurrency Control
  • Write-Ahead Logging
  • Architectural Overview
  • Limits
  • Architectural Summary
  • Shared Memory
  • Statement Processing
  • Utility Processes
  • Disk Read Buffering
  • Write Buffering
  • Background Writer Cleaning Scan
  • Commit & Checkpoint
  • Physical Database Architecture
  • Data Directory Layout
  • Installation Directory Layout
  • Page Layout
  • OS User & Permissions
  • Installation
  • Setting environment variables
  • Clusters
  • Creating a database cluster
  • Starting and Stopping the Server
  • (pg_ctl)
  • Connect to the server using psql
  • Setting PostgreSQL Parameters
  • Access Contro
  • Connection Settings
  • Security and Authentication
  • Settings
  • Memory Settings
  • Query Planner Settings
  • WAL Settings
  • Log Management
  • Background Writer Settings
  • Statement Behavior
  • Vacuum Cost Settings
  • Autovacuum Settings
  • Object Hierarchy
  • Creating Databases
  • Creating Schemas
  • Schema Search Path
  • Roles, Users & Groups
  • Access Control
  • The System Catalog Schema
  • System Information views/tables
  • System Information Functions
  • Introduction
  • Conventions
  • Connecting to PostgreSQL
  • PSQL Command Line Parameters
  • Entering PSQL Commands
  • PSQL Meta-Commands
  • PSQL SET Parameters
  • Information Commands
  • Registering a server
  • Viewing and Editing Data
  • Query Tool
  • Databases
  • Languages
  • Schemas
  • Domains
  • Functions
  • Sequences
  • Tables
  • Columns
  • Constraints
  • Indexes
  • Maintenance
  • Rules
  • Triggers
  • Types
  • Views
  • Table spaces
  • Roles
  • Authentication
  • Authorization
  • Levels of security
  • pg_hba.conf file
  • Users
  • Object ownership
  • Access control
  • Application access parameters
  • Data Types
  • Tables
  • SQL Queries
  • Quoting
  • Using SQL Functions
  • Constraints
  • Dropping or Removing Database
  • Objects
  • Views
  • Sequences
  • Indexes
  • Backup Types
  • SQL Dump
  • Cluster Dump
  • Offline Copy Backup
  • Continuous Archiving
  • pg_basebackup
  • Point-In Time Recovery
  • pg_upgrade
  • Explain and Explain Analyze
  • Table Statistics
  • Updating Planner Statistics
  • Scheduling Auto Vacuum
  • Preventing Transaction ID Wraparound Failures
  • The Visibility Map
  • Routine Reindexing
  • Installing Third-Party Drivers
  • Installation & Configuration of JDBC & ODBC Drivers
  • Transaction Definition
  • Effects of Concurrency on
  • Transactions
  • Transaction Isolation Levels
  • Multi-Version Concurrency Control
  • Overview (MVCC)
  • MVCC Example
  • Internal Identifiers
  • Transaction Wraparound
  • MVCC Maintenance
  • MVCC Demo
  • Hardware Configuration
  • OS Configuration
  • Server Parameter Tuning
  • Connection Settings
  • Memory Parameters
  • Memory settings for Planner
  • WAL Parameters
  • Explain Plan
  • Explain Example
  • Statistics Collection
  • Indexes
  • Examining Index Usage
  • Tips for Inserting Large Amount of Data
  • Some Notes About pg_dump Non-Durable Settings
  • Labs
  • Database High Availability
  • Causes of Data Loss
  • Plan for Common Errors
  • Selection Criteria
  • High Availability Options
  • Hot Streaming Replication, Architecture and Setup
  • Streaming Replication Example
  • Partitioning
  • Partitioning Methods
  • When to Partition
  • Partitioning Setup
  • Partitioning Example
  • Partitioning and Constraint
  • Exclusion
  • Caveats
  • Lab
  • Pgpool-II
  • Pgpool-II Features
  • Install and Configure pgpool-II
  • Pgpool II Modes
  • Starting/Stopping pgpool-II
  • Pgpool-II Example
  • Database Statistics
  • The Statistics Collector
  • Database Statistic Tables
  • Operating System Process Monitoring
  • Current Sessions and Locks
  • Log Slow Running Queries
  • Disk Usage
  • EDB MTK Oracle to PostgreSQL
  • Enterprise Failover Manager
  • XDB Replication
  • BART

Learn more about Koenig. Download Presentation Buy Other Flexi

FAQ's

Yes, you can pay from this web page.
Yes, the site is secure by utilizing Secure Sockets Layer (SSL) Technology. SSL technology enables the encryption of sensitive information during online transactions. We use the highest assurance SSL/TLS certificate, which ensures that no unauthorized person can get to your sensitive payment data over the web.
We use the best standards in Internet security. Any data retained is not shared with third parties.
You will be provided access to LET ( Learning Enhancement Tool), where you will get the links to access all your purchases.
Flexi video for the new version will be provided free of cost.
6 months from the date of delivery.
Yes, you do. Flexi Videos do not include Courseware or Labs.
Yes, contact us for corporate packages.
Yes, c/w and Lab are not included in the annual plan. All Flexi videos are included.
It is only for one user.
Videos can only be streamed and not downloaded.
We do not track the pass rate of Flexi students. However, we trust it will be lower than for Live Online.
Presently, Flexi is only available in English.
It’s a unique subscription plan where customers can avail unlimited Flexi courses within a year.
The subscription plan is valid for 1 year from the date of purchase.
No, this is limited to one user and its non-transferable.

Feedbacks from Clients