Oracle SQL Introduction

Course Overview

This course provides delegates with the knowledge and skills needed to retrieve and update data held in an Oracle Relational Database.

Audience

Anyone who needs to use and understand Oracle SQL and iSQL*Plus to retrieve data from and to update an Oracle database.

Skills Gained

• Create SQL statements to query database tables.
• Use standard aggregate functions and related Select statement clauses.
• Implement extended SQL functions.
• Use iSQL*Plus control and run time parameters.
• Generate simple scripts.
• Create and alter tables and views.
• Insert, update and delete rows in database tables.
• Grant and revoke access privileges on tables and views.
• Retrieve information from the data dictionary.

Prerequisites

Introduction to Relational Databases

Examinations

This course partially prepares delegates for two Oracle certification exams: - Oracle 9i Certified Internet Application Developer (OCIAD) exam IZO-001 [with Oracle PL/SQL Introduction - OPL]. - Oracle 9i Certified Database Associate (OCDA) exam IZO-007 [with Oracle 9i SQL Advanced - OSA].

Course Outline

• Relational Database Concepts
• What is an Oracle database? Tables, rows and columns. Indexes, primary and foreign keys. The data dictionary. Retrieving Data
• SQL statements and iSQL*Plus commands. The Select statement. Select, From, Where and Order by clauses. Inner joins, outer joins and self joins. Standard aggregate functions. Group by and Having clauses. The Union, Intersect and Minus operators. SQL*Plus Functions
• Numeric functions. Character functions. Date functions. Conversion functions. Parameters
• Run time parameters and variable substitution. Column control parameters. SQL*Plus environmental parameters. Tables, Indexes and Views
• Main database objects. Tablespaces. Creating tables. Constraints. Creating and maintaining indexes. Creating and using views. Managing Data
• DML Statements. Inserting rows. Updating rows. Deleting rows. The commit, rollback and savepoint statements. Access Control
• Creating users. Creating roles. System privileges. Granting and revoking access to tables and views. Data Dictionary
• User views. All views. Dba views.