Learn to use SQL to create and manage relational databases with tables and
table commands, synonyms, renaming of objects, truncation and more. Set up multiple users with various privileges and roles. Use new features and functions of PL/SQL.
Dr. Hany Greiss, your trainer, has over 16 years of experience as a software developer, senior analyst, consultant and trainer with emphasis in Oracle,
UNIX, C++, Windows, JAVA, & SQL. His internet address is hany@peac.com. He works for PEAC Inc. of Ottawa, Ontario Canada.
SQL Level 1 Video |
kyor71 |
$99.95 |
|
SQL Level 2 Video |
kyor72 |
$99.95 |
|
SQL Level 3 Video |
kyor73 |
$99.95 |
|
PL/SQL Level 1 Video |
kyor74 |
$99.95 |
|
PL/SQL Level 2 Video |
kyor75 |
$99.95 |
|
PL/SQL Level 3 Video |
kyor76 |
$99.95 |
|
Order ALL Six Oracle 7 Videos |
kyor7a |
$569.95 |
|
Oracle 8 Videos Detailed Descriptions |
SQL Level 1 Video |
kyor81 |
$99.95 |
|
SQL Level 2 Video |
kyor82 |
$99.95 |
|
SQL Level 3 Video |
kyor83 |
$99.95 |
|
SQL Level 4 Video |
kyor84 |
$99.95 |
|
SQL Level 5 Video |
kyor85 |
$99.95 |
|
SQL Levels 1-5 Video |
kyor8b |
$474.95 |
|
Oracle 8 PL/SQL Level 1 |
kyor86 |
$99.95 |
|
Oracle 8 PL/SQL Level 2 |
kyor87 |
$99.95 |
|
Oracle 8 PL/SQL Level 3 |
kyor88 |
$99.95 |
|
Oracle 8 PL/SQL Levels 1-3 |
kyor8c |
$289.95 |
|
Order ALL Eight Oracle 8 Videos |
kyor8a |
$699.95 |
|
SQL Level 1 (1 Hour 58 Minutes
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
SQL Level 2 (1 Hour 51 Minutes)
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
SQL Level 3 (1 Hour 56 Minutes)
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
SQL Level 4 (1 Hour 54 Minutes)
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
SQL Level 5 (1 Hour 41 Minutes)
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
PL/SQL Level 1 (1 Hour 51 Minutes)
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
PL/SQL Level 2 (1 Hour 58 Minutes)
1.0 Functions (1 Hour 28 Minutes)
1.1 Built-in Functions
1.2 Built-in Packages
1.3 Cursors
1.4 Rowtypes
1.5 Merging and Coding
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 Procedures
2.7 Examples of Functions
2.8 Alter & Drop Commands
PL/SQL Level 3 (1 Hour 32 Minutes)
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
Training Video Level 1 $99.95 #kyor71 (1 hr 33 min) 1.0 Relational Database Management Systems (7 min)
1.1 Three Major Aspects of the Relational Model
1.2 Relational Database Benefits
1.3 Logical Structure
1.4 Example of Tables & Views
1.5 Sequences
1.6 Procedures or Functions
1.7 Packages
1.8 Synonyms & Indexes
2.0 The Data Dictionary (6 min)
2.1 Overview of the Data Dictionary
2.2 Contents
2.3 The Structure of the Data Dictionary
2.4 The Prefix Scope
3.0 SQL Plus (17 min)
3.1 Getting Started in SQL Plus
3.2 Running & Editing SQL Commands
3.3 Ending an SQL Command
3.4 SQL Plus Buffer Manipulation Commands
3.5 Command Continuation
3.6 Edit Command
3.7 Get & Save Commands
3.8 Start Command
4.0 Interacting with SQL (24 min)
4.1 Define Command
4.2 Substitution Variables
4.3 Communicating with the User
4.4 Formatting Query Results
4.5 Producing Summary Lines
4.6 Top & Bottom Titles
4.7 Writing Query Output to a File
5.0 Structured Query Language (16 min)
5.1 Common Data Manipulation Language Commands
5.2 Common Data Definition Language Commands
5.3 Common Data Control Language Commands
5.4 Referencing Objects
5.5 Data Types
5.6 Precision & Scale
5.7 More Data Types
5.8 Literals
6.0 Oracles Example Database (20 min)
6.1 Investigating the current table
6.2 Nulls
6.3 Comments within SQL Statements
6.4 Operators
6.5 Arithmetic Operators
6.6 Character Operators
6.7 Comparison Operators
6.8 Logical Operators
6.9 Set Operators
SQL Level 2 Training Video $99.95 #kyor72 (1 hr 38 min)
1.0 Tables (21 min)
1.1 SQL Create Table Command
1.2 SQL Constraint Clause
1.3 Unique Keys & Primary Keys
1.4 Referential Integrity Constraints
1.5 Check Constraint
1.6 Example
1.7 Alter Table Command
1.8 SQL Drop Table Command
2.0 Insert, Update & Delete Commands (10 min)
2.1 SQL Insert Command
2.2 Delete Command
2.3 Update Command
3.0 Select Command & Joins (13 min)
3.1 Select Command
3.2 Joins
4.0 Synonyms, Renaming Objects & Truncate (21 min)
4.1 SQL Create Sequence Command
4.2 Using Sequences
4.3 Creating a Sequel Number Generator
4.4 Synonyms
4.5 Renaming Objects
4.6 SQL Truncate Command
5.0 Database Concepts (16 min)
5.1 Transactions
5.2 Commit Work Command
5.3 Rollback Command
5.4 SavePoint Command
5.5 Examples
5.6 Multi-user Consistency
5.7 Transaction Read Only
5.8 Data Locking
5.9 Lock Table Command
6.0 Build-in Functions & Format Modelers (16 min)
6.1 Build-in Functions
6.2 Categories
6.3 Number Function
6.4 Group Functions
6.5 Character Function
6.6 Date Function
6.7 Rules for Build-in Functions
6.8 Examples
6.9 Format Modeler
6.10 Number Format Modeler
6.11 More Examples
SQL Level 3 Training Video $99.95 #kyor73 (hr 6 min)
1.0 Indexes & Views (16 min)
1.1 Index Rules
1.2 Create View Command
1.3 Examples of Creating Indexes
1.4 Views
1.5 Uses of Views
1.6 Create View Command
1.7 Alter View Command
1.8 Drop View Command
1.9 Examples of Views
2.0 Creating Users (11 min)
2.1 Create User Command
2.2 Alter User Command
2.3 Drop User Command
2.4 Create Role Command
2.5 Set Roles
2.6 Privileges
3.0 Triggers (12 min)
3.1 Overview of Triggers
3.2 Uses of Triggers
3.3 Types of Triggers
3.4 Enabling & Disabling Triggers
3.5 Create Trigger Command
3.6 Alter Trigger Command
3.7 Examples of Triggers
4.0 Advanced Features of Oracle (5 min)
4.1 Stored Procedures
4.2 Stored Functions
4.3 Packages
5.0 General Database Aspects (20 min)
5.1 Backup & Recovery
5.2 Types of Exports
5.3 SQL Loading Utility
5.4 Import & Export Utilities
5.5 Oracle SQL Plus Utility PL/SQL Level 1 Video $99.95 #kyor74 (1 hr 51 min)
1.0 Overview of PL/SQL (20 min)
1.1 Introduction
1.2 Example: Emergence of PL/SQL
1.3 Privileges
1.4 Versions of PL/SQL
1.5 Client/Server Model
1.6 Coding Concepts & Guidelines
1.7 Examples of Note Case & Indentation
1.8 Comments
1.9 Components of a PL/SQL Program (Operators & Conditions)
1.10 Characters in PL/SQL Programs (or Meta & Literal Characters)
2.0 Specifics of SQL (43 min)
2.1 Block Structures
2.2 Creating a PL/SQL Block
2.3 Scope & Visibility
2.4 Example of Block & Scope
2.5 PL/SQL Data Types
2.6 Variables & Constants
2.7 Assigning Values to a Variable
2.8 Example: Declaration & Default Values
2.9 Anchored Declarations / Attributes
2.10 Advantages of Anchored Type Declarations
2.11 Control Structures
2.12 Example: If then Else; If Else if Statements
2.13 Iterative Control
2.14 Example: Loops
2.15 Sequential Loop
3.0 Exception Handling (16 min)
3.1 Overview of Exception Handling
3.2 Syntax: Exception Handler Defined
3.3 Example: Raise User Defined Exceptions
3.4 User Exception
3.5 Using the Raise_Application_Error Function
3.6 Predefined Exceptions
3.7 Example: Predefined Exceptions
3.8 PL/SQL Sequences using Exceptions PL/SQL Level 2 Video $99.95 #kyor75 (1 hr 59 min)
1.0 Functions, Packages & Cursors (45 min)
1.1 Overview of Built-in Functions
1.2 Example: Built-in Functions
1.3 Functions vs. Subroutines
1.4 Real Life Examples
1.5 Built-in Packages
1.6 Example: Packages DBMS_Output & DBMS_Utility
1.7 Cursors
1.8 Syntax: Cursor
1.9 Cursor Operations
1.10 Uses of a Cursor
1.11 Cursor Attributes
1.12 Example: More Advanced Cursors
1.13 Cursor Parameter Passing
2.0 Rowtypes, Records & Tables (58 min)
2.1 %Rowtype
2.2 SQL, PL/SQL & Pre-compilers
2.3 Records
2.4 Record Definition, Syntax of a Record
2.5 Tables
2.6 Declaring a Table
3.0 Review (14 min)
3.1 Example: lab5_4
3.2 Example: lab5_5
PL/SQL Level 3 Video $99.95 #kyor76 (1 hr 57 min)
1.0 Procedures, Functions & Triggers (1 hr 18 min)
1.1 Overview of Procedures & Functions
1.2 Advantages of Stored Procedures & Functions
1.3 Syntax: Create Procedure Statement
1.4 Syntax: Create Function Statement
1.5 Defining a Procedure or Function
1.6 Example: Create the Function Get_Bal
1.7 Benefits of Functions & Procedures Specification
1.8 More Complex Procedures
1.9 Example: Get_Name
1.10 Drop Procedure
1.11 Overloading Procedures
1.12 Triggers
2.0 Packages (38 min)
2.1 Overview of Packages
2.2 Benefits of Packages
2.3 Creating a Package
2.4 Example: Create Package Specification Statement
2.5 Create Employee Management Package |