PL/SQL Level 1

• 1.0 New Features (1 Hour 26 Minutes)
• 1.1 Object Orientation
• 1.2 Object Oriented Features
• 1.3 Vary Large Database Support
• 1.4 Advanced Queuing
• 1.5 External Procedures
• 1.6 New Datatypes
• 1.7 New Row ID Structures
• 1.8 Introduction to PL/SQL
• 1.9 History of PL/SQL
• 1.10 Components of PL/SQL
• 1.11 Good Habits to Form
• 1.12 Syntactical Issues
• 1.13 Characters in PL/SQL
• 1.14 Specifics of PL/SQL
• 2.0 Exception Handling (22 Minutes)
• 2.1 Overview of Exception Handling
• 2.2 Predefined Exceptions

• 1.0 Functions (1 Hour 28 Minutes)li>1.1 Built-in Functions
• 1.2 Built-in Packages1.3 Cursors
• 1.4 Rowtypes
• 1.5 Merging and Codingli>1.6 Records
• 1.7 Tables
• 2.0 Procedures, Functions and Triggers (29 Minutes)
• 2.1 Overview of Procedures and Functions
• 2.2 Advantages of Stored Procedures and Functions
• 2.3 Create Procedure Statement
• 2.4 Create Function Statement 2.5 Defining a Procedure or Function
• 2.6 Examples of Stored Proceduresli>2.7 Examples of Functions
• 2.8 Alter & Drop Commands

• 1.0 Overloading & Triggers (1 Hour 1 Minute)
• 1.1 Overview
• 1.2 Example
• 1.3 Triggers
• 1.4 Packages
• 2.0 New Features (29 Minutes)
• 2.1 Objects and Methods
• 2.2 Collections
• 2.3 External Procedures
• 2.4 Large Objects
• 2.5 Advanced Queuing

• 1.0 New Features (12 Minutes)
• 1.1 Object Orientation
• 1.2 Parallel Processing
• 1.3 Partitioning
• 1.4 Advanced Queuing
• 1.5 New Data types
• 2.0 The Basics (1 Hour 43 Minutes)
• 2.1 Relational Database Management Systems
• 2.2 The View
• 2.3 Sequences
• 2.4 Procedures and Functions
• 2.5 Other Schemas
• 2.6 The Data Dictionary
• 2.7 SQL*Plus
• 2.8 Writing Query Output to a File

• 1.0 SQL
• 1.1 Overview of SQL
• 1.2 Categories of SQL
• 1.3 Referencing Objects
• 1.4 Data Types
• 1.5 Nulls
• 1.6 Comments
• 1.7 Operators

• 1.0 Tables
• 1.1 SQL Create Table Command
• 1.2 SQL Constraint Clause
• 1.3 Unique Keys and Primary Keys
• 1.4 Referential Integrity
• 1.5 Check Constraint
• 1.6 Create Table Statement Example
• 1.7 Alter Table Command
• 1.8 SQL Drop Table Command
• 1.9 Insert Command
• 1.10 Delete Command
• 1.11 Update Command
• 1.12 Select Command
• 1.13 Joins

• 1.0 Synonyms, Renaming Objects, and Truncation
• 1.1 Sequences
• 1.2 Synonyms
• 1.3 Renaming Objects
• 1.4 Truncation
• 1.5 Database Concepts
• 1.6 Built-In Functions
• 1.7 Format Modelers
• 1.8 Indexes
• 1.9 Views

• 1.0 Users
• 1.1 Create, Alter & Drop User Commands
• 1.2 Set Roles
• 1.3 Privileges
• 1.4 Creating a Role
• 1.5 Triggers
• 1.6 Procedures, Functions and Packages
• 1.7 Backup and Recovery
• 1.8 Datatypes and Objects
• 1.9 Collections
• 1.10 Parallelism

Regular price: $719.95Sale price: $689.95

Click here for Secure Yahoo Order: Keystone Oracle 8 SQL & PL/SQL Video Series Set of 8

Get Train in Oracle
Oracle Training CD

Best Regards,
Oracle Database, SQL, Application, Programming Tips