Oracle SQL* Plus
Duration:
3 Days
Pre-requisites:
Oracle Data Modeling with Introduction to SQL, or a general understanding
of Relational Databases and SQL basics
Course Description
Students will learn Oracle’s SQL * Plus commands, how to
create scripts, and how to set
up the test environment. They will then execute their SQL using
their own workstations
attached to an Oracle database. They will also learn advanced SQL
techniques including
joins, drops, and the creation of tables. In addition, students
will learn how to use
Oracle’s Data Dictionary
Who Should Attend
This course is intended for Data processing professionals who
require an in-depth
knowledge of Structured Query Language (SQL), Oracle SQL *plus,
and Oracle Data
Dictionary (DDL).
Course Topics
Introduction
Database Queries
Data Manipulation
Functions
Advanced Queries
SQL * Plus Reporting
|