Back
|
|
|
ORACLE SQL FUNDAMENTALS
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 Introduction to Oracle9i: SQL Oracle Certified Professional examination (IZ0-007) .
|
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 iSQLPlus
- Create SQL statements to select data from an Oracle database
- Use single row functions
- Use enhanced grouping functions
- Implement analytic functions
- Generate hierarchical queries
- Generate scripts and apply formatting to output
- Use SQL*Plus control and 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: |
|
Before taking any exam, ensure you have the recommended experience.
|
Topics Covered: |
- The Structure of a Relational Database
- Using SQL*Plus and iSQLPLus
- 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
- Analytic Functions
- CASE Expressions
- Regular Expression Notation and Related Functions
- SQL*Plus and iSQLPlus Parameters and Variables
- Producing Reports with SQL*Plus
- Creating and Changing Tables and Views
- Constraints and Indexes
- Inserting, Updating and Deleting Data
- Creating and Using External Tables
- Basic Transaction Control
- Controlling Access to Objects
- Data Dictionary Tables and Views
|
Requirements:
|
|
An understanding of IT is required. |
|
|
|
