Oracle SQL and PL / SQL Tutorial Video

Self Study, Tutorial Video on CD - DVD. Tutor Gavin Powell guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. It works on both PC and Mac, this course is ideal for Beginners and Advanced users

These Oracle SQL PL / SQL tutorials are an indispensable reference for programmers that wish to have a much stronger understanding of Oracle. Expert Gavin Powell has constructed this course with one objective in mind, to allow you to gain a strong understanding of Oracle and create more efficient code. This training course starts with a introduction into PL / SQL programming and as the training progresses the subjects that are covered get more advanced. A basic understanding of SQL and databases is a prerequisite before embarking on this course.. Watch our free Oracle SQL and PL / SQL Tutorial Videos by clicking the blue lesson links below.

try for free

Oracle SQL and PL / SQL Tutorial CD / DVD

Create the best self-paced learning environment
right on your own desktop.

Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.

Learn for FREE - NOW. To help you evaluate this training CD / DVD the first 3 chapters are available for free, click on any of the links below for a FREE DEMO.

Problems Playing the Demos?
Benefits
  • Professional Tuition from an Expert
  • Free Certificate with Each Tutorial
  • Works on PC or Mac
Just Released This Week
Apple Logic Pro 9 tutorial video
Logic Pro 9 Tutorial Video »
Topics Covered on this Training Video Include:
Welcome The Oracle Relational Database Model Oracle SQL and PL/SQL Tools
We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.
$149.95
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
UK & Europe
Apex Web Media
PO Box 398
Bolton, BL7 9RZ
United Kingdom
T: 01204 592071
USA & Canada
600 17th Street, Suite 2800, Denver CO 80202
Open 8am - 5pm M to F (EST)
Tel - Toll free 1866 402 1903 ( USA )
Tel 434-878-4158
Fax 1 207 433 4356