PL-SQL Programming for Oracle Professionals

PL-SQL Programming for Oracle Professionals (Certificate)

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

Pages:- 1
[ Online / Live ] [ Corporate Training ] [ Locations ] [ Schools ] [ Job Seekers ]

Dear Visitor: You are strongly recommended to bookmark this page and come back later, since new course may be available anytime. Click to Proceed>>