Oracle 11g PL/SQL Programming Part 2

View Your Course Transcript

Videos

There are several great features that come with this course. The Course Transcript tracks your progress and allows you to pick up where you left off. You can view or email your transcript. The course comes with documentation found in Downloads Tab. You have access to the course and all videos for 1 year. Full screen viewing option available (see icon on bottom right corner of video).

Start Learning Oracle 11g PL/SQL Programming Part 2 Today!

Your Price: $695

Video Title	Minutes
00: Oracle 11g PL/SQL Programming Part 2 Online Training - Course Introduction	5
01: Cursor Basics	21
02: Cursor Basics Exercise and Exercise Review	4
03: Advanced Cursor Topics	27
04: Advanced Curser Topics Part 2	26
05: Stored Procedures and Functions Basics	31
06: Stored Procedures and Functions Basics Exercise and Exercise Review	8
07: Passing Parameters to Stored Procedures and Functions	26
08: Passing Parameters to Stored Procedures and Functions Exercise and Exercise Review	13
09: Dependencies and Security	28
10: Stored Procedure and Functions Exercise and Exercise Review	17
11: Trigger Basics	26
12: Trigger Basics Part 2	20
13: Advanced Trigger Concepts	25
14: Triggers Exercise and Exercise Review	30
15: PL/SQL Packages	21
16: PL/SQL Packages Part 2	12
17: Packages Exercise and Exercise Review	19
Total:	5 hours 59 minutes

Start Learning Oracle 11g PL/SQL Programming Part 2 Today!

Your Price: $695

Course Materials

Want to be able to access these helpful materials? Contact Us!

• Student Guide
• Exercise Guide
• Lab Setup Guide
• Oracle Installation Guide
• Lab Script file

Related Links

• Course Survey
• Oracle Certification Information

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 11g PL/SQL Programming Part 2 Today!

List Price: $995 Your Price: $695

Description

Oracle 11g PL/SQL Programming Part 2 online training picks up right where Part 1 completes and continues to guide you through more intermediate PL/SQL topics. Through hands-on exercises, you learn to handle all types of runtime errors, use explicit cursor processing including cursor FOR loops, create and use stored procedures and functions, and design and use PL/SQL packages as well as understand the benefits of using packages. This Oracle programming course teaches you to manage dependencies between these PL/SQL stored units, and understand and manage security for them as well. Also covered in this Oracle training is learning how to automate processing by creating triggers to solve business requirements including 11g compound triggers.

In order to take this course you need to have taken Oracle 11g PL/SQL Programming Part 1 and have experience in some high-level programming such as SQL.

Objectives

As a result of taking this Oracle programming course, you will be able to:
• Describe the features and syntax of PL/SQL
• Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
• Handle runtime errors
• Design PL/SQL anonymous block that execute efficiently
• Create and use stored procedures and functions
• Design and use PL/SQL packages to group and contain related constructs
• Manage dependencies between PL/SQL subprograms
• Use conditional compilation to customize functionality in a PL/SQL block
• Create overloaded package subprograms
• Use the Oracle supplied PL/SQL packages to generate screen output, file output, and schedule jobs.
• Write dynamic SQL for coding flexibility
• Understand security for stored PL/SQL units
• Design PL/SQL code for predefined data types, local subprograms, additional pragmas and standardized constants and exceptions
• Create triggers to solve business requirements including 11g compound triggers
• Use the 11g PL/SQL function cache

Related Training

• Course: Oracle 10g/11g: Introduction to SQL
• Course: Oracle 10g/11g: Advanced SQL
• Course: Oracle 11g PL/SQL Programming Part 1
• Course: Oracle 10g/11g Database Administration I - Part 1
• Course: Oracle 10g/11g Database Administration I - Part 2
• Course: Oracle 10g/11g Database Administration II Part 1
• Course: Oracle 10g/11g Database Administration II Part 2
• Course: Oracle 11g New Features Part 1
• Course: Oracle 11g New Features Part 2

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 11g PL/SQL Programming Part 2 Today!

List Price: $995 Your Price: $695

Oracle 11g PL/SQL Programming Part 2 Outline

Module 00: Oracle 11g PL/SQL Programming Part 2 Online Training - Course Introduction

Module 01: Cursor Basics

