{"title":"Oracle - Optimalizace a ladění aplikací","shortDescription":"Cílem kurzu je seznámit účastníky se základními aspekty ovlivňujícími výkonové paramety Oracle, naučit se optimalizovat a kontrolovat existující aplikace pro zlepšení výkonu. Účastníci se naučí interpretovat výsledky exekučních plánů, optimalizovat jednotlivé SQL dotazy a sledovat výkonostní charakteristiky databáze Oracle.<br>Při malém počtu do tří účastníků kurz realizujeme v délce dvou dnů.","description":"<h2>Master Oracle Database Performance and Optimization</h2> \r\n<p>This comprehensive course equips you with essential skills to optimize and fine-tune your Oracle database applications effectively. Gain insights into the architecture and performance monitoring tools that can elevate your database management capabilities.</p> \r\n\r\n<ul> \r\n <li><strong>Target Audience:</strong> Database Administrators, IT professionals, and anyone looking to enhance their Oracle database management skills.</li> \r\n <li><strong>Course Duration:</strong> 3 days</li> \r\n <li><strong>Course Format:</strong> Online</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> Master database architecture, scalable performance, and SQL optimization techniques.</li> \r\n <li><strong>Course Outline:</strong> \r\n <ul> \r\n <li>Planning Oracle</li> \r\n <li>Database System Architecture</li> \r\n <li>Binding Variables in SQL Commands</li> \r\n <li>Performance Scalability</li> \r\n <li>SQL Statistics</li> \r\n <li>Optimizer Techniques</li> \r\n <li>Execution Plans</li> \r\n <li>Performance Monitoring Tools Overview</li> \r\n <li>Automatic Performance Tuning Tools Overview</li> \r\n <li>Working with Indexes</li> \r\n <li>Access Paths to Selected Row Sets</li> \r\n <li>Materialized Views</li> \r\n <li>Locks and Transactions</li> \r\n <li>Using HINT Recommendations</li> \r\n <li>Temporary Tables</li> \r\n <li>Types of Joins in Relational Tables</li> \r\n </ul> \r\n </li> \r\n <li><strong>Bonuses:</strong> Access to exclusive materials and consultations with industry experts.</li> \r\n</ul> \r\n\r\n<p>Join us to take your Oracle database skills to the next level! Sign up today to secure your spot and transform your database management expertise.</p> ","rating":0,"reviewCount":0,"reviews":[]}