Oracle Database 10g PL/SQL Fundamentals Training CBT

Price: $387.00

Oracle CBT Course Overview:

The Self Study Store Computer Based Training Introduction to Oracle Database 10g: PL/SQL Fundamentals consists of Oracle Database 10g: Program with PL/SQL Fundamentals Part 1, Oracle Database 10g: Program with PL/SQL Fundamentals Part 2, and Oracle Database 10g: Program with PL/SQL Fundamentals Part 3. Oracle Database 10g: Program with PL/SQL Fundamentals Part 1 covers the introduction to the procedural language to access Oracle Database, and writing and using anonymous PL/SQL blocks, program constructs, simple and composite PL/SQL data types, programming guidelines, and accessing and manipulating data using PL/SQL. Oracle Database 10g: Program with PL/SQL Fundamentals Part 2 covers the benefits of this programming language, and creation of anonymous PL/SQL blocks. Oracle Database 10g: Program with PL/SQL Fundamentals Part 3 provides an understanding of PL/SQL program units manage dependencies, manipulate large objects, and use some of the Oracle-supplied packages.

Total Training Duration:

24 hours

CBT Course Modules:

Oracle Database 10g: Program with PL/SQL Fundamentals Part 1 - 3

Training Course Topics:

Learn features of PL/SQL.
Learn benefits of PL/SQL.
Learn features of PL/SQL blocks.
Learn features of PL/SQL blocks within a subprogram.
Match types of PL/SQL named blocks with their descriptions.
Match types of PL/SQL environments with their descriptions.
Learn features of PL/SQL packages.
Sequence steps for developing PL/SQL packages.
Learn the syntax for creating a PL/SQL package.
Learn features of triggers.
Learn the code to create a Data Manipulation Language (DML) trigger.
Learn the code to create a Data Manipulation Language (DML) row trigger.
Match the stages in the execution of SQL statements with their descriptions.
Learn features of dynamic SQL.
Learn the features of the DBMS_SQL package.
Learn guidelines for standardizing constants and exceptions.
Learn benefits of using local subprograms.
Sort the characteristics of the rights models according to their category.
Learn features of native compilation.
Learn settings to be specified for native compilation.
Sequence the steps to enable native compilation of PL/SQL code.

The Self Study Store Computer Based Training Oracle Database 10g: PL/SQL Fundamentals course is targeted at Application Developers, Database Designers, System Analysts, PL/SQL Developers, Technical Consultant, Forms Developers, and Portal Developers.