Popular Training Course
- Microsoft Office 2010 Training
- PMP Training
- MCSE Certification Training
- CompTIA A+ Certification Training
- Cisco CCNA CertificationTraining
- Windows 7 Training
- Microsoft Excel Training
- CISSP Training
- Microsoft Office Training
- CompTIA Network+ Training
- MCITP Training
- Microsoft Project Training
- Project Management Training
- QuickBooks Pro Training
- Microsoft Windows Server Training
CBT Training Courses
In the News
Oracle Database 10g: PL/SQL Fundamentals Suite Online Training Course
Price: $387.00
Online Training Course ID:CBT 88-67410D
Training Course Description / Outline
Oracle Database 10g: PL/SQL Fundamentals Suite Computer Based Training CBT 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.
This Computer Based Training Suite concist of three courses:
Oracle Database 10g: PL/SQL Fundamentals Part 1
Oracle Database 10g: PL/SQL Fundamentals Part 2
Oracle Database 10g: PL/SQL Fundamentals Part 3
Learn To
- Identify features of PL/SQL.
- Identify benefits of PL/SQL.
- Identify features of PL/SQL blocks.
- Identify 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.
- Identify features of PL/SQL packages.
- Sequence steps for developing PL/SQL packages.
- Identify the syntax for creating a PL/SQL package.
- Identify features of triggers.
- Identify the code to create a Data Manipulation Language (DML) trigger.
- Identify the code to create a Data Manipulation Language (DML) row trigger.
- Match the stages in the execution of SQL statements with their descriptions.
- Identify features of dynamic SQL.
- Identify the features of the DBMS_SQL package.
- Identify guidelines for standardizing constants and exceptions.
- Identify benefits of using local subprograms.
- Sort the characteristics of the rights models according to their category.
- Identify features of native compilation.
- Identify settings to be specified for native compilation.
- Sequence the steps to enable native compilation of PL/SQL code.
Total Training Time
18-20 hours
Audience
This Oracle Database 10g: PL/SQL Fundamentals Suite Computer Based Training CBT course is targeted at Application Developers, Database Designers, System Analysts, PL/SQL Developers, Technical Consultant, Forms Developers, and Portal Developers.