Or A 101
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Or A 101 as PDF for free.
More details
- Words: 654
- Pages: 3
http://www.webucator.com Toll-free: 877-WEBUCATE (877-932-8228) From outside the U.S.: 315-391-6371 Fax: 315-410-5320
Comprehensive Introduction to Programming with PL/SQL on Oracle 10g Course length: 5 days Course Web Page: http://www.webucator.com/Database/ORA101.cfm
Class Overview The Oracle PL/SQL language provides for programming logic features not contained within SQL. The grammar, syntax and benefits of using the PL/SQL language within an Oracle database environment are considered. This course can be tailored for Application designers and developers or Database administrators.
Class Goals • • • • • • • • • •
Understand the environment and context in which PL/SQL operates Learn the advantages and benefits of PL/SQL within a database environment Learn to declare program variables and complex data types Learn to develop logic within PL/SQL program blocks Learn to fetch data from the database into program variables Returning program output to users Learn to handle program exceptions Learn to use explicit and implicit database cursors Learn to use the advanced features of nested blocks and subprograms Learn to take advantage of new features such as regular expression support and handling of string literals Understand application partitioning within a client/server or multi-tiered web-based architecture Understand the basic form and structure of program units stored within the database Learn to build and maintain database stored program units Learn to encapsulate stored units within packages and taking advantage of accompanying advanced programming techniques Learn to build and maintain DML-event and system-event database triggers Understand the storage and execution model for database programs and how one can write efficient programs to maximize performance Learn to use system-supplied packages to extend the power of your SQL statements and PL/SQL applications.
• • • • • • •
Class Prerequisites •
SQL as taught in Webucator's Comprehensive Introduction to Oracle SQL
Class Outline •
Language Features • • • •
Understanding Pl/SQL Structure Of A Pl/SQL Program Block Pl/SQL From Interactive Tools Generating Output Within SQL*Plus
Page 1 of 3
http://www.webucator.com Toll-free: 877-WEBUCATE (877-932-8228) From outside the U.S.: 315-391-6371 Fax: 315-410-5320
•
Declare Clause • • •
•
Begin Clause • • •
•
About The Exception Clause Isolating The Specific Exception
Explicit Cursors • •
•
About The Begin Clause Performing Data Manipulation Logic Control & Branching
Exception Clause • •
•
About The Declare Clause Declare Simple Types Complex Types
About Explicit Cursors Advanced Cursor Techniques
Advanced Programming: Nested Blocks • •
About The Advanced Features Using Nested Blocks
•
Advanced Programming: Declared Subprograms
•
Introducing Database Program Units • • • •
•
Creating Stored Procedures & Functions • • •
•
About Application Maintenance Recompiling & Dropping Programs Data Dictionary Storage Managing Dependencies
Creating & Maintaining Packages • • • •
•
Creating Procedures & Functions Executing Procedures & Functions Handling Compilation Errors
Maintaining Stored Procedures & Functions • • • •
•
Types Of Pl/SQL Program Units Types Of Stored Program Units Advantages Of Using Stored Program Units Development Tools
About Packages Creating Packages Advanced Programming Techniques Maintaining Packages
Advanced Cursor Techniques •
Using Cursor Variables
Page 2 of 3
http://www.webucator.com Toll-free: 877-WEBUCATE (877-932-8228) From outside the U.S.: 315-391-6371 Fax: 315-410-5320
•
Using System-Supplied Packages • •
•
Creating Database Triggers • • • • • •
•
About Database Triggers Statement-Level Triggers Row-Level Triggers Examples Of Triggers Instead Of Triggers Employing Triggers With An Application
Maintaining Database Triggers • • • • •
•
Dbms_Output() Utl_File()
About Trigger Maintenance Call Syntax Multiple Triggers Per Event Trigger Maintenance Tasks Handling Mutating Table Issues
Implementing System Event Triggers • • • •
What Are System Event Triggers? Defining The Scope Available System Events System Event Attributes
Class Materials Each student will get a copy of Oracle PL/SQL by Example by Benjamin Rosenzweig and Elena Silvestrova, in addition to a comprehensive set of materials, including course notes and all the programming examples.
Technical Requirements For more information... [email protected] Toll-free: 877-WEBUCATE (877-932-8228) From outside the U.S.: 315-391-6371 Fax: 315-410-5320
Page 3 of 3
Comprehensive Introduction to Programming with PL/SQL on Oracle 10g Course length: 5 days Course Web Page: http://www.webucator.com/Database/ORA101.cfm
Class Overview The Oracle PL/SQL language provides for programming logic features not contained within SQL. The grammar, syntax and benefits of using the PL/SQL language within an Oracle database environment are considered. This course can be tailored for Application designers and developers or Database administrators.
Class Goals • • • • • • • • • •
Understand the environment and context in which PL/SQL operates Learn the advantages and benefits of PL/SQL within a database environment Learn to declare program variables and complex data types Learn to develop logic within PL/SQL program blocks Learn to fetch data from the database into program variables Returning program output to users Learn to handle program exceptions Learn to use explicit and implicit database cursors Learn to use the advanced features of nested blocks and subprograms Learn to take advantage of new features such as regular expression support and handling of string literals Understand application partitioning within a client/server or multi-tiered web-based architecture Understand the basic form and structure of program units stored within the database Learn to build and maintain database stored program units Learn to encapsulate stored units within packages and taking advantage of accompanying advanced programming techniques Learn to build and maintain DML-event and system-event database triggers Understand the storage and execution model for database programs and how one can write efficient programs to maximize performance Learn to use system-supplied packages to extend the power of your SQL statements and PL/SQL applications.
• • • • • • •
Class Prerequisites •
SQL as taught in Webucator's Comprehensive Introduction to Oracle SQL
Class Outline •
Language Features • • • •
Understanding Pl/SQL Structure Of A Pl/SQL Program Block Pl/SQL From Interactive Tools Generating Output Within SQL*Plus
Page 1 of 3
http://www.webucator.com Toll-free: 877-WEBUCATE (877-932-8228) From outside the U.S.: 315-391-6371 Fax: 315-410-5320
•
Declare Clause • • •
•
Begin Clause • • •
•
About The Exception Clause Isolating The Specific Exception
Explicit Cursors • •
•
About The Begin Clause Performing Data Manipulation Logic Control & Branching
Exception Clause • •
•
About The Declare Clause Declare Simple Types Complex Types
About Explicit Cursors Advanced Cursor Techniques
Advanced Programming: Nested Blocks • •
About The Advanced Features Using Nested Blocks
•
Advanced Programming: Declared Subprograms
•
Introducing Database Program Units • • • •
•
Creating Stored Procedures & Functions • • •
•
About Application Maintenance Recompiling & Dropping Programs Data Dictionary Storage Managing Dependencies
Creating & Maintaining Packages • • • •
•
Creating Procedures & Functions Executing Procedures & Functions Handling Compilation Errors
Maintaining Stored Procedures & Functions • • • •
•
Types Of Pl/SQL Program Units Types Of Stored Program Units Advantages Of Using Stored Program Units Development Tools
About Packages Creating Packages Advanced Programming Techniques Maintaining Packages
Advanced Cursor Techniques •
Using Cursor Variables
Page 2 of 3
http://www.webucator.com Toll-free: 877-WEBUCATE (877-932-8228) From outside the U.S.: 315-391-6371 Fax: 315-410-5320
•
Using System-Supplied Packages • •
•
Creating Database Triggers • • • • • •
•
About Database Triggers Statement-Level Triggers Row-Level Triggers Examples Of Triggers Instead Of Triggers Employing Triggers With An Application
Maintaining Database Triggers • • • • •
•
Dbms_Output() Utl_File()
About Trigger Maintenance Call Syntax Multiple Triggers Per Event Trigger Maintenance Tasks Handling Mutating Table Issues
Implementing System Event Triggers • • • •
What Are System Event Triggers? Defining The Scope Available System Events System Event Attributes
Class Materials Each student will get a copy of Oracle PL/SQL by Example by Benjamin Rosenzweig and Elena Silvestrova, in addition to a comprehensive set of materials, including course notes and all the programming examples.
Technical Requirements For more information... [email protected] Toll-free: 877-WEBUCATE (877-932-8228) From outside the U.S.: 315-391-6371 Fax: 315-410-5320
Page 3 of 3
