Oracle for Developers with PL/SQL
- Recommended Duration:
- 5 Days
- Version
- Oracle 10g. Course is also useful for shops using Oracle9i or Oracle8i. (earlier course versions available).
- Benefits
- Introduces participants to Oracle and its most commonly used tools. Numerous hands-on exercises provide practice using SQL, SQL*Plus, and PL/SQL.
- Audience
- Application developers who will design, code, and support systems using the Oracle 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, 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
- Exercises
- There are eighteen machine exercises.