PostgreSQL Database Administration Training

  • Overview

    The PostgreSQL Database Administration course from Koenig allows participants to learn essential skills and information related to PostgreSQL Administration tasks such as: the architecture of PostgreSQL , configuration, installation, monitoring, maintenance, moving data, backup and recovery. This PostgreSQL training imparts core database administration skills to students so that they can successfully fulfill their responsibilities as a PostgreSQL DBA. It provides a strong foundation for advanced learning tracks and a rewarding career as a Database Administrator of PostgreSQL.

    Audience: Those with some experience in database administration but new to PostgreSQL database can also enroll for this course and reap great benefits. Complete beginners who wish to make a career in database administration can also apply for this training.

    Course Objectives

    • Introduction to PostgreSQL
    • System Architecture of PostgreSQL
    • Installation and configuration
    • Create and manage databases
    • Introduction to PgAdmin
    • Security fundamentals
    • Point in time recovery
    • Backup and recovery
    • Using Data Dictionary
    • Routine Maintenance
    • Troubleshooting and Diagnosis

     

    Course Details / Exam(s)

    Schedule for PostgreSQL Database Administration
    Course Regular Track
    (days)
    Koenig course for PostgreSQL Database Administration 5
    Total 5
    Give an edge to your career with technical certifications and training courses. Students can join the classes for PostgreSQL Database Administration Training at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.
  • Students Reviews
    Kay Maxtrol Koenig IT Training Student

    I came for CEH V8 training at Koenig Delhi. A lovely center, I really enjoyed my stay at Koenig and also loved my instructor, his methodology is with a touch of finesse. I will be back at Koenig for...

    Read MoreKay MaxtrolNigeria
    Joaquim Florinda  Koenig IT Training Student

    I came for training at Koenig Delhi. First of all, I would like to thank Koenig staff and the trainers for their services. I have completed Career-Enabler course for MCSE 2012 R2, CCNA, Private...

    Read MoreJoaquim Florinda Angola
    Musab Msallem Koenig IT Training Student

    I came to Koenig Delhi for training on CCNA.  I found about koenig while looking for Cisco courses. I entered koenig without even knowing the difference between a router and a switch. Thanks to...

    Read MoreMusab MsallemLibyan Arab Jamahiriya
    View All Testimonials
  • Schedule & Course Fees
    1
    5
    5
    Classes will be conducted from 09:00 am - 05:00 pm at Your Local Time
    Price includes Courseware.
    For any Query or Custom Plan info@koenig-solutions.com +1 877 226 2244
  • Enquire Now
    * Required Fields
    •  
  • FAQ's

    What is meant by PostgreSQL?

    PostgreSQL is an open source relational database management system (RDBMS) developed by a worldwide team of volunteers.

    PostgreSQL is not controlled by any corporation or other private entity and the source code is available free of charge.

    What platforms does PostgreSQL support?

    In general, any modern Unix-compatible platform should be able to run PostgreSQL.

    PostgreSQL also runs natively on Microsoft Windows NT-based operating systems like Windows XP, Vista, 7, 8, 2003, 2008, etc.

    Is there any certification for PostgreSQL?

    As this technology is not controlled by any specific organization hence there is no common standard certification for postgresql . There are some certification exams conducted by third party organizations.

    Is High Availability possible with PostgreSQL?

    Yes, Replication is supported by Postgre SQL like any other RDBMS.

    Can PostgreSQL provide Point In Time Recovery?

    Yes, It supports PITR as well.

    Can PostgreSQL perform import export?

    Yes, it does so.

    Which tool is used for Backup and Recovery in POstgreSQL?

    PG_basebackup, PG_dump and PG_dumpall are the tools used for Backup and PG_restore is used for Recovery.

    Which Graphical tool is used to query PostgreSQL database?

    There are many, but PGAdmin III is mostly used and we also use it in our course.