Oracle Training

Attend Oracle Training Courses to Build Your Expertise

COURSE DESCRIPTION:

This is a 2-day class (6-hours per day) that includes lecture, lab and testing for up to 12 students.

Attendees will learn how to access and manipulate Oracle data using SQL (Structured Query Language).

The attendees will construct SQL statements and scripts to solve simple and complex business questions by writing SQL in a variety of tools and applications.

Lectures and topics are enhanced with live illustrations and hands-on exercises.

COURSE OBJECTIVES:

  1. Introduction to SQL commands for data extraction and manipulation.
  2. Introduction to SQL commands to create Oracle objects including tables, indexes and views.
  3. Exposure to Oracle tools SQL*Plus and SQL Developer.
  4. Exposure to Quest Software's Toad application.
  5. Introduction to advanced SQL topics including group functions, joins, analytical SQL, tuning and much more.
  6. Creating reports

AUDIENCE:​

The focus of this course is to give a working knowledge of SQL to non-IT people or to people who are new to the relational database world.

PREREQUISITES:

None.

ATTENDEES RECEIVE:

  • Study Guide with presentations and relevant white papers
  • SQL Reference pocket guide
  • Example files with SQL and SQL*Plus scripts
LightSpeed PM

COURSE OUTLINE:​

Day 1: Introduction to Oracle SQL

  • Oracle RDBMS Architecture overview
  • Introduction to Toad, Toad Data Point, SQL*Plus and SQL Developer
  • Introduction to SQL DML (Data Manipulation Language)
    1. Database queries (SELECT)
    2. Data Manipulation (INSERT, UPDATE, DELETE)
  • Introduction to SQL DDL (Data Dictionary Language)
    1. Create Tables
    2. Create Indexes
    3. Create Views
  • Introduction to SQL Scripts

Day 2: Advanced SQL Topics

  • Functions
  • Advanced SQL
    1. Joins
    2. ANSI SQL Syntax
    3. Sub-Queries
  • Group Functions
  • Analytical SQL
    1. Windowing
    2. Partitioning
    3. Ranking
    4. Percentiles
  • Intro to SQL Tuning
  • Referential Integrity
  • Using ODBC Drivers and MS Products
  • Building HTML ReportsType your paragraph here.

COURSE DESCRIPTION:

This is a 2-day class (6-hours per day) that includes lecture, lab and testing for up to 12 students.

Attendees will learn how to develop Oracle procedures, functions and packages using PL/SQL (Programming Language extension of Structured Query Language). They will also learn about error handling and debugging.

The attendees will construct PL/SQL statements and scripts to solve simple and complex business questions by writing PL/SQL in a variety of tools and applications.

Lectures and topics are enhanced with live illustrations and hands-on exercises.

COURSE OBJECTIVES:

  1. Introduction to PL/SQL syntax and language structure.
  2. Introduction to PL/SQL commands to develop Oracle procedures, functions and database triggers.
  3. Exposure to Oracle tools SQL*Plus and SQL Developer.
  4. Exposure to Quest Software's application named Toad.
  5. Introduction to advanced PL/SQL topics including cursor management, exception handling, PL/SQL Profiler, PL/SQL Debugger and much more.

AUDIENCE:

The focus of this course is to give a working knowledge of PL/SQL to students who already have a working knowledge of SQL.

PREREQUISITES:

Working knowledge of SQL.

ATTENDEES RECEIVE:

  • Study Guide with presentations and relevant white papers
  • PL/SQL Reference pocket guide
  • Example files with SQL and SQL*Plus scripts
  • Tips and Techniques for both Toad and SQL Developer
LightSpeed PM

COURSE OUTLINE:​

Day 1: Introduction to Oracle PL/SQL

  • Oracle RDBMS Architecture overview
  • Introduction to SQL*Plus, SQL Developer and Toad
  • Introduction to PL/SQL
    1. Syntax
    2. Structure
    3. Variables
    4. Control Structures
      1. IF-Then-Else
      2. Case
      3. Looping
    5. Cursors
      1. Implicit
      2. Explicit
      3. Cursor Loops

Day 2: Advanced PL/SQL Topics

  • PL/SQL Exception Handling
  • Procedures, Functions and Packages
  • Passing Parameters
  • PL/SQL Profiling
  • PL/SQL Debugging
  • PL/SQL New Features

COURSE DESCRIPTION:

This is a 3-day class (6-hours per day) that includes lecture, lab and testing for up to 12 students.

Attendees will learn tips and techniques on how to advance their expertise when programming in PL/SQL. This course covers all of the latest features of PL/SQL using databases Oracle 10g, Oracle 11g and Oracle 12c. This course utilizes a variety of tools, one of which is Quest Software's Toad.

This class could easily be named "New Features for Developers."

Lectures and topics are enhanced with live illustrations and hands-on exercises.

COURSE OBJECTIVES:

  1. Review of PL/SQL syntax and language structure.
  2. Review of cursor management.
  3. Review of PL/SQL Profiling.
  4. Review of Package Usage (User Defined and Oracle Defined.
  5. Introduction to advanced PL/SQL topics including compiler options, code encryption, conditional compilation, collections, triggers, dynamic SQL and much more.

AUDIENCE:

Students who wish to learn advanced tips and techniques of PL/SQL programming who already have a working knowledge of SQL and PL/SQL.

PREREQUISITES:

Working knowledge of SQL and PL/SQL.

ATTENDEES RECEIVE:

  • Study Guide with presentations
  • PL/SQL Reference pocket guide
  • Example files with SQL and SQL*Plus scripts
  • Information on Toad, SQL Developer, using UTL_MAIL and executing external procedures
LightSpeed PM

COURSE OUTLINE:​

Day 1: Review of PL/SQL Options and Compiling

  • Overview
  • Review
  • PL/SQL Compiler Options
  • Code Encryption
  • Conditional Compilation
  • Definer/Invoker Rights
  • Executing and Exception handling
  • Autonomous Transactions
  • Package Options
  • Overloading

Day 2: Triggers, Cursors and Collections

  • Database Triggers
    1. Instead of
    2. ServerError
    3. Startup
    4. Shutdown
    5. Logon
  • Cursors
    1. User Defined Datatypes
    2. Cursor Sharing
    3. Cursor Variables
    4. Strong vs. Weak Cursors
  • Collections
    1. Associate Arrays
    2. Nested Tables
    3. VArrays
    4. Bulk Collect/Forall Bulk Binding
    5. Using Collections for Reference Table

Day 3: Oracle Provided Packages and Miscellaneous Topics

  • ​ DBMS_ALERT
  •  DBMS_JOB
  •  DBMS_OUTPUT
  •  DBMS_SCHEDULER
  •  UTL_FILE
  •  UTL_MAIL
  •  Other Provided Packages
  •  DBMS_SQL and Dynamic SQL
  •  Working with Large Objects
  •  Debugging PL/SQL Routines
  •  PL/SQL Profile

ASK ABOUT OUR NEW FEATURES CLASS!

ABOUT THE TRAINER

Our Oracle training solutions are built to empower DBAs and SQL Developers to be successful.

Training Specialist Dan Hotka is an Oracle ACE Director Alumni (a recognized outside expert/evangelist on Oracle Products) and has over three decades of experience with Oracle Products. Dan is well published with 14 Oracle books and over 200 published articles. He is frequently published in Oracle trade journals, regularly blogs and speaks at Oracle conferences and user groups around the world.

LightSpeed PM