Oracle: Intro to Oracle SQL and PL SQL Tutorial - Training Videos

Training CDs > Certification Tutorial Videos > ORACLE: INTRO TO ORACLE SQL AND PL SQL

Oracle: Intro to Oracle SQL and PL SQL Tutorial CD

Affordable Training you can depend on
This Oracle: Intro to Oracle SQL and PL SQL video tutorial utilizes an easy to follow training format that is both engaging and informative. Created to assist the beginners to intermediate users, the author uses a unique training method that brings a high degree of visual clarity to even the most complex applications. Being over 12 hours long these Oracle: Intro to Oracle SQL and PL SQL tutorials are extremely comprehensive and easy to follow. Video Training by Experts - Low Cost.

Not sure which Training CDs to buy?
The Online University allows unlimited access to the entire range of training titles for one low fee of only $30 per month. There is no fixed term, no limits, and you can cancel at any time. For corporate users and schools we also offer multi user accounts.
Find out more about the online video tutorials »

About the Free Video Online Training Course Demos
To allow you to evaluate the quality of the Oracle: Intro to Oracle SQL and PL SQL training course we have made the first 3 chapters of this tutorial available for free viewing online, the purchased version of this training course contains all the topics listed below. The free demos below have been compressed for faster playback over the internet, the audio and video quality of the purchased CD / DVD is far greater. To play the free demo videos you will need QuickTime,

THIS TUTORIAL COVERS THE FOLLOWING SUBJECTS

Description

This Oracle PL/SQL tutorial video on DVD / CD is an easy-to-understand learning resource ideal for novice programmers to learn how to deploy the power of Oracle and unleash many of the advanced features, the lessons are presented using highly visual narrated QuickTime tutorial videos.

Topics covered on this tutorial include: Introduction to Relational Databases, SQL Plus, PL/SQL, Control Files and Logs, Data Types, Tables, Queries, Constraints, Database Security, Privileges, Creating Users, Built in Oracle Functions, Logical Operators, Creating Joins, Using Group By, Filtering Results, Advanced SQL Queries in Oracle, Data Manipulation Language, Triggers and much more. You may also be intrested in the Oracle Fundmentals 2 Tutorial

Oracle: Intro to Oracle SQL and PL SQL Related Groups

Hide Description

The Blue Links below are free demos, when you purchase the video training CD / DVD the enitre content listings below are included , not just the free demo videos.

Welcome

The Oracle Relational Database Model

Oracle SQL and PL/SQL Tools

The Architecture of Oracle

The Oracle Database and Oracle Instance 1
The Oracle Database and Oracle Instance 2
Control Files, Logging, Archiving and Recoverability

Creating Database Objects

Oracle Simple Datatypes 1
Oracle Simple Datatypes 2
Oracle Complex and Object Datatypes
Types of Tables
Methods of Table Creation
Create Table Syntax
Example Table Creations Tutorials 1
Example Table Creations 2
Altering and Dropping Tables 1
Altering and Dropping Tables 2
What are Constraints?
Creating, Changing and Dropping Constraints
Types of Indexes 1
Types of Indexes 2
Creating, Altering and Dropping Indexes
Sequence Counters
Synonyms
Views Tutorials 1
Views 2
Metadata Views and Error Messages

Users and Security

Schemas, Users, Privileges and Roles 1
Schemas, Users, Privileges and Roles 2
Schemas, Users, Privileges and Roles 3
Types of Users
Creating Users Tutorials 1
Creating Users 2
Altering and Dropping Users
Security
Oracle SQL PL System Privileges
Object Privileges
Granting and Revoking Privileges Tutorials 1
Granting and Revoking Privileges 2
Grouping Privileges Using Roles 1
Grouping Privileges Using Roles 2
Setting Roles

Retrieving Data from the Database

Oracle PL SQL SELECT Statement Tutorials 1
The SELECT Statement 2
The SELECT Statement 3
Types of SELECT Statement 1
Types of SELECT Statement 2
The DUAL Table 1
The DUAL Table 2
What is a NULL?
Pseudo-Columns 1
Pseudo-Columns 2
More About Oracle PL SQL Plus Formatting 1
More About SQL Plus Formatting 2
More About SQL Plus Formatting 3

Oracle Built In Functions

