{"title":"Oracle databáze - programování v PL/SQL","shortDescription":"Školení programování v <strong>PL/SQL - procedurální jazyk vyvinutý společností Oracle</strong> pro práci s její databázovou platformou. Jazyk PL/SQL je postaven na SQL (Structured Query Language) a umožňuje vytvářet uložené procedury, funkce, triggery, balíčky a další objekty, které výrazně rozšiřují možnosti práce s databází.","description":"<h2>Master PL/SQL Programming: Enhance Your Database Skills</h2>\n\n<p>Elevate your database programming expertise with our comprehensive PL/SQL course. This hands-on training is designed for professionals looking to deepen their understanding of Oracle databases and improve their programming capabilities.</p>\n\n<ul>\n <li><strong>Target Audience:</strong> Database developers, IT professionals, and anyone interested in mastering PL/SQL.</li>\n <li><strong>Course Duration:</strong> 3 days</li>\n <li><strong>Course Format:</strong> Online</li>\n <li><strong>Certification:</strong> Yes</li>\n</ul>\n\n<h3>Detailed Course Description:</h3>\n\n<ul>\n <li><strong>Skills Gained:</strong> Participants will learn advanced querying techniques, transaction control, exception handling, and how to create stored procedures, functions, and triggers in PL/SQL.</li>\n <li><strong>Course Outline:</strong>\n <ul>\n <li>Review SQL language properties and advanced querying methods</li>\n <li>Introduction to PL/SQL: structure, environment, and features</li>\n <li>Data retrieval techniques in PL/SQL</li>\n <li>Transaction management</li>\n <li>Control structures: IF statements, loops, and flow control</li>\n <li>Exception handling methodologies</li>\n <li>Creating and using stored procedures and functions</li>\n <li>Triggers: creation and implementation</li>\n <li>Creating packages and their advantages</li>\n <li>Working with files through UTL_FILE</li>\n <li>Utilizing dynamic SQL commands</li>\n <li>Manipulating Large Objects (LOBs)</li>\n <li>Implementing DIRECTORY objects for accessing BFILE objects</li>\n </ul>\n </li>\n <li><strong>Bonuses:</strong> Access to course materials, additional resources, and post-course consultations.</li>\n</ul>\n\n<p>Unlock new career opportunities and enhance your technical skills! Sign up today to reserve your spot in this invaluable PL/SQL training. Choose from available dates: May 21-23, July 21-23, August 13-15, or October 13-15, 2025.</p>","rating":0,"reviewCount":0,"reviews":[]}