To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.
Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.
лл Hide This
|
Welcome
|
 |
Welcome |
(02:27) |
|
Useful Web Sites |
(04:56) |
|
What is Oracle Software? |
(03:10) |
|
The History of Databases |
(06:06) |
|
The History of Oracle |
(05:07) |
|
About this Course |
(05:10) |
The Relational Database Model
|
|
The Relational Database Model |
(04:57) |
|
The Concerts Schema |
(02:57) |
|
Normalization pt. 1 |
(07:38) |
|
Normalization pt. 2 |
(04:06) |
|
Denormalization pt. 1 |
(05:22) |
|
Denormalization pt. 2 |
(06:09) |
Oracle SQL and PL/SQL Tools
|
|
What are the Oracle SQL and PL/SQL Tools? |
(02:42) |
|
SQL Plus |
(05:08) |
|
Formatting Output |
(05:34) |
|
SQL Plus Worksheet |
(03:59) |
|
iSQL Plus |
(02:35) |
|
Oracle Enterprise Manager pt. 1 |
(04:46) |
|
Oracle Enterprise Manager pt. 2 |
(01:11) |
The Architecture of Oracle
|
 |
The Oracle Database and Oracle Instance pt. 1 |
(04:10) |
|
The Oracle Database and Oracle Instance pt. 2 |
(01:54) |
|
Control Files, Logging, Archiving and Recoverability |
(02:49) |
Creating Database Objects
|
|
Oracle Simple Datatypes pt. 1 |
(04:10) |
|
Oracle Simple Datatypes pt. 2 |
(05:00) |
|
Oracle Complex and Object Datatypes |
(03:22) |
|
Types of Tables |
(05:10) |
|
Methods of Table Creation |
(06:03) |
|
Create Table Syntax |
(02:00) |
|
Example Table Creations pt. 1 |
(05:09) |
|
Example Table Creations pt. 2 |
(04:59) |
|
Altering and Dropping Tables pt. 1 |
(04:53) |
|
Altering and Dropping Tables pt. 2 |
(02:23) |
|
What are Constraints? |
(05:40) |
|
Creating, Changing and Dropping Constraints |
(06:21) |
|
Types of Indexes pt. 1 |
(07:37) |
|
Types of Indexes pt. 2 |
(04:10) |
|
Creating, Altering and Dropping Indexes |
(05:36) |
|
Sequence Counters |
(05:02) |
|
Synonyms |
(01:02) |
|
Views pt. 1 |
(02:08) |
|
Views pt. 2 |
(01:47) |
|
Metadata Views and Error Messages |
(06:02) |
Users and Security
|
|
Schemas, Users, Privileges and Roles pt. 1 |
(04:37) |
|
Schemas, Users, Privileges and Roles pt. 2 |
(04:49) |
|
Schemas, Users, Privileges and Roles pt. 3 |
(07:38) |
|
Types of Users |
(04:06) |
|
Creating Users pt. 1 |
(05:52) |
|
Creating Users pt. 2 |
(07:08) |
|
Altering and Dropping Users |
(02:09) |
|
Security |
(03:35) |
|
System Privileges |
(04:26) |
|
Object Privileges |
(00:58) |
|
Granting and Revoking Privileges pt. 1 |
(06:22) |
|
Granting and Revoking Privileges pt. 2 |
(02:13) |
|
Grouping Privileges Using Roles pt. 1 |
(06:59) |
|
Grouping Privileges Using Roles pt. 2 |
(02:16) |
|
Setting Roles |
(01:35) |
Retrieving Data from the Database
|
|
The SELECT Statement pt. 1 |
(03:14) |
|
The SELECT Statement pt. 2 |
(07:08) |
|
The SELECT Statement pt. 3 |
(03:18) |
|
Types of SELECT Statement pt. 1 |
(06:53) |
|
Types of SELECT Statement pt. 2 |
(01:45) |
|
The DUAL Table pt. 1 |
(02:59) |
|
The DUAL Table pt. 2 |
(03:15) |
|
What is a NULL? |
(06:25) |
|
Pseudo-Columns pt. 1 |
(04:19) |
|
Pseudo-Columns pt. 2 |
(02:58) |
|
More About SQL Plus Formatting pt. 1 |
(04:15) |
|
More About SQL Plus Formatting pt. 2 |
(05:25) |
|
More About SQL Plus Formatting pt. 3 |
(06:10) |
Oracle Built In Functions
|
|
Types of Functions pt. 1 |
(04:32) |
|
Types of Functions pt. 2 |
(04:37) |
|
String Functions pt. 1 |
(04:58) |
|
String Functions pt. 2 |
(07:42) |
|
String Functions pt. 3 |
(05:40) |
|
Number Functions |
(05:51) |
|
Date Functions pt. 1 |
(04:11) |
|
Date Functions pt. 2 |
(04:24) |
|
Other Functions pt. 1 |
(02:55) |
|
Other Functions pt. 2 |
(05:53) |
|
Datatype Conversion Functions pt. 1 |
(05:21) |
|
Datatype Conversion Functions pt. 2 |
(02:07) |
|
Custom Functions Using PL/SQL |
(00:46) |
Filtering SELECT Statements
|
|
The WHERE Clause |
(01:42) |
|
Conditional Comparisons |
(01:20) |
|
Using the WHERE Clause |
(01:26) |
|
Using Logical Operators pt. 1 |
(05:06) |
|
Using Logical Operators pt. 2 |
(01:37) |
|
Using Conditional Comparisons pt. 1 |
(05:30) |
|
Using Conditional Comparisons pt. 2 |
(06:01) |
Sorting SELECT Statements
|
|
The ORDER BY Clause |
(03:49) |
|
Sorting Methods pt. 1 |
(03:23) |
|
Sorting Methods pt. 2 |
(06:36) |
|
Sorting Methods pt. 3 |
(03:32) |
Joining Multiple Tables
|
|
What is a Join? |
(06:55) |
|
Two Join Syntax Formats |
(04:13) |
|
Types of Joins pt. 1 |
(02:32) |
|
Types of Joins pt. 2 |
(05:55) |
|
Types of Joins pt. 3 |
(02:55) |
|
Cross Join or Cartesian Product |
(04:04) |
|
Natural or Inner Join pt. 1 |
(05:34) |
|
Change the Concerts Schema pt. 1 |
(03:35) |
|
Change the Concerts Schema pt. 2 |
(04:45) |
|
Outer Join pt. 1 |
(03:49) |
|
Outer Join pt. 2 |
(06:33) |
|
Self Join |
(01:25) |
|
Equi-Joins, Anti-Joins and Range-Joins |
(03:07) |
|
Mutable and Complex Joins |
(03:24) |
Summarizing with GROUP BY
|
|
What does GROUP BY Do? |
(05:25) |
|
The GROUP BY Clause |
(03:36) |
|
Types of Grouping Functions pt. 1 |
(03:34) |
|
Types of Grouping Functions pt. 2 |
(04:49) |
|
Special Behavior pt. 1 |
(04:46) |
|
Special Behavior pt. 2 |
(04:45) |
|
Summary Functions |
(04:49) |
|
Statistical Functions |
(02:30) |
|
Other Functions |
(04:00) |
|
Filtering GROUP BY with the HAVING Clause |
(03:17) |
|
Extending the GROUP BY Clause pt. 1 |
(04:52) |
|
Extending the GROUP BY Clause pt. 2 |
(03:56) |
Subqueries and Other Advanced Queries
|
|
What is a Subquery? |
(01:20) |
|
Types of Subqueries |
(06:57) |
|
Comparison Conditions Revisited pt. 1 |
(05:34) |
|
Comparison Conditions Revisited pt. 2 |
(04:51) |
|
Comparison Conditions Revisited pt. 3 |
(03:13) |
|
Regular vs. Correlated Subqueries |
(01:15) |
|
Nested Subqueries and Replacing Joins |
(06:27) |
|
Where Can Subqueries be Used? |
(04:38) |
|
Hierarchical Queries |
(04:51) |
|
Set Operators and Composite Queries |
(04:14) |
Oracle Data Manipulation Language (DML)
|
|
What is DML? |
(03:39) |
|
Adding Data with INSERT |
(04:45) |
|
Multiple Table INSERT pt. 1 |
(02:20) |
|
Multiple Table INSERT pt. 2 |
(07:03) |
|
Changing Data with UPDATE pt. 1 |
(04:32) |
|
Changing Data with UPDATE pt. 2 |
(05:51) |
|
Remove Data with DELETE or TRUNCATE pt. 1 |
(04:19) |
|
Remove Data with DELETE or TRUNCATE pt. 2 |
(04:23) |
|
Merging Tables with MERGE pt. 1 |
(06:50) |
|
Merging Tables with MERGE pt. 2 |
(00:57) |
|
Transactional Control |
(03:55) |
|
Locking and Visibility of Data Changes |
(04:57) |
|
COMMIT vs ROLLBACK |
(04:27) |
PL/SQL (Programming Language SQL)
|
|
What is PL/SQL? |
(03:51) |
|
Anonymous Procedures |
(02:56) |
|
Modular Structure |
(04:27) |
|
Named Procedures |
(07:05) |
|
Functions |
(03:23) |
|
Packages |
(07:10) |
|
Triggers pt. 1 |
(07:02) |
|
Triggers pt. 2 |
(05:06) |
|
Variables and Types in PL/SQL pt. 1 |
(05:12) |
|
Variables and Types in PL/SQL pt. 2 |
(05:06) |
|
Objects and Object Datatypes |
(03:49) |
|
More About Objects pt. 1 |
(06:16) |
|
More About Objects pt. 2 |
(07:38) |
|
Programming Control Structures |
(05:55) |
|
Simple Database Access in PL/SQL |
(06:13) |
|
Cursors and Implicit Cursors pt. 1 |
(02:11) |
|
Cursors and Implicit Cursors pt. 2 |
(07:03) |
|
Explicit Cursors pt. 1 |
(03:20) |
|
Explicit Cursors pt. 2 |
(06:43) |
|
Dynamic SQL |
(05:02) |
|
Provided (DBMS_) Packages |
(01:58) |
Credits
|
|
About the Author |
(02:00) |
The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)