Live Online Style Video +Live Instructor + Official Course-Book + Hands-on Labs

PostgreSQL Database Administration

Includes:

  1. Power Packed 13 Hours (Edited from 40 hours of Live Training)
  2. 6 months access to videos.
  3. Access via Laptop, Tab, Mobile, and Smart TV.
  4. Certificate of Completion.
  5. Official Course-Book
  6. Hands-on labs
  7. 110+ Tests Questions (Qubits42)
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 within 30 minutes.

Flexi Video

USD 199

Official Course-Book Instructor Hand-outs

USD 0

Hands-On-Labs

USD 59

Total

USD 199

100% Refund for Flexi Video (Course-Book 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
Sushmitha Gopala

Skills

 
Microsoft:Database Administration FundamentalsOracle:Oracle 12c R2: RAC Administration
Oracle:Oracle 19c Golden Gate FundamentalsOracle:Oracle Cloud Infrastructure Introduction
Oracle:Oracle Database 11g: RAC Administration Release 2 NEWOracle:Oracle Database 12c R2: Clusterware & ASM Admin Accelerated Ed 2
Oracle:Oracle Database 12c R2: RAC Administration Ed 2Oracle:Oracle Database 12c: Administration Workshop Ed 2
Oracle:Oracle Database 12c: ASM Administration Ed 1.1Oracle:Oracle Database 12c: Clusterware & RAC Admin Accelerated
Oracle:Oracle Database 12c: Performance Management and Tuning Ed 1Oracle:Oracle Database 12c: SQL Fundamentals I
Oracle:Oracle Database 18c: Administration WorkshopOracle:Oracle Database 19c: Administration Workshop
Oracle:Oracle Database 19c: ASM Administration WorkshopOracle:Oracle Database 19c: Clusterware Administration Workshop
Oracle:Oracle Database 19c: RAC Administration WorkshopOracle:Oracle Database: Managing Multitenant Architecture Ed 1
Oracle:Oracle GoldenGate 12c: Fundamentals for Oracle Ed 2Oracle:Oracle GoldenGate 19c: Fundamentals for Oracle

Learn more about Koenig. Download Presentation Buy Other Flexi

FAQ's

Yes, you do. Flexi Videos do not include Courseware 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.
Yes, c/w and Lab are not included in the annual plan. All Flexi videos are included.
You will be provided access to LET ( Learning Enhancement Tool), where you will get the links to access all your purchases.
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.
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