Training Courses and On-Line Classes Preferred By IT Pros
Toll Free:  800.631.0410

Oracle 11g For Developers Workshop

Course:  DEV11G
Duration:  5 Days
Level:  I
Course Summary

This five-day workshop uses a 'Hands On' approach to teach the participant the essential concepts of ORACLE using SQL and PL/ SQL. The workshop is up to date to release 11g. The participant will learn to code and execute basic and advanced SQL queries, learn the essentials of the PL/SQL programming language, handle Exceptions, use Cursors, and code and execute Stored Procedures, User Defined Functions, Packages, and Triggers.

« Hide The Details
Topics Covered In This Course

ORACLE overview

ORACLE Objects

Running ORACLE SQL

Access TOOLS

Simple SQL Queries

  • SELECT
  • FROM
  • WHERE
  • ORDER BY

CASE

Single Value Functions

  • Math
  • Date and Time
  • Character and Data Conversion
  • NVL, NVL2, NULLIF

Group Functions

  • MAX
  • MIN
  • AVG
  • COUNT
  • SUM
  • MEDIAN

GROUP BY

  • HAVING
  • ROLLUP
  • CUBE

SubQuery

  • Simple
  • Correlated
  • Embedded

Join

  • Inner
  • Outer

UNION, INTERSECT, MINUS

Creating Tables, and Views

INSERT, UPDATE, DELETE, TRUNCATE

Data Dictionary Views

PL/SQL – Basics

Using functions in PL/SQL

Looping

Conditionals

  • IF
  • CASE

Handling Exceptions

Cusrors

Stored Procedures

Stored Functions

Using Packages

Triggers

Using External Tables

What You Can Expect

Upon completion of this workshop, the participant will be able to:

  • Understand Relation Database Concepts.
  • Run Queries using ORACLE SQL.
  • Use Access Tools to query, modify, and manipulate objects.
  • Use the ORACLE extensions of the SQL language.
  • Code and execute simple and complex queries
  • Use PL/SQL to build ORACLE Applications
  • Code and execute Stored Procedure, Functions, and Packages
  • Understand Database Triggers
  • Understand the latest upgrades in Oracle
« Hide The Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at info@verhoef.com