Oracle SQL* Plus
Duration
Three 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
