oracle 10g pl/sql intermediate

global knowledge canada
calgary, edmonton, halifax, montreal, ottawa, quebec city, toronto, vancouver, winnipeg, canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' compile pl/sql programs; update, insert, and delete data; define and execute testing procedures and functions; and gain an understanding of advanced pl/sql features such as how to control data sharing and locking, debug and use error reporting procedures use oracle-supplied packages, and develop database triggers, stored procedures, and functions for future reuse.

certification
oracle pl/sql developer certified associate

what you’ll learn


the pl/sql environment, pl/sql program structure, native compilation, update, insert and delete statements, error functions / debugging, defining, executing and testing functions, and procedures
creating package specifications and bodies, creating triggers of all types, using oracle-supplied packages, understanding advanced pl/sql features
course outline


1. review of introduction to pl/sql
features and benefits of pl/sql, relationship of pl/sql to sql, pl/sql development tools
native compilation
pl/sql system and session parameters, pl/sql anonymous block structure
variable declarations, eclaring variable datatypes dynamically, declaring explicit cursors
pl/sql types and records, modifying database data (dml), transaction control statements, implicit attributes, exception handling, creating procedures, functions, packages, and dml triggers
2. advanced cursors
parameters, parameter defaults
taking advantage of a weak variable
open for, fetch and close
using the for update clause, pl/sql collections and nested collections
3. advanced packages
initializing variables, module overloading, recursion, purity levels
using the "persistent stateto advantage
one time only procedures, forward declarations, using persistent state, code encapsulation, constant and exception standardization
4. advanced triggers
trigger limitations, mutating and constraining tables
using call and client triggers, ddl / servererror triggers, logon/logoff, suspend, startup/shutdown triggers, schema versus database triggers
using alternative events and levels, instead of triggers on views
5. pl/sql composite datatypes and collections
pl/sql records, associative arrays (index by), nested tables, varrays
built-in type methods, arrays of composite types, using pl/sql record variables, pl/sql collections
6. bulk-bind data loading using pl/sql
defining bulk binds, bulk collect / forall, error handling with bulk binds - save exceptions
7. using oracle supplied packages
dbms_output package, utl_file package (file i/o)
dbms_alert package, dbms_pipe package , dbms_job package, dbms_scheduler package, dbms_stats package, dbms_utility package
utl_smtp package, utl_mail package, dbms_sql package
8. writing native dynamic sql
execute immediate, benefits of nds
9. pl/sql wrapper
pl/sql wrapper (source code encryption)
10. understanding dependencies
defining dependencies, local versus remote, viewing dependencies, effect of breaking dependency chain
11. large object management in pl/sql
differences between long/long raw and lobs
creating and using bfiles, creating tables with lobs, lobs and pl/sql, dbms_lob capabilities, temporary lobs
12. objects
basic objects, object inheritance
13. java
java in pl/sql, sample encapsulation
labs


lab 1: creating procedures
lab 2: creating functions
lab 3: creating packages
lab 4: creating triggers
lab 5: embedded functions and procedures
lab 6: creating autonomous transactions
lab 7: encrypting source code
lab 8: using the utl_file package
lab 9: using the dbms_alert package
lab 10: creating object types
lab 11: creating and manipulating object tables
lab 12: working with collections
lab 13: collections and bulk binding
lab 14: dbms_sql / native dynamic sql
lab 15: working with large objects
lab 16: load, publish, and run java ...''

Elements of this syllabus are subject to change.

Phone:1-800-courses

School Address:

global knowledge - canada
535 legget drive
suite 200
kanata, on k2k 3b8 canada



Jobs & Resumes: calgary, edmonton, halifax, montreal, ottawa, quebec city, toronto, vancouver, winnipeg
Houses & Roommates: calgary, edmonton, halifax, montreal, ottawa, quebec city, toronto, vancouver, winnipeg
Travel Agencies: calgary, montreal, ottawa, toronto, vancouver, winnipeg

Search other schools for oracle 10g pl/sql intermediate training resources.

Business Communications Manager 50 Rls. 3.0 Sales Engineering
Intelligent Contact Center for BCM
Nortel Converged Campus: ERS Solution
Nortel ERS 5000 & 4500 Advanced Configuration & Maintenance with Hands-in Labs
Nortel ERS 8600/8300/1600 Advanced Configuration and Maintenance
oracle 10g database administration
oracle 10g discoverer desktop
Oracle 10g Discoverer for Administrators
oracle 10g forms builder
oracle 10g release 2 business intelligence discoverer plus
oracle 10g reports builder
Oracle Application Server 10g
.net web developer
Advanced .NET Programming
Visual Studio.NET
Intermediate and Advanced .NET Programming
Windows Communication Foundation using VB.NET or C#
microsoft visio 2003 bundle

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.