Oracle SQL and PL / SQL Tutorial Video

Self Study, Oracle SQL and PL / SQL Tutorial Video on CD - DVD. The tutor guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. Works on both PC and Mac.

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..

try for free

Oracle SQL and PL / SQL Tutorial CD / DVD

Creates the perfect self-paced learning environment
on your own desktop.

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

Try 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 by expert
  • Free Certificate with each Tutorial
  • Works on PC or Mac
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.
$99.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