Oracle 10g SQL and SQL*Plus

Length: 3 Days
Audience: Programmers, Analysts, Database Administrators, and Users who must access data in an Oracle database.
Prerequisites: Oracle 10g 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. 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.
Topics discussed include:
  • 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
  • SQL*Plus
    • Enter, Edit, and Run SQL Statements
    • Customize the SQL*Plus Environment with the SET Command
    • Format Query Results
Back to Oracle 10g Courses