This Oracle 11g R2 PL/SQL training teaches attendees beginning and advanced Oracle PL/SQL database programming skills.
ORACLE 11G R2 PL/SQL TRAINING OBJECTIVES
Understand the environment and context in which PL/SQL operates.
Consider the advantages and benefits of PL/SQL within a database environment.
Declare program variables and complex data types.
Develop logic within PL/SQL program blocks.
Fetch data from the database into program variables.
Return program output to users.
Handle program exceptions.
Use explicit and implicit database cursors.
Maintain and implement triggers.
ORACLE 11G R2 PL/SQL TRAINING PREREQUISITES
Prior Oracle SQL experience is presumed.
ORACLE 11G R2 PL/SQL TRAINING MATERIALS
All students receive comprehensive courseware and a related textbook.
SOFTWARE NEEDED FOR EACH PC:
A complete installation of Oracle Express Edition 11g R2
Oracle SQL Developer
For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor’s screen simultaneously with working on their own.