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 12c or 11g.
(earlier course versions available).
Benefits
Introduces participants to Oracle and its most commonly used tools. Numerous hands-on exercises provide practice using SQL, PL/SQL, and SQL*Plus or SQL Developer.
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.