Oracle for Developers with PL/SQL (Version 7)
- Recommended Duration:
- 5 Days
- Version
- Oracle 7. Course available for Oracle8i/Oracle8.
- Benefits
- Introduces participants to Oracle and its most commonly used tools. Numerous hands-on exercises provide practice using SQL, SQL*Plus, PL/SQL and an introduction to embedded SQL.
- Audience
- Application developers who will design, code, and support systems using the Oracle Relational Data Base and its various programming tools.
- Prerequisites
- No prior knowledge of SQL or Oracle is required. Some programming experience is helpful for the embedded SQL portion of class.
- Major Topics
-
- Relational database concepts
- SQL syntax and usage
- Oracle database storage and locking
- SELECT, INSERT, UPDATE, DELETE GRANT, REVOKE statements
- Joins, outer joins, and subqueries
- Table / View / Synonym creation (DROP, CREATE, ALTER)
- SQL*Plus reporting
- Embedded SQL (Pro*C or Pro*COBOL)
- Stored PL/SQL Procedures, Functions, and Packages
- Database Triggers
- Exercises
- There are eighteen machine exercises.