Oracle 11g SQL Fundamentals

Length: 3 days
Audience: Programmers, Analysts, Database Administrators, and Users who must access data in an Oracle database.
Prerequisites: Oracle 11g Concepts and Facilities
Overview: 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. Students will be introduced to the SQL Developer and SQL*Plus tools.

Coding examples and workshops serve to reinforce the material presented in class.
  • Data Retrieval Operations
    • SELECT Statement
    • Sorting the Result (ORDER BY)
    • Pattern Matching (LIKE)
    • CASE Expressions
    • Built-In Functions
    • Processing Date/Time Information
  • Multi-Table Operations
    • Inner Join
    • Outer Join
    • ANSI Join Syntax
    • Subqueries
    • Correlated Subqueries
    • Recursive Queries
  • Data Manipulation Operations
    • UPDATE Statement
    • DELETE Statement
    • INSERT Statement
  • Security
    • Views
    • GRANT Statement
    • REVOKE Statement
  • Miscellaneous SQL
    • Processing Null Values
    • Sequences
    • UNION, INTERSECT, and MINUS
Back to Oracle 11g Courses