Home About Courses Schedule Services Webinars Contact Search

Introduction to Oracle SQL

SEE SCHEDULE

Duration: 3.0 days

Method: Instructor led, Hands-on workshops

Price: $1800.00

Course Code: OR5450



Audience

Programmers, Analysts, Database Administrators, and Users who must access data in an Oracle database.

Description

From an examination of single table operations to the complexities of accessing multiple tables using joins or subqueries, this course provides a thorough introduction to interactive SQL. This course also introduces the student to basic SQL*Plus operations required to enter, edit, and run SQL statements, produce reports, and write interactive SQL scripts through SQL*Plus. Coding examples and workshops serve to reinforce the material presented in class.

This course can be taught for any Oracle version.

Prerequisites

None

Topics

  1. Data Retrieval Operations
    • SELECT Statement
    • SELECT Expressions
      • Columns, Functions, Constants, Subqueries
    • Sorting the Result (ORDER BY)
    • The WHERE Clause
    • AND, OR Operators
    • WHERE Clause Operators
      • =, >, <, >=, <=
      • IN, BETWEEN, LIKE, NOT NULL
    • CASE Expressions
      • Simple CASE
      • Searched CASE
    • Processing Date/Time Information
    • SQL Standards
  2. Multi-Table Operations
    • Inner Join
    • Outer Join
    • Using the (+) Operator
    • ANSI Join Syntax
    • INNER JOIN, OUTER JOIN
    • JOIN USING, NATURAL JOIN
    • Join Considerations
  3. Data Manipulation Operations
    • UPDATE, DELETE, INSERT Statements
    • The TRUNCATE statement
    • TRUNCATE vs. DELETE
    • COMMIT and ROLLBACK
  4. Row Functions
    • Character Functions
    • Numeric Functions
    • Date/Time Functions
    • Misc Functions
  5. Group Functions
    • Aggregate Functions
      • COUNT, MAX, MIN, AVG, SUM
    • The GROUP BY Clause
    • The HAVING Clause
    • HAVING vs. WHERE
  6. Related Oracle Objects
    • Views
    • Sequences
    • Synonyms
  7. Subqueries
    • Non-Correlated
    • Correlated
    • Usages
      • WHERE Clause
      • FROM Clause
      • SELECT Expression
      • DML Statements
    • The WITH Option
    • Behavior and Benefits
  8. Oracle 12c New Features
    • FETCH FIRST Clause (Top-n Queries)
    • TRUNCATE CASCADE Option