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

Live Online
+
On Demand
=
Flexi

PostgreSQL Database Administration

Includes:

  1. Power Packed 13 Hours (Edited from 40 hours of Live Training)
  2. 110+ Tests Questions (Qubits42)
  3. 6 months access to recordings.
  4. Access via Laptop, Tab, Mobile, and Smart TV.
  5. Certificate of completion.
  6. Official Courseware
  7. Hands-on labs
You can also purchase an annual plan for USD 999. For one year, all Flexi Videos will be free for you. Buy Annual Plan

You will get access to Flexi Video instantly.

Flexi Video

USD 199

Official Courseware

USD 19

Hands-On-Labs

USD 59

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 3: Getting Started
  • Installing the PostgreSQL Server
  • Setting Environment Variables
  • Creating a Cluster
  • Running Server
  • Connection Settings
  • Security and Authentication
  • Resource Settings
  • WAL
  • Error Reporting and Logging
  • Autovacuum
  • Runtime Statistics, etc.
  • Postgres hosed based access configuration
  • Introduction To PSQL
  • Moving objects between tablespaces
  • Using materialized views
  • Accessing objects in other PostgreSQL databases (postgres_fdw, dblink)
  • File_fdw, hstore, pgcrypto,etc
  • User Management
  • Preventing Connections
  • Checking secure password
  • Auditing Changes
  • Encrypting Sensitive data
  • Real-time viewing using pgAdmin
  • Checking whether a user is connected
  • Checking which queries are running
  • Checking which queries are active or blocked
  • Knowing who is blocking a query
  • Killing a specific session
  • Knowing when a table was last used
  • Usage of disk space by temporary data
  • Understanding why queries slow down
  • Producing a daily summary of log file errors
  • Analyzing the real-time performance of your queries
  • Find and Tune Slow Running Queries
  • Collecting regular statistics from pg_stat* views
  • Finding out what makes SQL slow
  • Speeding up queries without rewriting them
  • Discovering why a query is not using an index
  • Forcing a query to use an index
  • Controlling automatic database maintenance
  • Removing issues that cause bloat
  • Identifying and fixing bloated tables and indexes
  • Monitoring and tuning vacuum
  • Updating Table Statistics
  • Vacuuming
  • Re-indexing
  • Planning backups
  • Backup Types
  • Restore
  • Exporting/Importing Data To/From A Flat File
  • Replication
  • Handling Switchover & Failover
  • Upgrading Best Practices
  • Migration from Oracle to Postgres using Ora2PG

Learn more about Koenig. Download Presentation Buy Other Flexi

FAQ's

Yes, you do. Flexi Videos do not include Course-Book or Labs.
6 months from the date of delivery.
Videos can only be streamed and not downloaded.
Flexi video for the new version will be provided free of cost.
We do not track the pass rate of Flexi students. However, we trust it will be lower than for Live Online.
You will be provided access to LET ( Learning Enhancement Tool), where you will get the links to access all your purchases.
Yes, Course-Book and Lab are not included in the annual plan. All Flexi videos are included.
It is only for one user.
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.
Presently, Flexi is only available in English.
Yes, contact us for corporate packages.
We use the best standards in Internet security. Any data retained is not shared with third parties.
Yes, you do. Flexi Videos do not include Courseware or Labs.
Yes, c/w and Lab are not included in the annual plan. All Flexi videos are included.
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