{"title":"PostgreSQL - High Performance, backup and replication","shortDescription":"This course is intended for advanced users and developers who use PostgreSQL. It generally addresses the performance issues of data-oriented applications built on top of a relational database and backup options. In the course, participants will also practically test the configuration of built-in replication.","description":"<h2>Mastering PostgreSQL Performance: Backup and Replication Strategies</h2>\r\n<p>Unlock the full potential of your PostgreSQL database with our intensive course on high-performance strategies for backup and replication. Acquired knowledge will elevate your database management skills and enhance your application’s efficiency.</p>\r\n\r\n<ul>\r\n <li><strong>Target Audience:</strong> Database Administrators, System Architects, IT Professionals</li>\r\n <li><strong>Course Duration:</strong> 2 days</li>\r\n <li><strong>Course Format:</strong> Online with virtual participation option available</li>\r\n <li><strong>Certification:</strong> Yes</li>\r\n</ul>\r\n\r\n<h3>Detailed Course Description</h3>\r\n<ul>\r\n <li><strong>Skills Gained:</strong> Techniques for performance optimization, effective backup strategies, replication configuration, analytical troubleshooting skills</li>\r\n <li><strong>Course Outline:</strong>\r\n <ul>\r\n <li>Key factors influencing database performance</li>\r\n <li>Application layers and their impact</li>\r\n <li>Understanding CPU, RAM, IO, and NET configuration</li>\r\n <li>Optimal PostgreSQL configuration for high performance</li>\r\n <li>Identifying bottlenecks and solutions</li>\r\n <li>Effective use of cache and materialized views</li>\r\n <li>Writing index-friendly applications and practical indexing techniques</li>\r\n <li>Exploring Cost-Based Optimizer and correcting estimate errors</li>\r\n <li>Monitoring strategies for ongoing performance assessment</li>\r\n <li>Backup techniques and replication approaches</li>\r\n <li>Transactional log export configuration and pg_basebackup</li>\r\n <li>Using Barman for backup management</li>\r\n <li>Setting up built-in replication options</li>\r\n <li>Combining replication with transactional log export</li>\r\n <li>Utilizing pg_rewind for data recovery</li>\r\n </ul>\r\n </li>\r\n <li><strong>Bonuses:</strong> Access to comprehensive learning materials, expert-led Q&A sessions, continuous support during and after the course</li>\r\n</ul>\r\n\r\n<p>Join us to transform your PostgreSQL skills and ensure your database performs at its peak efficiency. Secure your spot today and propel your career forward!</p>","rating":0,"reviewCount":0,"reviews":[]}