Back
|
|
|
Oracle Fundamentals
Delegates: |
|
This course is designed primarily for administrators, developers and support personnel who need to access and work with an Oracle Database. |
Objectives: |
By the end of this course, the delegate will be able to:
- Select data from an Oracle Database using SQL*Plus and SQL Developer
- 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
- Access the Data Dictionary
- Describe the Basic Structure of a PL/SQL Block
- Use PL/SQL IF Statements, Expressions and LOOP Constructs
- Declare and use Cursors
- Use record types and PL/SQL Tables
- Handle Errors and Exceptions within PL/SQL Scripts
|
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
- Selecting Data from Multiple Tables
- Grouping and Sorting Output
- Character, Date and Numeric Functions
- SQL*Plus Run-time Parameters and Variables
- Creating and Changing Tables, Indexes and Views
- Inserting, Updating and Deleting Data
- Related Data Dictionary Tables and Views
- The Structure of a PL/SQL Block
- Declaring and Using Variables and Constants
- Using SQL Statements in PL/SQL
- PL/SQL Programming Constructs
- Declaring and Using Cursors
- Exceptions and Error Handling
- Record Types and PL/SQL Tables
|
Requirements:
|
|
An understanding of IT. Some practical programming experience would prove advantageous. |
|
|
|