• Learn How Oracle uses Cursors to Process SQL
• Identify when to use an Explicit Cursor
• Describe an Implicit Cursor
• Use Cursor OPEN, FETCH, and CLOSE Statements
• Identify and Use Cursor Attributes
• Use Parameters with Cursors
• Use Cursor FOR Loops

Module 02: Cursor Basics Exercise and Exercise Review

Module 03: Advanced Cursor Topics

• Using %ROWTYPE
• Cursor FOR Loops
• ursors with Parameters

Module 04: Advanced Curser Topics Part 2

• Using "Where Current of" Option
• Exercise Cursors
• Exercise Review
• What Should I Know about Cursor Processing?

Module 05: Stored Procedures and Functions Basics

• Create Stored Procedures
• Create Stored Functions
• Use a Function in a SQL Statement
• Shared SQL Area
• Pass Parameters to Procedures and Functions
• Locate Source Code in the Database

Module 06: Stored Procedures and Functions Basics Exercise and Exercise Review

Module 07: Passing Parameters to Stored Procedures and Functions

• Using Parameters
• Formal Parameter Modes

Module 08: Passing Parameters to Stored Procedures and Functions Exercise and Exercise Review

Module 09: Dependencies and Security

• Source Code and Dependencies
• Security for Stored Program Units
• Implementing Invoker's Rights
• DETERMINISTIC Functions

Module 10: Stored Procedure and Functions Exercise and Exercise Review

• What Should I Know about Stored Procedures and Functions?

Module 11: Trigger Basics

• Triggers
• Define Characteristics of Database Triggers

Module 12: Trigger Basics Part 2

• Row vs. Statement Triggers
• Trigger Types
• Understand the Difference between Statement Level and Row Level Triggers
• Identify Restrictions for Triggers

Module 13: Advanced Trigger Concepts

• Use Trigger Predicates
• Retrieve Trigger Definitions from the Data Dictionary
• Enable and Disable Triggers
• Execution Order of Triggers- Using FOLLOWS clause Compound Triggers (11g)
• Other Events and Triggers

Module 14: Triggers Exercise and Exercise Review

• What Should I Know about Triggers?

Module 15: PL/SQL Packages

• Identify Advantages of Using Packages
• Define a Package Specification
• Define a Package Body

Module 16: PL/SQL Packages Part 2

• Implement Public and Private Elements
• Understand Persistent State of Packaged Objects
• Execute Procedures and Functions in a Package

Module 17: Packages Exercise and Exercise Review

• What Should I Know about Packages?

 

 

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 11g PL/SQL Programming Part 2 Today!

List Price: $995 Your Price: $695

Prerequisites

You need to have equivalent experience and have taken Oracle 11g PL/SQL Programming Part 1 or taken the following GogoTraining courses:

• Oracle 10g/11g: Introduction to SQL
• Oracle 10g/11g: Advanced SQL
• Oracle 11g PL/SQL Programming Part 1

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 11g PL/SQL Programming Part 2 Today!

List Price: $995 Your Price: $695

System Requirements

Hardware:

• RAM: 256 MB minimum: 512 MB recommended.  On Windows Vista, the minimum requirement is 512 MB
• Virtual memory is double the amount of RAM
• Disk Space for basic installation is 2.04 GB, advanced installation is 1.94 GB
• Video adapter: 256 colors
• Processor: 550 MHz minimum. On Windows Vista, the minimum requirement is 800 MHz
• Oracle Database components include 32 MB hard disk to install Java Runtime Environment (JRE) and Oracle Universal Installer on the partition where the operating system is installed

Software:

Detailed set up will be provided with the course.

• Oracle 11g Enterprise Edition
• Oracle 10g Express Edition

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 11g PL/SQL Programming Part 2 Today!

List Price: $995 Your Price: $695

Certification

Oracle 10g/11g PL/SQL Programming Part 2 is part of a two-course online training series that helps you to prepare for one of the following exams: 1Z0-147 Program with PL/SQL or 1Z0-144 Oracle Database 11g: Program with PL/SQL. When you pass one of these exams, you have completed a portion of the requirements towards the Oracle PL/SQL Developer Certified Associate certification.

For more information about certification, requirements and fees, click on the link found in Related Links.

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 11g PL/SQL Programming Part 2 Today!

List Price: $995 Your Price: $695

When you purchase a course from GogoTraining, you can submit comments or questions to our expert instructors.