Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More Oracle

Related Courses

Oracle for Developers with PL/SQL

Recommended Duration:
5 Days
Version
Oracle 11g. Course is also useful for shops using Oracle 10g, 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.