FLEXI - SELF PACED TRAINING RE-IMAGINED

Do you Need Live Online Training? Do you not have Time for Live Online? Do you Want to Start Immediately? Koenig's Flexi can help You.

Flexi is a Video Recording of Live Online + Official Courseware + Hands-On-Labs + Qubits Test

Flexi is a Unique Union of Live Online and On-Demand Learning Options.
Live Online
+
On Demand
=
Flexi

PostgreSQL Database Administration
Power Packed 17:00 Hours (Edited from 40 hours of video content) Recorded on 22-Oct-21

Includes 110+ Tests Questions (Qubits42)
  • 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
  • Details are not available.
  • Moving objects between tablespaces
  • Using materialized views
  • Details are not available.
  • 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
Ravindra Diwan

Certifications

Skills

 
Oracle:Oracle Database 19c: Performance Management and TuningOracle:Oracle Database 19C:Administration Workshop

You will get access to Flexi instantly.

Flexi Video

USD 99

Official Courseware

N/A

Hands-On-Labs

USD 59

Total

USD 99

100% Secure Transaction

Learn more about Koenig. Download Presentation

FAQ's

Q1. How long do you have access to Flexi after purchase?

A. 3 months from date of delivery.

Q2. Can the content be shared or is it only available for one user?

A. It is only for the self-use of the purchaser.

Q3. Do you have business packages that you offer to companies that would make use of these packages on a regular basis?

A. Yes, contact us for corporate packages.

Q4. What is the pass rate of students that used Flexi as their method of preparation?

A. We do not track the pass rate of Flexi students. We, however suspect that it will be lower than for Live Online.

Q5. If we buy Flexi today, and there are any updates in the course, do we get the updated recordings as well or do we need to repurchase Flexi?

A. If the latest update comes within 3 months after the sale we can give the updated version.

Q6. Can we download the videos or we stream them online?

A. Videos can only be streamed and not downloaded.

Q7. Do you have courses in languages other than English?

A. Presently Flexi is only available in English.

Feedbacks from Clients