Oracle for Developers with PL/SQL

Course Number: 573-JK
Recommended Duration: 5 days

Intended Audience: Application developers who will design, code, and support systems using the Oracle Data Base and its various programming tools.

Course Overview

This course introduces developers to Oracle 10g, SQL, SQL*Plus, and PL/SQL. (Suitable for Oracle9i, or Oracle8i; (Oracle 7 version available)). There are eighteen machine exercises.

Objectives

Introduces participants to Oracle and its most commonly used tools. Numerous hands-on exercises provide practice using SQL, SQL*Plus, and PL/SQL.

Prerequisites

No prior knowledge of SQL or Oracle is required. Some programming experience is helpful for the embedded SQL portion of class.

Topics

• Relational database concepts
• SQL syntax and usage
• Oracle database storage and locking
• SELECT, INSERT, UPDATE, DELETE, TRUNCATE, GRANT, REVOKE statements
• Joins and outer joins
• Subqueries
• UNION/INTERSECT/MINUS
• Table / View / Synonym creation (DROP, CREATE, ALTER)
• Referential Integrity features
• SQL*Plus reporting
• Stored PL/SQL Procedures, Functions, and Packages
• Database Triggers

Share with others

Can't Read? Click to Generate New Code

Enter the verification code shown above into the text box below