Oracle 11g/12c Express Introduction to SQL, SQL*Plus, and PL/SQL

Course:  OR11E2
Duration:  3 Days
Level:  I
Course Summary

You will receive an introduction to Oracle's relational database, and a hands-on introduction in how to add, update, extract and organize information from the database. You will cover how to format reports and export data. You will work with Oracle's Structured Query Language (SQL), SQL*Plus, and (Procedural Language for SQL) PL/SQL. You will cover debugging and error reporting procedures and how to define, execute and store procedures for reuse in the future.

This course is a reduced version of our five-day Oracle 11g/12c Essentials course.

This course can also be presented with content specific to Oracle 10g.

« Hide The Details
Topics Covered In This Course

The WHERE and ORDER BY Clause

  • WHERE, ORDER BY Clause
  • Using the Data Dictionary
  • Hierarchical Queries

Single Row Functions

  • Single Row vs. Group Functions
  • Date and Numeric Format Models
  • Data Conversion
  • Control Statements
  • Regular Expressions

Joining Data from Multiple Tables in Queries

  • The JOIN Condition / The Cartesian Product
  • Outer JOINs
  • SET Operators
  • ANSI SQL99 Joins

Group Functions and the GROUP BY Clause

  • Group Functions
  • Distinct Operator in Group Functions
  • GROUP BY, WITH Clause, ROLLUP, CUBE

Using Subqueries and CASE Clauses

  • Single-Row, Multi-Row, Multi-Column Subqueries
  • Subqueries in a WHERE Clause
  • Subqueries in the FROM Clause ? In-Line Views
  • Subqueries In the SELECT Clause ? Scalar Subqueries
  • Correlated Subqueries

PL/SQL Basics

  • PL/SQL anonymous block structure and Datatypes
  • Variable declarations
  • Object naming rules
  • Executable Statements
  • Repetition control
  • CASE Expressions and Statements
  • Basic Coding Standards

Working With Database Data

  • Referencing other variables or a database column?s datatypes
  • Implicit cursor attributes
  • Transaction control commands
  • Selecting data into PL/SQL variables
  • Declaring explicit cursors

Exception Handling

  • Handling predefined and user-defined exceptions
  • Preventing unhandled exceptions
  • Controlling exception processing

Stored PL/SQL Objects

  • Introduction to procedures and functions stored in the database
  • Creating stored PL/SQL objects
  • Creating procedures, functions, packages, package bodies
  • Introduction to database triggers
  • Viewing and recompiling stored code
What You Can Expect

On successfully completing this course, participants can expect to be able to:

  • Extract and organize information from the database
  • Format reports using SQL*Plus commands
  • Insert, update & delete information in database tables
  • Work with the PL/SQL Environment and Program Structure
  • Use Error Report Functions, Debugging Procedures
  • Use Logical Comparisons
  • Define and Execute Procedures, and Functions
  • Test Procedures and Functions
  • Create Package Specifications and Package Bodies
  • Create DML Triggers
  • Store PL/SQL Program Units
Who Should Take This Course

Anyone who needs to extract and organize information from an Oracle database, including formatting reports, adding, updating, and deleting data, and exporting data to ODBC files. i.e. Application designers, developers, database administrators, and end users and those seeking the OCA certification.

Recommended Prerequisites

An understanding of relational database design concepts.

Training Style

Short lecture sessions (60%) along with hands-on lab sessions (40%).

« Hide The Details
Related Courses
Code Course Title Duration Level
OR11E1
Oracle 11g/12c: Express Introduction to SQL and SQL*Plus
3 Days
I
Details
OR11F
Oracle 11g and 12c Foundations: SQL and SQL*Plus
5 Days
I
Details
OR11E
Oracle 11g/12c Essentials: SQL, SQL*Plus and PL/SQL
5 Days
I
Details
ORAPEX
Oracle APEX Version 5.0.4
5 Days
II
Details
OR11SQL2
Transitioning to Oracle 11g/12c SQL
3 Days
II
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