ORACLE Boot Camp (SQL & PL/SQL Programming)

5 days

Audience

Prerequisites

The course is intended for an entry-level audience.

The student should have basic familiarity with data processing concepts.

Description

This course was developed for developers who need a "quick-start" into the Oracle development environment.  The class covers basic concepts of relational databases and Oracle database concepts along with SQL, SQL Plus and PL/SQL programming.

Outline/Table of Contents

Introduction to Relational Databases

·   Database Types

·   Hierarchical and Network Databases

·   Relational Databases & Key Concepts

Oracle Overview

·   Oracle Platforms  & Oracle Products

·   Building Databases - Entity Relationship Modeling

·   Database Objects

·   Oracle Relational Database Capacities

·   Schema Objects

·   Reserved Words & Key Words

·   Naming Objects, Namespaces

·   Database Physical/Logical Structure Overview

·   Datatypes of SQL

SQL & SQL*PLUS COMMANDS

·   The Keys Used in SQL*Plus

·   SQL Commands, Entering and Executing Commands

·   SQLPLUS, Basic SQL*Plus Concepts, Running SQL*Plus Commands

·   Sample Tables

·   SQL Query Language

·   The Table DUAL

·   Basic SQL*Plus Commands

·   The SQL Buffer

·   Running PL/SQL Blocks

·   ORACLE Editor Commands

·   Remote Databases

·   Update

·   Creating a Test Table

·   Delete, Insert, Views, Indexes

·   Synonyms

·   SQL*Plus Reporting

·   The Compute Command

·   Master/Detail Report

·   Placing the Date in the Heading

·   Page Default Settings

·   Summarizing Across Groups

·   Summation of Decoded Columns

·   Expressing Results as a Percentage

·   Family Trees and Connect By

Tree-Structured QueryIntroduction to PL/SQL

·   PL/SQL's Relationship to SQL*PLUS and Other Products

·   Advantages of PL/SQL

·   Fundamentals of PL/SQL

·   Data Manipulation Statements

·   Loop Constructs

·   Branching Constructs

·   Error Handling

·   Cursor Processing

·   Exception and Error Handling

·   PL/SQL and Application Development

·   Embedded PL/SQL

·   Dynamic SQL & PL/SQL

·   Transaction Processing

·   Using PL/SQL in SQL*Forms Triggers

·   Using PL/SQL with Pro*Languages

·   PL/SQL Tables