Course Overview:

In this class, students will learn how to create, retrieve & manipulate objects in Oracle 11g Structure Query Language (SQL).  Students will also be introduced to Oracle 11g database features & tools.  In addition, students will learn the functions of the PL/SQL programming language.  Students will write stored procedures, functions, packages & triggers & implement complex business rules in Oracle.  Students will learn programming, management & security issues of working with PL/SQL program units.  Programming topics will include the built-in packages that come with Oracle, the creation of triggers & stored procedure features.

Attendees to OR-415A: Oracle 11g: SQL & PL/SQL Programming will receive TechNow approved course materials and expert instruction.


No Events

Duration: 5 Days

Course Objectives:

  • Relational Database & SQL Overview
  • Using Oracle SQL *Plus
  • SQL Queries – the SELECT Statement
  • Scalar Functions
  • SQL Queries – Joins
  • Aggregate Functions & Advanced Techniques
  • Data Manipulation & Transactions
  • Data Definition & Control Statements
  • Other Database Objects
  • Triggers
  • PL/SQL Variables & Datatypes
  • L/SQL Syntax & Logic
  • Stored Procedures & Functions
  • Exception Handling
  • Records & Collections
  • Cursors
  • Using Packages
  • Creating Packages
  • Working with LOBs
  • Maintaining PL/SQL Code


  • Basic knowledge of relational databases.


Latest comments from students

User: jlokey56

Instructor comments: Great instructor, he kept the class interesting and the pace lively. Well done! Thanks!

Facilities comments: Nice facilities, and enjoyed the complimentary refreshments.

User: albersb

Instructor comments: Informative, very willing to demonstrate and provide examples for us to understand, and helped alot in diagnosing/preventing common errors.

Liked the class?  Then let everyone know!