Back
|
|
|
Oracle for Experienced SQL Users
Delegates: |
|
This course is designed for experienced SQL users who need to access and work with an Oracle Database.
|
Objectives: |
By the end of this course, the delegate will be able to:
- Use SQL*Plus and iSQLPlus effectively
- Write SQL statements to query an Oracle Database
- Create and run SQL script files
- Use Oracle's numeric, character and date functions
- Analyse data using Oracle's analytic functions
- Implement Oracle's enhanced grouping functions
- Create and alter tables, indexes and views
- Insert, update, merge and delete rows
- Grant and revoke access privileges
- Access the Data Dictionary
|
Topics Covered: |
- Overview of Oracle Database features
- Using SQL*Plus and iSQLPlus
- Querying the Oracle Database
- Subqueries and in-line views
- Numeric functions
- Character functions
- Common date and timestamp functions
- Actual and hypothetical data ranking
- Data anlaysis using percentile functions
- Reporting and windowing functions
- Decoding data
- Enhanced grouping features
- Tables, indexes, views and sequences
- External and temporary tables
- Data manipulation and transaction control
- Access control
- The Data Dictionary
|
Requirements:
|
|
Practical experience of using SQL with another relational database is required.
|
|
|
|
