PL-SQL Programming for Oracle Professionals (Certificate)

CBIT Canadian Beaver Training Ottawa
Ottawa, Ontario, Canada

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

Course Description:

'' Module 0: The Oracle Development Environment
| The Oracle Rdbms
About the Ansi SQL Standard
Pl/sql Versus SQL
Pl/sql Versus Java
Oracle Application Development Tools

| Module 1: Creating the Database
| Creating the Database
Data Storage Architecture
Working with Tablespaces
Optimizing Data Storage

| Module 2: Creating Tables
| Integrity Overview
Creating Data Types
Creating Rules and Defaults
Creating a Table
Primary and Foreign Keys
Creating Constraints

| Module 3: Structured Query Language Basics
| SQL Overview
The Select Statement
Aggregate Values
The Insert Statement
The Update Statement
The Delete Statement

| Module 4: Advanced Structured Query Language
| Join Strategies
Inner, Outer and Cross Joins
About Self-joins
Sub-queries
Creating Views
Using Views

| Module 5: Pl/sql Language Fundamentals
| Pl/sql Overview
Pl/sql Blocks
Pl/sql Data Types
Using Variables
Pl/sql Operators
Conditional Statements
Repetitive Statements
Working with Built-in Functions

| Module 6: Working with Records
| The Need for Records
What Is a Record
Using Records
Defining Record Types
Using Record Types As Parameters
Defining and Using Object Types
Records and Return Values

| Module 7: Working with Collections
| Collection Overview
Exploring Varrays
Exploring Nested Tables
Exploring Associated Arrays
The Oracle Collection API

| Module 8: Exception Handling
| What Is An Exception
Declaring Exceptions
Throwing Exceptions
Handling Exceptions
About Exception Propagation
Effective Exception Handling

| Module 9: Procedures, Functions and Packages
| Creating a Package
Stored Functions and Sql: Single Valued Versus Multi-valued
Functions/procedures and the Shared Pool
About the Package Specification, Body and Scope
Procedures Versus Functions
Creating Functions/procedures
About Function/procedure Parameters
Creating Functions/procedures
About Function/procedure Parameters
Calling Functions/procedures
Stored Versus Local Functions/procedures

| Module 10: Database Triggers
| Trigger Overview
Creating Dml Triggers
Creating Instead-of Triggers
Creating System Triggers
A Trigger Example

| Module 11: Introducing Objects
| Using Objects in Oracle
Creating Object Types
Constructors and Attributes
Object Inheritance
About Attribute Chaining
Using Objects in Oracle

| Module 12: Oracle Database Objects
| Object Overview
Object Tables
Object Columns
Object Methods
Object Operators
Persisted Objects

| Module 13: Large Objects
| About Large Objects
Lob Types
Lob Structure
Internal Versus External Storage
Large Objects and SQL
Large Objects and Pl/sql
Lob Performance
...''

Elements of this syllabus are subject to change.

Phone:613 742-6800

School Address/Venue(s):

CBIT Canadian Beaver Training Ottawa
214 Montreal Rd
Suite 100
Ottawa, Ontario
K1L 8L8
Canada

Jobs & Resumes: Ottawa
Houses & Roommates: Ottawa
Travel Agencies: Ottawa

Search other schools for PL-SQL Programming for Oracle Professionals training resources.

SQL Server Programming
SQL Server Administration
SQL Server 2008
Oracle Server
Building a Data Warehouse with Oracle
Oracle Core Administration Skills

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: This website holds more than 300,000 training course records worldwide, with hundreds of new postings daily. All services in this website are free!