Become a member

Online Access to 1000+ Courses!

Intermediate Oracle 11g Course

Author : Gavin Powell

10.5hrs (123 Lessons) 2012-11-13

This Course can only be played using a subscription. You can play only first 3 chapters for free. Click Here to avail a subscription
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.

Welcome to VTC's Intermediate Oracle 11g Database Course. I am Gavin Powell and I will be your instructor. A quick mention about my skills before we get started. I have 25 years of hands on experience working in IT and with Oracle. You can find out more about me in the About the Author video at the end of this course. This course is the second in a series on Oracle 11g available from VTC. The other one is called Introduction to Oracle 11g Database. If you are a beginner it is suggested that you at least review the introductory course first so that you have the fundamentals. However even for more advanced Oracle practitioners, it's best to actually review the introductory course as well because this intermediate course is an extension of the introductory course rather than an enhancement of the introductory course. So let's get started with Oracle 11g Database Intermediate.

Course: Intermediate Oracle 11g
Author: Gavin Powell
SKU: 34361
ISBN: 978-1-61866-069-5
Work Files: Yes
Captions: No
Subject: Programming
The first 3 chapters of courses are available to play for FREE (first chapter only for QuickStart! and MasterClass! courses). Just click on the movie link to play a lesson.

Download WorkFiles

Oracle Solaris 11 System Administration - Exam 1Z0-821
Author : Bobby Rogers

8 / 92 2012-12-24
QuickStart! - Oracle 11g: RAC Installation and Configuration
Author : Gavin Powell

3 / 28 2012-11-21
Introduction to Oracle 11g
Author : Gavin Powell

11.5 / 139 2012-04-28

Pricing & availability

Lifetime online access to this course

US$ 39.00

Download for offline access

US$ 79.95

Subscribe to 1000+ courses

Starting at $30/month

Course outline

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)

Credits

About the Author (01:19)