This intensive hands-on course is designed for professionals interested in acquiring knowledge to interface with the Oracle database using ANSI SQL and PL/SQL basics, and/or to communicate with the IS team as well as with Oracle based clients.

Duration: 5 Days

Database Concepts & Terminology
SQL, PL/SQL, & SQL *Plus Introduction
The SQL Language
Restricting Rows - The WHERE Clause
Single Row Functions
Group Functions
Subqueries & Joins
Formatting Output With SQL*Plus
Script Files Using SQL*Plus
SQL*Plus Variables
Data Dictionary
Data Storage Tables & Constraints
Manipulating Table Data
Indexes
Sequences & Synonyms
Views
User Management
PL/SQL Fundamentals
PL/SQL Transactions
IF - THEN - ELSE, Loops
Cursors
Exception Handling
Named PL/SQL Units

Before attending this course, students must have relational database basic concepts.

This course is designed for Data Analysts & Developers, Database Operators, Database Administrators, Database Support personnel, IS Managers, & similar personnel.