Categories
shape
shape

PostgreSQL DBA

Students0 Views181

PostgreSQL DBA

About The Course

Trainer Profile:
✓ I am having more than 15+ Years of Experience.
✓ Trained more than 5000+ students in last 10 years.
✓ Strong Theoretical and Practical Knowledge.
✓ I am PostgreSQL DBA Certified Professionals with High Grade.
✓ I have Experienced on multiple real-time projects in IT Industries.
✓ My students are working all over world in multinational companies such as Infosys,
TCS, Wipro, IBM, HCL, Birlasoft, Microsoft, HP, CGI, NTT Data, Philips Technologies
etc
Notes:
• PostgreSQL DBA Course technical content is subject to change without notice.
• This PostgreSQL DBA course also covers the topics required for the PostgreSQL
Database Administrator Certified Exams. Before taking any exam, ensure you have
the recommended experience. The EnterpriseDB website lists all exam requirements
and these are updated regularly. Exams are not included as part of the course.

What Will You Learn?

This PostgreSQL DBA course is basically designed for all people who wants to become

PostgreSQL Database Administrators and who have a basic understanding of a database,

Unix/Linux commands, and SQL commands.

The course provides 100% practical experience in setting up and maintaining a PostgreSQL

server.

Course Curriculam

Section 1: Introduction, Features, History, Uses, and Customers of PostgreSQL

  • What is PostgreSQL?, PostgreSQL Major Features , Milestones , Uses of PostgreSQL Database
    00:00

Section 2: Installing PostgreSQL Using Yum Repository on Red Hat or CentOS

Section 3: Installing PostgreSQL Using Included in Distribution on Red Hat or CentOS

Section 4: Installing PostgreSQL Using Direct RPM on Red Hat or CentOS

Section 5: Installing PostgreSQL Using Source on Red Hat or CentOS

Section 6: Installing PostgreSQL Using Interactive installer & Binaries or zip archive of the binaries by EDB on Windows

Section 7: Access Control and Account Management – Managing Users, Roles, Groups, and Privileges

Section 8: Overview of PostgreSQL Client & Server Applications

Section 9: PostgreSQL Backup and Restore (Physical Backup – Logical Backup)

Section 10: Continuous Archiving and Point-in-Time Recovery (PITR) in PostgreSQL

Section 11: PostgreSQL System Architecture

Section 12: Streaming Replication in PostgreSQL

Section 13: Cascading Replication in PostgreSQL

Section 14: Synchronous Replication in PostgreSQL

Section 15: Logical Replication in PostgreSQL

Section 16: Overview of Partitioning in PostgreSQL & Types of PostgreSQL Partitions

Section 17: Upgrading PostgreSQL from 15 to 16 in Linux

Section 18: Overview of pgAdmin4

Section 19: PostgreSQL Performance Tuning & Optimization Tips

Section 20: Overview of PgBouncer

Section 21: Overview of Pgpool-II

New_Project__2_ removebg preview 100x100

OSDT INDIA

Instructor

15 Courses 0 Student
No Review Yet
No Review Yet