Postgresql Dba Backup, Recovery, Pitr And Performance Tuning

Certified PostgreSQL DBA Certification (CPSDBA) - Module 7 - This Module is also part of PostgreSQL DBA Certification

What you'll learn

Backup, Recovery, PITR

SQL Dump-Large Databases

Point In Time Recovery

Performance Tuning

Hardware Configuration

SQL Tuning

Requirements

Basic SQL & Linux OS, Internet access is required to download PostgreSQL Server and Basic understanding of SQL language is highly recommended but not required

Description

Only Vendor Neutral Training & Certification course for PostgreSQL DBACOURSE FOR BEGINNERS TO EXPERT LEVEL DATABASE PROFESSIONALSPostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. The origins of PostgreSQL date back to 1986 as part of the Postgres project at the University of California at Berkeley and has more than 30 years of active development on the core platform.PostgreSQLCert is a dedicated PostgreSQL Training, Certification & Services division of CertFirst (A leading Global Open Source and Security certification Training Provider). CertFirst became the first company in 2005 to launch a structured PostgreSQL Training & Certification program and has successfully provided hands-on Instructor-led training to hundreds of clients world-wide.Postgresqlcert offers vendor Neutral certification programs so the client can get to learn about all available options in the market NOT just focused on one vendor who is just trying to promote their own products and services. Postgresqlcert goal is provide the best possible non-bias training & certification possible to all its clients.Pre-Requisite:Basic SQL & Linux OSInternet access is required to download PostgreSQL ServerBasic understanding of SQL language is highly recommended but not requiredTarget Audience:Existing Oracle, MySQL or Microsoft DBA’s or new candidates interested in getting certified as a PostgreSQL DBA.Certification Exam Fee: $195 (not Included)This extensive PostgreSQL DBA training & certification program is divided in to several domains. Each video covers a specific specialized topic which will enable candidate to master each domain by learning and then applying this knowledge in the hands-on environment. Local or cloud installation will be required in order to perform all labs.The PostgreSQLCert topic on “PostgreSQL DBA Backup, Recovery, PITR, and Performance Tuning” offers comprehensive coverage of critical aspects of database administration. Firstly, it delves into backup and recovery strategies, equipping participants with the knowledge and skills needed to safeguard data against loss or corruption. This includes understanding various backup methods, implementing robust recovery procedures, and ensuring data integrity through routine backups.Secondly, the topic addresses Point-in-Time Recovery (PITR), allowing participants to learn how to restore databases to specific points in time, providing greater flexibility in recovering from unforeseen incidents.Lastly, the module covers performance tuning techniques, empowering participants to optimize database performance for enhanced efficiency and responsiveness. This includes identifying and resolving performance bottlenecks, tuning queries, and configuring PostgreSQL settings for optimal performance.Overall, this topic prepares participants for the challenges of PostgreSQL database administration, ensuring they are well-equipped to manage backups, recoveries, and performance tuning effectively, while also contributing to their preparation for the PostgreSQL DBA certification program.

Overview

Section 1: Backup, Recovery, PITR

Lecture 1 Backup

Lecture 2 SQL Dump-Large Databases

Lecture 3 Restore-SQL dump

Lecture 4 Point In Time Recovery

Section 2: Performance Tuning

Lecture 5 Hardware Configuration

Lecture 6 SQL Tuning

Lecture 7 PgBouncer

Lecture 8 Review Final Execution Plan

Existing Oracle, MySQL or Microsoft DBA’s or new candidates interested in getting certified as a PostgreSQL DBA.