|
Provided by: Last Minute Training Plsql Programming for Oracle ProfessionalsOracle |
 |
Training
Provided by Last Minute Training
This course runs for five full days; from 8:30 am to 4:30 pm. PL/SQL is quickly becoming the most widely used programming language for Oracle. In this instructor-led course, we will explore topics such as:
* The Oracle Development Environment
* Creating the Database
* Creating Tables
* Structured Query Language Basics
* Advanced Structure Query Language
* PL/SQL Language Fundamentals
* Working With Records
* Working With Collections
* Exception Handling
* Procedures, Functions and Packages
* Database Triggers
* Introducing Objects
* Oracle Database Objects
* Large Objects
* And, if Time permits, Much More
* The Oracle Development Environment
* Creating the Database
* Creating Tables
* Structured Query Language Basics
* Advanced Structure Query Language
* PL/SQL Language Fundamentals
* Working With Records
* Working With Collections
* Exception Handling
* Procedures, Functions and Packages
* Database Triggers
* Introducing Objects
* Oracle Database Objects
* Large Objects
* And, if Time permits, Much More
|
|
||||||||||
Plsql Programming for Oracle Professionals
Module 0: The Oracle Development Environment
|
1. The Oracle Rdbms
2. About the Ansi SQL Standard
3. Pl/sql Versus SQL
4. Pl/sql Versus Java
5. Oracle Application Development Tools
| Module 1: Creating the Database
|
1. Creating the Database
2. Data Storage Architecture
3. Working with Tablespaces
4. Optimizing Data Storage
| Module 2: Creating Tables
|
1. Integrity Overview
2. Creating Data Types
3. Creating Rules and Defaults
4. Creating a Table
5. Primary and Foreign Keys
6. Creating Constraints
| Module 3: Structured Query Language Basics
|
1. SQL Overview
2. The Select Statement
3. Aggregate Values
4. The Insert Statement
5. The Update Statement
6. The Delete Statement
| Module 4: Advanced Structured Query Language
|
1. Join Strategies
2. Inner, Outer and Cross Joins
3. About Self-joins
4. Sub-queries
5. Creating Views
6. Using Views
| Module 5: Pl/sql Language Fundamentals
|
1. Pl/sql Overview
2. Pl/sql Blocks
3. Pl/sql Data Types
4. Using Variables
5. Pl/sql Operators
6. Conditional Statements
7. Repetitive Statements
8. Working with Built-in Functions
| Module 6: Working with Records
|
1. The Need for Records
2. What Is a Record
3. Using Records
4. Defining Record Types
5. Using Record Types As Parameters
6. Defining and Using Object Types
7. Records and Return Values
| Module 7: Working with Collections
|
1. Collection Overview
2. Exploring Varrays
3. Exploring Nested Tables
4. Exploring Associated Arrays
5. The Oracle Collection API
| Module 8: Exception Handling
|
1. What Is An Exception
2. Declaring Exceptions
3. Throwing Exceptions
4. Handling Exceptions
5. About Exception Propagation
6. Effective Exception Handling
| Module 9: Procedures, Functions and Packages
|
1. Creating a Package
2. Stored Functions and Sql: Single Valued Versus Multi-valued
3. Functions/procedures and the Shared Pool
4. About the Package Specification, Body and Scope
5. Procedures Versus Functions
6. Creating Functions/procedures
7. About Function/procedure Parameters
8. Creating Functions/procedures
9. About Function/procedure Parameters
10. Calling Functions/procedures
11. Stored Versus Local Functions/procedures
| Module 10: Database Triggers
|
1. Trigger Overview
2. Creating Dml Triggers
3. Creating Instead-of Triggers
4. Creating System Triggers
5. A Trigger Example
| Module 11: Introducing Objects
|
1. Using Objects in Oracle
2. Creating Object Types
3. Constructors and Attributes
4. Object Inheritance
5. About Attribute Chaining
6. Using Objects in Oracle
| Module 12: Oracle Database Objects
|
1. Object Overview
2. Object Tables
3. Object Columns
4. Object Methods
5. Object Operators
6. Persisted Objects
| Module 13: Large Objects
|
1. About Large Objects
2. Lob Types
3. Lob Structure
4. Internal Versus External Storage
5. Large Objects and SQL
6. Large Objects and Pl/sql
7. Lob Performance
|
1. The Oracle Rdbms
2. About the Ansi SQL Standard
3. Pl/sql Versus SQL
4. Pl/sql Versus Java
5. Oracle Application Development Tools
| Module 1: Creating the Database
|
1. Creating the Database
2. Data Storage Architecture
3. Working with Tablespaces
4. Optimizing Data Storage
| Module 2: Creating Tables
|
1. Integrity Overview
2. Creating Data Types
3. Creating Rules and Defaults
4. Creating a Table
5. Primary and Foreign Keys
6. Creating Constraints
| Module 3: Structured Query Language Basics
|
1. SQL Overview
2. The Select Statement
3. Aggregate Values
4. The Insert Statement
5. The Update Statement
6. The Delete Statement
| Module 4: Advanced Structured Query Language
|
1. Join Strategies
2. Inner, Outer and Cross Joins
3. About Self-joins
4. Sub-queries
5. Creating Views
6. Using Views
| Module 5: Pl/sql Language Fundamentals
|
1. Pl/sql Overview
2. Pl/sql Blocks
3. Pl/sql Data Types
4. Using Variables
5. Pl/sql Operators
6. Conditional Statements
7. Repetitive Statements
8. Working with Built-in Functions
| Module 6: Working with Records
|
1. The Need for Records
2. What Is a Record
3. Using Records
4. Defining Record Types
5. Using Record Types As Parameters
6. Defining and Using Object Types
7. Records and Return Values
| Module 7: Working with Collections
|
1. Collection Overview
2. Exploring Varrays
3. Exploring Nested Tables
4. Exploring Associated Arrays
5. The Oracle Collection API
| Module 8: Exception Handling
|
1. What Is An Exception
2. Declaring Exceptions
3. Throwing Exceptions
4. Handling Exceptions
5. About Exception Propagation
6. Effective Exception Handling
| Module 9: Procedures, Functions and Packages
|
1. Creating a Package
2. Stored Functions and Sql: Single Valued Versus Multi-valued
3. Functions/procedures and the Shared Pool
4. About the Package Specification, Body and Scope
5. Procedures Versus Functions
6. Creating Functions/procedures
7. About Function/procedure Parameters
8. Creating Functions/procedures
9. About Function/procedure Parameters
10. Calling Functions/procedures
11. Stored Versus Local Functions/procedures
| Module 10: Database Triggers
|
1. Trigger Overview
2. Creating Dml Triggers
3. Creating Instead-of Triggers
4. Creating System Triggers
5. A Trigger Example
| Module 11: Introducing Objects
|
1. Using Objects in Oracle
2. Creating Object Types
3. Constructors and Attributes
4. Object Inheritance
5. About Attribute Chaining
6. Using Objects in Oracle
| Module 12: Oracle Database Objects
|
1. Object Overview
2. Object Tables
3. Object Columns
4. Object Methods
5. Object Operators
6. Persisted Objects
| Module 13: Large Objects
|
1. About Large Objects
2. Lob Types
3. Lob Structure
4. Internal Versus External Storage
5. Large Objects and SQL
6. Large Objects and Pl/sql
7. Lob Performance
About The Training Provider: Last Minute Training
Last Minute Training - Last Minute Training Corp. works similar to last minute discounted travel. We sell training seminars at deep discounts on a last minute basis. If you want to save 30 - 60 off high quality training seminars and have the flexibility to attend with only a few days notice check out our website and see if the training you are looking for is on sale. While your there set up and free account...
