Oracle Database: PL/SQL Fundamentals

lt;pgt;lt;stronggt;Official Oracle Curriculum lt;/stronggt;lt;/pgt;lt;pgt;lt;stronggt;This Oracle Database: PL/SQL Fundamentals training introduces you to PL/SQL. It helps you understand the benefits of this powerful programming language, while teaching you real-world scenarios where these lessons can be applied.lt;/stronggt;lt;/pgt;lt;pgt;Learn To:lt;/pgt;lt;ulgt;lt;ligt;Describe the features and syntax of PL/SQL.lt;/ligt;lt;ligt;Design a PL/SQL anonymous block that executes efficiently.lt;/ligt;lt;ligt;Write PL/SQL code to interface with the database.lt;/ligt;lt;ligt;Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursorslt;/ligt;lt;ligt;Handle runtime errors.lt;/ligt;lt;ligt;Describe stored procedures and functions.lt;/ligt;lt;ligt;Apply declaring identifiers and trapping exceptions.lt;/ligt;lt;ligt;Create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.lt;/ligt;lt;/ulgt;lt;pgt;Benefits to Yoult;/pgt;lt;pgt;Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.lt;/pgt;lt;pgt;Gain Experience through Hands-On Practicelt;/pgt;lt;pgt;In this course, youamp;#39;ll learn from expert Oracle instructors, then engage in demonstrations and hands-on practice to reinforce the fundamental concepts. Youamp;#39;ll use Oracle SQL Developer to develop these program units. SQL*Plus is introduced as optional tools.lt;/pgt;lt;pgt;Audiencelt;/pgt;lt;ulgt;lt;ligt;PL/SQL Developerlt;/ligt;lt;ligt;System Analystslt;/ligt;lt;ligt;Technical Consultantlt;/ligt;lt;ligt;Forms Developerlt;/ligt;lt;ligt;Portal Developerlt;/ligt;lt;/ulgt;