Oracle 11g PL/SQL Program Units


Oracle 11g PL/SQL Program Units


Product Details

Learning Oracle 11g PL/SQL Program Units is easy with instructor-led Video Training

After completing the basic PL/SQL courseware and getting comfortable with the basics, upgrade your skills to the more advanced techniques by selecting the self-paced Oracle 11g Develop PL/SQL Program Units CBT. This course picks up where the fundamental course left off and digs deeper into the PL/SQL programming language. With the foundation you already have, you will now learn to manage PL/SQL subprograms and triggers as well as develop, manage, and execute procedures, functions, and packages and other stored program units. 

The Oracle 11g Develop PL/SQL Program Units training CD teaches using a variety of engaging teaching methods including full motion Oracle 11g Develop PL/SQL Program Units training videos led by a certified instructor, multimedia presentations, simulations, interactive demos, and hands-on learning labs. 

The videos make the self-paced Oracle 11g Develop PL/SQL Program Units CBT a valuable tool as you master the PL/SQL programming language. Not only do you learn from an expert, you can watch these videos over and over until you completely understand the concepts. In addition, the videos are available anytime you want to watch them. With regular classes, you'd have to wait until the next session to continue your learning. The Oracle 11g Develop PL/SQL Program Units training CD lets you study any time you want. 

While the Oracle 11g Develop PL/SQL Program Units training videos are one of the main features found on the disc, they aren't the only tool you'll need. Also included are computer based training components that let you get real experience working with Oracle 11g and PL/SQL. This blend of expert Oracle instruction combined with hands-on practice is an incredibly effective teaching method. You learn directly from a qualified Oracle professional and then reinforce all that's been discussed by working in a simulated environment. 

The Oracle 11g Develop PL/SQL Program Units training CD is appropriate for those who have basic knowledge or PL/SQL and previous programming experience. It is also an exciting alternative to traditional classes. If you want to take your programming skills to the next level yet hesitate to enroll in a regular class, you'll love the convenience, flexibility, and results that this advanced video-based course offers. 


Oracle 11g PL/SQL Program Units Training Video CBT Features:



Training Videos: An instructor introduces each learning module and gives you a preview of the topics that are covered. Instead of relying on reading written introductions, simply click on the video presentations for an interesting, informative summary of the concepts that you will be learning next. You will be learning these topics directly from an expert instructor who really knows the material.


Hands-On Labs: Interactive hands-on lab scenarios are included for you to practice your skills. In fact, you don't even need the software on your computer in order to receive this hands-on training. Simulations are critical to the learning process. By modeling a real system and letting you perform the same tasks you would perform on the real system, you are reinforcing your knowledge.


Player Controls: You can navigate freely with the player controls. You can play, pause, rewind, forward, and stop any video topic. The controls are familiar and easy to use. Simply click the control that matches the functions you want. If you are interrupted during your studies, click the pause button so that you won’t miss a single minute of the video training.


Course Map: Choosing which topic you want to learn is easy with the convenient course map. Advanced users may skip ahead or repeat users can pick up where they left off. The course map allows you to pick and choose the topics that interest you and tailor the learning. You can even use it as a quick launch for reviewing specific topics.


Search Function: Find the topics you need instantly. Just type in the word that describes your topic and view the search results. Don't waste countless minutes trying to find something you need now. The Search function is fast, accurate, and easy to use. Relevant search results and fast hyperlinks will jump you to your desired topic in a blink of an eye.


Note Taking: Put away your notebook and pencil. Instead, jot down notes or questions for later reference by using the useful notepad feature. If an idea comes to mind or if you need to remind yourself of something important while studying, click on the notepad directly from the course interface and type out your thoughts without ever having to lift a pencil.


Bookmarking: Self-paced study is designed to take place over several sessions which makes bookmarking extremely useful. You can exit your training and quickly reference areas of study you wish to revisit later by using bookmarks. If you want to pay special attention to a particular topic, simply use the bookmark feature so that you can spend extra time mastering the concept.


Print: Do you need a hard copy? Sometimes, it’s just not practical to log on to your computer when you have a quick question or want to review. The print function lets you print out a hard copy for those times when you need to study offline. Anything that you see on the screen can be printed out for future reference.


Certificate of Completion: Each interactive course comes with a certificate of completion. After you have finished the course, you just type in your name and print. It's that simple. Get recognized of your accomplishments with our courses.


Multi-User Licensing: The best single and multi-user licensing agreement in the industry. Our licensing agreements accommodate individual students as well as companies with large training requirements. Single user licenses, single PCs licenses, multiple-user (non-concurrent) licenses, and unlimited corporate server site licenses are all available. This level of flexible licensing can’t be beat. No matter what you need, we have a license.


Training Level: Advance

Table of contents

1.0 Introduction

      1.1 Introdution

      1.2 The HR Schema

      1.3 The PL/SQL Development Environment

      1.4 Coding PL/SQL in SQL Plus

      1.5 Coding PL/SQL in SQL Plus Demo

      1.6 Starting SQL Developer and Creating a Database Connection (part 1)

      1.7 Starting SQL Developer and Creating a Database Connection (part 2)

      1.8 Summary


2.0 Procedures
3.0 Working with Functions
4.0 Working with Packages
5.0 Advanced Packages
6.0 Oracle Supplied Packages
7.0 Dynamic SQL

8.0 Design Considerations for PL/SQL Code
9.0 Triggers
10.0 Compound Triggers, DDL Triggers and Event Database Triggers
11.0 PL/SQL Compiler
12.0 PL/SQL Code
13.0 Managing Dependencies

Specs and Support

Content: CD-ROM disc (sealed in a DVD-case) 

System Requirements: 
Platform:  Windows Vista / XP / 2000 / 9x / NT
Processor: Pentium 133 Mhz or higher
Hard drive space: 10MB
CD-ROM Drive speed: 24X

Technical Support:

Return to top


Add To Cart