Office of Administration
 Matt Blunt, Governor - Larry Schepker, Commissioner
 
 
 

Information Technology Services

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

Scheduled Classes