Oracle Bootcamp

    

Summary:
The student will learn how to efficiently utilize basic, intermediate and advanced features of SQL, SQL*Plus, and Oracle's procedural language, PL/SQL. The concepts mastered are the basis for the development of applications using Oracle, Oracle reporting, Oracle applications and Oracle database administration.

Duration:
5 Days/Lecture & Lab

Audience:
This course is designed for those who wish to efficiently program in the Oracle database environment.

Topics:

• Overview of relational databases and Oracle
• Characteristics of SQL
• Sequences
• Synonyms
• Working with NULL values
• Retrieving
• Operators
• CASE Statements
• Subqueries
• Joining tables
• Functions
• Datatype Conversion
• Group Functions
• Data Definition Language - CREATE, ALTER, DROP
• Indexes
• Views
• Transaction processing - commit, rollback, and savepoint
• Data manipulation - insert, update, delete
• SQL*Plus Interface
• SQL*Plus editor commands
• Control breaks and computing values
• Save commands and spool output
• Formatting SQL*Plus output and reports
• Introduction to PL/SQL
• PL/SQL blocks
• Declarations
• Assignments
• Using SQL statements in PL/SQL
• Conditional statements
• Looping statements
• Using cursors
• Cursor attributes
• Cursor FOR loops
• Using parameters with cursors
• Exception (error) handling
• User defined exceptions
• Introduction to stored procedures and functions
• Introduction to packages
• Introduction to database triggers

Prerequisites:
The student should have knowledge of relational database design concepts and the ability to utilize the host operating system to create and edit files.

Last Update: February 8, 2012