Delegates: |
This course is designed for anyone who needs to access and work with an Oracle Database. This course is suitable for delegates intending to sit the following examinations:
Introduction to Oracle9i: SQL Oracle Certified Professional examination (IZ0-007)
Oracle Database SQL Expert (IZ0-047)
Oracle Database 11g: SQL Fundamentals (IZ0-051)
|
Objectives: |
By the end of this course, the delegate will be able to:
- Describe the structure of a relational database
- Use the command line features of SQL*Plus and SQL Developer
- Create SQL statements to select data from an Oracle database
- Use single row functions
- Use enhanced grouping functions
- Generate hierarchical queries
- Generate scripts
- Use SQL run time parameters
- Create and alter tables, indexes and views
- Use external tables
- Create, update and delete records
- Create users, profiles and roles
- Grant and revoke access privileges
- Access the data dictionary
|
Note: |
|
Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience.
|
Topics Covered: |
- The Structure of a Relational Database
- Using SQL*Plus and SQL Developer
- The Basic SQL Select Statement
- Using Oracle and ANSI-Compliant Inner and Outer Joins
- Sub-Queries and Sub-Query Operators
- In-line views and Top-'N' Analysis
- Hierarchical Queries
- Grouping and Sorting Output
- Advanced Grouping Expressions and Functions
- Character, Date and Numeric Functions
- Timestamp and Interval Datatypes and Functions
- CASE Expressions
- Regular Expression Notation and Related Functions
- Creating and Changing Tables and Views
- Constraints and Indexes
- Inserting, Updating and Deleting Data
- Creating and Using External Tables
- Multitable Insert Statements
- Merge Rows in a Table
- External Tables
- Flashback Operations
- Basic Transaction Control
- Controlling Access to Objects
- Data Dictionary Tables and Views
|
Requirements:
|
|
An understanding of IT is required. |
