{"title":"PostgreSQL - High Performance, zálohování a replikace ","shortDescription":"Tento kurz je určen pokročilejším uživatelům a vývojářům, kteří používají PostgreSQL. Zabývá se obecněji otázkou výkonu datově orientovaných aplikací postavených nad relační databází a možnostmi zálohování. V kurzu si rovněž posluchači prakticky vyzkouší konfiguraci vestavěné replikace.","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":[]}