Back
|
|
|
ORACLE SQL
Delegates: |
This course is designed for anyone who needs to access and work with an Oracle Database.
This course is suitable for anyone intending to sit the Oracle Database 11g: SQL Fundamentals (IZ0-051) examination. Together with the Oracle SQL Advanced course, this course is suitable for delegates intending to sit the following exams:
Introduction to Oracle9i: SQL Oracle Certified Professional (1Z0-007)
Oracle Database SQL Expert (IZ0-047)
|
Objectives: |
By the end of this course, the delegate will be able to:
- Describe the basic structure of a relational database
- Use the command line features of SQL*Plus
- Use SQL Developer to access an Oracle Database
- Create SQL statements to select data from an Oracle Database
- Use SQL run time parameters
- Use aggregate functions
- Use numeric, character, date, conversion and miscellaneous functions
- Use subqueries
- Create and alter tables, indexes and views
- Create, update and delete records
- Manage sequences and synonymns
- Use 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
- Using SQL Developer
- The Basic SQL Select Statement
- Selecting Data from Multiple Tables
- Inner Joins, Outer Joins and Self Joins
- Grouping and Sorting Output
- Sub-queries and In-line Views
- Character, Date and Numeric Functions
- SQL*Plus Run-time Parameters and Variables
- Creating and Changing Tables and Views
- Constraints and Indexes
- Inserting, Updating and Deleting Data
- Basic Transaction Control
- Controlling Access to the Database
- Related Data Dictionary Tables and Views
|
Requirements:
|
|
An understanding of IT is required. |
|
|
|
