VTC - Intermediate Oracle 11g (2013) [repost]

This Intermediate VTC course expands on the Introduction to Oracle 11g course. It gives you a more detailed grass roots knowledge of Oracle SQL and Oracle PL/SQL. Author and expert Gavin Powell covers a wide range of topics including many types of queries, expressions, and statements. He also explores sequences, synonyms, views, materialized views, user access and security, working with indexes, and the basics of programming with PL/SQL. As with the introductory course, this intermediate course is not focused on Oracle Certification but will give you a good start towards some more advanced aspects of coding SQL and PL/SQL. To begin learning today, simply click on the movie links.

Introduction
Welcome to Intermediate Oracle 01:13
Prerequisites for This Course 02:34
About This Course 02:55

Subqueries
What is a Subquery? 04:29
Subquery Syntax 05:21
Types of Subqueries 06:22
Where Can Subqueries Be Used? 05:40
Comparison Conditions pt. 1 03:54
Comparison Conditions pt. 2 05:40
Regular vs. Correlated Subqueries 05:19
Using the WITH Clause 05:45
Nested Semi Joins 06:45

Specialized Queries
Composite Query Syntax 04:18
Using Composite Queries pt. 1 06:02
Using Composite Queries pt. 2 02:26
Hierarchical Queries 03:41
Hierarchical Query Syntax 03:48
Hierarchical Family Trees pt. 1 06:09
Hierarchical Family Trees pt. 2 06:21
Flashback Query Syntax 02:54
Flashback Query Pseudocolumns 02:02
Using Flashback Queries pt. 1 04:47
Using Flashback Queries pt. 2 03:01

Expressions and Regular Expressions
What an Expression Is 06:07
Types of Expressions 01:42
Expression Types Demo pt. 1 05:45
Expression Types Demo pt. 2 04:37
Expression Types Demo pt. 3 06:46
Meta Characters 06:30
Regular Expression Functions 05:01
Using Regular Expression Patterns 06:41
Check Constraint Regular Expressions 03:00
Oracle Expression Filter 02:47

Changing Tables
The ALTER TABLE Command 02:30
Table Properties pt. 1 06:52
Table Properties pt. 2 06:22
Columns pt. 1 04:00
Columns pt. 2 05:31
Columns pt. 3 05:07
Columns pt. 4 03:56
Constraints Options 02:39
Constraint States 06:44
Renaming and Dropping Constraints 04:48

Changing Data
What the DML Commands Are 03:04
INSERT Statement Syntax 05:37
Using INSERT pt. 1 03:38
Using INSERT pt. 2 04:46
Using INSERT pt. 3 05:58
UPDATE Statement Syntax 02:01
Using UPDATE 04:56
DELETE and TRUNCATE Syntax 06:05
Using DELETE and TRUNCATE 06:29
MERGE Statement Syntax 03:46
Using MERGE 05:59
Transactional Control 06:26
Demonstrating Transaction Control 05:29

Users and Security
Oracle Security pt. 1 06:02
Oracle Security pt. 2 05:06
Types of Users 06:10
Create User Syntax pt. 1 05:46
Create User Syntax pt. 2 04:13
Using CREATE USER pt. 1 04:16
Using CREATE USER pt. 2 03:50
Alter and Drop User Syntax 04:26
Using ALTER and DROP USER 05:56
Oracle Power Users 06:59
Resources and Profiles 01:41
Privileges pt. 1 06:02
Privileges pt. 2 05:41
Granting and Revoking Privileges 05:57
Using GRANT pt. 1 04:00
Using GRANT pt. 2 03:07
Using REVOKE 05:16
Group Privileges Using Roles 03:08
Setting Roles 01:41
Metadata Views pt. 1 04:49
Metadata Views pt. 2 03:26

Specialized Database Objects
Sequence Syntax 05:08
What and Where and How of Sequences 03:30
Using Sequences 06:25
Synonym Syntax 04:31
Using Synonyms 06:16
Database Links 05:39
Views and Materialized Views 06:46
Using Views 04:23
Metadata Views pt. 1 05:00
Metadata Views pt. 2 06:02

Working with Indexes
Types of Indexes 04:24
Index Attributes 06:09
BTree Indexes 05:51
Function-Based Indexes 04:49
Bitmap Indexes 05:45
Exotic Indexing 04:37
Creating Indexes pt. 1 05:55
Creating Indexes pt. 2 03:08
Changing and Dropping Indexes 06:53
Working with Indexes pt. 1 06:49
Working with Indexes pt. 2 06:05
Metadata Views 06:20
PL/SQL
What PL/SQL Is pt. 1 03:47
What PL/SQL Is pt. 2 06:02
Why PL/SQL Is Programming 06:36
Blocks & Exception Traps pt. 1 05:22
Blocks & Exception Traps pt. 2 04:06
Named Procedures pt. 1 03:52
Named Procedures pt. 2 07:09
Functions 06:02
Triggers pt. 1 04:48
Triggers pt. 2 05:25
Triggers pt. 3 04:51
Packages 06:08
Variables and Datatypes pt. 1 06:26
Variables and Datatypes pt. 2 02:47
Programming Control Structures 04:56
Simple PL/SQL Database Access 05:41
Explicit Cursors 06:26
Implicit Cursors pt. 1 05:18
Implicit Cursors pt. 2 06:53
Dynamic SQL pt. 1 06:35
Dynamic SQL pt. 2 05:18
Wrapping Up PL/SQL 04:11

Conclusion
Course Wrap Up 04:51
About the Author 01:19