Oracle PL/SQL

    

Summary:
Students interact directly with an Oracle RDBMS server from a client workstation. Labs are designed to reinforce the learning experience, moving the student from concept to actual experience with Oracle RDBMS. The focus of this course will be on lab exercises along with solutions, review questions, Oracle Certified Professional sample questions and answers, help in using tools with the Oracle RDBMS, and the best available information on the subject. Exposure to actual screens, graphics, as well as menus is received from the direct use and availability of Oracle RDBMS software on an Oracle database.

Duration:
2 Days/Lecture & Lab

Audience:
This course is designed for future administrators, developers, and advanced users, of organizations with Oracle RDBMS’s. The course is also beneficial for those moving to the Oracle environments that are not familiar with Oracle RDBMS concepts.

Topics:

• Oracle PL/SQL Fundamentals Oracle PL/SQL Control Structures
• Oracle PL/SQL Cursors Oracle PL/SQL Exceptions
• Oracle PL/SQL Stored Program Units Oracle Database Triggers
• Oracle, Java, and PL/SQL SQLJ
• Overview of integration between Oracle and Java including PL/SQL, SQLJ, JDBC, and Java Stored Procedures
• Release Information for Oracle7, Oracle8, Oracle8i, Oracle9i, Oracle 10g, and Oracle 11g

Prerequisites:
Students attending this course must have user side familiarity with modern day computers and operating systems. Exposure to computer languages and databases is helpful but not necessary.

Last Update: February 7, 2012