Základní info
This Oracle Database: Program with PL/SQL training starts with an introduction to PL/SQL and then explores the benefits of this powerful programming language. Through hands-on instruction from expert Oracle instructors, you'll learn to develop stored procedures, functions, packages and more.Learn To:Conditionally control code flow (loops, control structures).Use PL/SQL packages to group and contain related constructs.Create triggers to solve business challenges.Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.Create anonymous PL/SQL blocks, functions and procedures.Declare PL/SQL Variables.Benefits to YouEnsure 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.Use Oracle SQL DeveloperYou’ll use Oracle SQL Developer to develop these program units. SQL*Plus and JDeveloper are introduced in this course as optional tools.Course BundleNote: This course is a combination of Oracle Database: PL/SQL Fundamentals and Oracle Database: Develop PL/SQL Program Units courses.