Types of Functions Tutorials 1
Types of Functions 2
String Functions 1
String Functions 2
String Functions 3
Number Functions
Oracle PL SQL Date Functions 1
Date Functions 2
Other Functions 1
Other Functions 2
Datatype Conversion Functions 1
Datatype Conversion Functions 2
Custom Functions Using PL/SQL

Filtering SELECT Statements

The WHERE Clause
Conditional Comparisons
Using the WHERE Clause
Using Logical Operators Tutorials 1
Using Logical Operators 2
Using Conditional Comparisons 1
Using Conditional Comparisons 2

Sorting SELECT Statements

The ORDER BY Clause
Sorting Methods Tutorials 1
Sorting Methods 2
Sorting Methods 3

Joining Multiple Tables

What is a Join?
Two Join Syntax Formats
Types of Joins Tutorials 1
Types of Joins 2
Types of Joins 3
Cross Join or Cartesian Product
SQL PL Natural or Inner Join 1
Change the Concerts Schema 1
Change the Concerts Schema 2
Oracle PL SQL Outer Join 1
Outer Join 2
Self Join
Equi-Joins, Anti-Joins and Range-Joins
Mutable and Complex Joins

Summarizing with GROUP BY

What does GROUP BY Do?
The GROUP BY Clause
Types of Grouping Functions 1
Types of Grouping Functions 2
Special Behavior 1
Special Behavior 2
Summary Functions
Statistical Functions
Other Functions
Filtering GROUP BY with the HAVING Clause
Extending the GROUP BY Clause Tutorials 1
Extending the GROUP BY Clause 2

Subqueries and Other Advanced Queries

What is a Subquery?
Types of Subqueries
Comparison Conditions Revisited 1
Comparison Conditions Revisited 2
Comparison Conditions Revisited 3
Regular vs. Correlated Subqueries
Nested Subqueries and Replacing Joins
Where Can PL SQL Subqueries be Used?
Hierarchical Queries
Set Operators and Composite Queries

Oracle Data Manipulation Language (DML)

What is DML?
Adding Data with INSERT
Multiple Table INSERT Tutorials 1
Multiple Table INSERT 2
Changing Data with UPDATE 1
Changing Data with UPDATE 2
Remove Data with DELETE or TRUNCATE Tutorials 1
Remove Data with DELETE or TRUNCATE 2
Merging Tables with MERGE 1
Merging Tables with MERGE 2
Transactional Control
Locking and Visibility of Data Changes
COMMIT vs ROLLBACK

PL SQL (Programming Language SQL)

What is PL/SQL?
Anonymous Procedures
Modular Structure
Named Procedures
Functions
Packages
Oracle PL SQL Triggers Tutorials 1
Triggers 2
Variables and Types in PL/SQL 1
Variables and Types in PL/SQL 2
Objects and Object Datatypes
More About Objects 1
More About Objects 2
Programming Control Structures
Simple Database Access in PL/SQL
Cursors and Implicit Cursors 1
Cursors and Implicit Cursors 2
Explicit Cursor Tutorials 1
Explicit Cursors 2
Dynamic SQL
Provided (DBMS_) Packages

Oracle: Intro to Oracle SQL and PL SQL Tutorials - INFO

» Studio quality audio and video
» Works on Pc or Mac
» Ideal for people that learn quicker by being shown
» Master complex application in days

Title	:	Oracle: Intro to Oracle SQL and PL SQL
Instructor	:	Gavin Powell
Price	:	US$ 99.95
Duration	:	12 hours - 165 Movies
OS	:	Win Vista XP 98,2000,ME. Mac OS 9, OS X
Delivery Options	:	Ground / 2 day / Next Day
Product Code	:	33418

BENEFITS OF THIS TRAINING COURSE

Master Oracle: Intro to Oracle SQL and PL SQL in the shortest time possible
Self paced tutorial, training on video, at your own pace
Just sit back and watch, no books to read, just easy to follow lessons
Training can be viewed from any location, on PC or Mac
All training is self-contained; you don’t even need the application you are learning loaded on your machine
The most affordable way to learn, benefit from a world-leading expert
High quality content for a fraction of the cost of a classroom training course
The Tutorials can be rewound, fast forwarded or stopped at any time
Learn from the comfort of your own desk.