PostgreSQL is a powerful, open-source, object-relational database system known for being reliable, secure, and flexible. For administrators, learning PostgreSQL equips you with the skills needed to handle complex and high-performance databases in our data-driven world. Big-name companies like Apple, Cisco, Fujitsu, and IBM trust PostgreSQL for their critical applications, which highlights its significance and broad industry adoption. By getting the hang of PostgreSQL, administrators can boost their career opportunities and play a key role in the success of data-focused businesses. PostgreSQL Server Administration is a three-day hands-on course geared for administrators seeking to sharpen their skills and elevate their database management capabilities. Throughout the course you’ll explore a wide range of essential topics, from server architecture and user accounts to monitoring and routine maintenance.
* Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Working in a hands-on learning environment led by our expert facilitator you will:
Gain expertise in managing and maintaining PostgreSQL server architecture, including optimizing performance parameters, memory and disk management, and implementing security best practices. Build proficiency in creating, configuring, and securing user accounts by managing roles, privileges, and authentication methods tailored to an administrator's perspective.
Develop the ability to efficiently monitor database activity, identify performance bottlenecks, and analyze resource usage to ensure optimal database performance.
Acquire skills in routine database maintenance, such as index and table management, vacuuming and analyzing, and handling bloat, to keep the PostgreSQL environment healthy and efficient.
Master backup and restore procedures, including implementing physical and logical backups, point-in-time recovery, and developing disaster recovery plans to ensure data integrity and availability.
Length: 3.0 days (24 hours)
6:00 PM ET