SUMMARY:   This five-day workshop uses a 'Hands On' approach to teach the participant the essential concepts of ORACLE using SQL and PL/SQL. The workshop is up to date to release 11g. DURATION:   5 days. OBJECTIVES:   Upon completion of this workshop, the participant will be able to: Understand Relation Database Concepts. Run Queries using ORACLE SQL. Use Access Tools to query, modify, and manipulate objects. Use the ORACLE extensions of the SQL language. Code and execute simple and complex queries Use PL/SQL to build ORACLE Applications Code and execute Stored Procedure, Functions, and Packages Understand Database Triggers Understand the latest upgrades in Oracle COURSE CONTENT:   ORACLE overview ORACLE Objects Running ORACLE SQL Access TOOLS Simple SQL Queries SELECT FROM WHERE ORDER BY CASE Single Value Functions Math Date and Time Character and Data Conversion NVL, NVL2, NULLIF Group Functions MAX MIN AVG COUNT SUM MEDIAN GROUP BY HAVING ROLLUP CUBE SubQuery Simple Correlated Embedded Join Inner Outer UNION, INTERSECT, MINUS Creating Tables, and Views INSERT, UPDATE, DELETE, TRUNCATE Data Dictionary Views PL/SQL – Basics Using functions in PL/SQL Looping Conditionals IF CASE Handling Exceptions Cusrors Stored Procedures Stored Functions Using Packages Triggers Using External Tables MS/09