Loading Course Schedule...
PT27145
Training Summary
This course provides students that have a background with SQL and/or another programming language in a non-Oracle environment with an introduction to Oracle. A discussion of the Oracle architecture will provide the foundation for students to understand both SQL statement and PL/SQL program processing. Students will add to their SQL knowledge Oracle’s proprietary extensions to the SQL language. Students will also learn how to write PL/SQL stored procedures, functions, packages and triggers. Hands-on workshops provide students with a solid understanding of the concepts presented in the lectures. This course can be taught for any Oracle version.
Prerequisites
There are no prerequisites for this course.
Duration
4 Days/Lecture & Lab
Audience
Experienced Db2 or SQL Server developers.
Course Topics
- Oracle Architecture for Developers
- Oracle SQL – Proprietary
- Introduction to Oracle PL/SQL
- The PL/SQL DECLARE Section
- The PL/SQL BEGIN Section
- Embedded SQL in PL/SQL Programs
- Processing Multiple Records in PL/SQL Programs
- Declaring, Raising and Handling Program Exceptions in PL/SQL Programs
- PL/SQL Stored Procedures and Functions
- PL/SQL Packages
- PL/SQL Triggers