NORTHERN
COMMUNITY
EDUCATION
Course Title : ADVANCED
ORACLE SQL AND PLSQL
Instructor : Hung Vu, MS. NVCC Faculty
(C) (202) 498-9785 ( C) (703)
835-0555
Email :
hvu@nvcc.edu
Email : hung.vu@irs.gov
Class Description:
Learn advanced features of Oracle SQL and PLSQL. Topics covered in class include advanced SQL
statements and complex PLSQL. Flashback,
outer join and inner join, rollup, cube, triggers, case, statements, regular expression, external tables, metadata statements will be discussed and
consolidated with practical examples.
Oracle PLSQL functions, procedures, DBMS_OUTPUT package, UTF file
utility, Error
handling will be also discussed.
Student Assessment:
Students will be awarded 2.4 CEU after class completion
Attendance
requirements : At least 90% of lecture
Course Prerequisite
:
Introduction to Oracle SQL and PLSQL
Course Methodology
:
This course covers advanced features of Oracle SQL and PLSQL. Lectures and extensive examples will be
presented. Hands-on-labs will be used to
consolidate material covered.
Course Materials:
Handouts and Labs prepared by instructor
Reference Book
:
1) Oracle Database 11g
. Master SQL and PLSQL, by Jason Price, ISBN 978-0-07-149850-0
CLASS
SCHEDULE
Week 1 :
DDL
script file concepts
Rollup,
Cube
SQL
functions
Merge
DBMS_MEGADATA.GET_DDL
Week 2:
Tables
join
Triggers
External tables
Flashback
Reg_exp
Function and
Procedures
Week 3 :
Implicit
cursor
Explicit
cursor
Function,
Procedures &
Packages
UTF
utility