Back
|
|
|
ORACLE SQL
Delegates: |
This course is designed for anyone who needs to access and work with an Oracle Database.
Together with the Oracle PL/SQL course, this course is suitable for delegates intending to sit the Introduction to Oracle: SQL and PL/SQL Oracle Certified Professional examination (1Z0-001).
Together with the Oracle SQL Advanced course, this course is suitable for delegates intending to sit the Introduction to Oracle9i: SQL Oracle Certified Professional examination(1Z0-007).
|
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
- Create SQL statements to select data from an Oracle Database
- Generate simple reports from selected data
- Use SQL*Plus control and run time parameters
- Create and alter tables, indexes and views
- Create, update and delete records
- Grant and revoke access privileges
- Access the Data Dictionary
|
Note: |
|
Before taking any exam, ensure you have the recommended experience.
|
Topics Covered: |
- The Structure of a Relational Database
- Using SQL*Plus
- 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
- SQL*Plus Control Parameters
- Producing Reports with SQL*Plus
- 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. |
|
|
|
