PostgreSQL Database Administration
Details
This 4-day course is a fast-paced dive into PostgreSQL. Class sessions cover basic administration topics as well as more advanced techniques including backup and recovery, PITR, and high-availability configurations. Work with hands-on lab exercises that solidify PostgreSQL administration best practices.
Intended Audience
Database Administrator, Programmers, Developers and Open Source Technology Specialists.
Course Prerequisites For PostgreSQL Database Administration
- Basic SQL, Linux, and bash shell competency
Outline
- Installing PostgreSQL Server and Client
- Comparison of installation methods
- Demonstration of installation
- Hands-on installation exercise
- Administration Tools and Options
- psql options
- pg_env.sh
- Other PostgreSQL command line utilities
- Configuring a PostgreSQL Cluster
- Review components of a PostgreSQL cluster
- Initialize and run a cluster
- SQL in PostgreSQL
- DDL
- DML
- Running queries in psql
- PostgreSQL data types
- Creating and using views
- Cluster Security
- Enabling remote connections to cluster
- Host-based authentication (pg_hba.conf)
- User Security
- Creating users
- Using and assigning user roles
- User authentication
- Backup and Recovery Methods
- Selecting an effective backup approach
- Logical backup
- Physical backup
- PostgreSQL Optimization
- VACUUM
- EXPLAIN
- High Availability Configuration and Operation
- Setting up streaming replication
- Master-Standby replication
- Triggering failover
- Logical replication (New for PostgreSQL 10!)
- Upgrading PostgreSQL
- Minor version upgrades
- Major version upgrades
- pg_upgrade utility
- Continuous Archiving and Point-in-Time Recovery (PITR)
- Setting up WAL archiving
- Running a base backup
- Recovery from a continuous archive
NetCom Learning helps build innovative learning organizations in the workplace by structuring a smarter workforce, supporting learning changes, and driving learning growth. Since 1998 we have been empowering organizations to reach optimal performance results and address challenges by managing all aspects of organizational learning.
NetCom Learning is honored to be recognized as Microsoft's Worldwide Training Partner of the Year by Microsoft and as a Top 20 IT Training Company by TrainingIndustry.com for three years. We offer over 1,500 courses available to organizations around the world, encompassing all your technology and business training needs. From authorized or foundational training to specialized certifications, we empower organizations to achieve a competitive advantage. In addition, we provide customers with a choice of customized private programs, convenient scheduling options, flexible delivery formats, and continuous learning support, all tailored towards minimizing the skills gap and gaining maximum business impact for your organization. ...