Instructor Resources
Instructor resources from the Sideris Training Portal combined with Sideris custom print courseware make distance-learning and virtual training more effective than ever! Available for download when you purchase this title. Please turn on your audio, make sure you have the latest version of Adobe Reader and then watch the demo to see how these new instructor resources improve your instructor’s presentations!
Objectives
Major subject areas to be explored are:
• Understand the environment and context in which PL/SQL operates.
• Consider the advantages and benefits of PL/SQL within a database environment.
• Declaring program variables and complex data types.
• Developing logic within PL/SQL program blocks.
• Fetching data from the database into program variables.
• Returning program output to users.
• Handling program exceptions.
• Using explicit and implicit database cursors.
• Using the advanced features of nested blocks and subprograms.
• How to take advantage of advanced features such as regular expression support and the handling of string literals within program code.
Download PDF outline here!
