Oracle Database: Program with PL/SQL


Základní info

View a newer version of this courseThis Oracle Database: Program with PL/SQL course begings with an introduction to PL/SQL and proceeds to list the benefits of this powerful programming language. Expert Oracle University instructors will teach you how to create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.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.Manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions.Understand and influence the PL/SQL compiler and manage dependencies.Create anonymous PL/SQL blocks, focusing on stored procedures and functions.Benefits to YouYou'll also enhance your developer skills by learning to develop, execute and manage PL\SQL stored program units like procedures, functions, packages and database triggers. Understanding the basic functionality of how to debug functions and procedures using the SQL Developer Debugger gives way to refined lines of code.Use Dynamic SQLDuring this course, you'll also utilize some of the Oracle-supplied packages. Expert instructors will teach you how to use Dynamic SQL and will help you understand design considerations when coding using PL/SQLUse Oracle SQL DeveloperYou'll use Oracle SQL Developer to develop these program units. SQL*Plus and JDeveloper are introduced as optional tools. This is appropriate for a 10g and 11g audience. There are minor changes between 10g and 11g features. It's a bundle of Oracle Database: PL/SQL Fundamentals and Oracle Database: Develop PL/SQL Program Units courses.Fulfills Training Requirements for CertificationThis course fulfills the training requirement for an Oracle Certification Path. Only Live Virtual Class, Classroom Training or Training On Demand courses will fulfill the requirement. Self-Study and Knowledge Center courses do not fulfill the training requirement.

Oracle Database: Program with PL/SQL

Vybraný termín:


57 500 Kč + 21% DPH

Kontakt na dodavatele získáte po registraci

Tento kurz je pořádán dodavatelem, který nevyužívá placenou prezentaci na portálu EduCity.

Kontaktní údaje na dodavatele získáte po registraci.

Nebo použijte poptávkový formulář.