Intermediate Oracle 11g Course

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.

Table of content

Introduction

• Welcome to Intermediate Oracle
• Prerequisites for This Course
• About This Course

Subqueries

• What is a Subquery?
• Subquery Syntax
• Types of Subqueries
• Where Can Subqueries Be Used?
• Comparison Conditions pt. 1
• Comparison Conditions pt. 2
• Regular vs. Correlated Subqueries
• Using the WITH Clause
• Nested Semi Joins

Specialized Queries

• Composite Query Syntax
• Using Composite Queries pt. 1
• Using Composite Queries pt. 2
• Hierarchical Queries
• Hierarchical Query Syntax
• Hierarchical Family Trees pt. 1
• Hierarchical Family Trees pt. 2
• Flashback Query Syntax
• Flashback Query Pseudocolumns
• Using Flashback Queries pt. 1
• Using Flashback Queries pt. 2

Expressions and Regular Expressions

• What an Expression Is
• Types of Expressions
• Expression Types Demo pt. 1
• Expression Types Demo pt. 2
• Expression Types Demo pt. 3
• Meta Characters
• Regular Expression Functions
• Using Regular Expression Patterns
• Check Constraint Regular Expressions
• Oracle Expression Filter

Changing Tables

• The ALTER TABLE Command
• Table Properties pt. 1
• Table Properties pt. 2
• Columns pt. 1
• Columns pt. 2
• Columns pt. 3
• Columns pt. 4
• Constraints Options
• Constraint States
• Renaming and Dropping Constraints

Changing Data

• What the DML Commands Are
• INSERT Statement Syntax
• Using INSERT pt. 1
• Using INSERT pt. 2
• Using INSERT pt. 3
• UPDATE Statement Syntax
• Using UPDATE
• DELETE and TRUNCATE Syntax
• Using DELETE and TRUNCATE
• MERGE Statement Syntax
• Using MERGE
• Transactional Control
• Demonstrating Transaction Control

Users and Security

• Oracle Security pt. 1
• Oracle Security pt. 2
• Types of Users
• Create User Syntax pt. 1
• Create User Syntax pt. 2
• Using CREATE USER pt. 1
• Using CREATE USER pt. 2
• Alter and Drop User Syntax
• Using ALTER and DROP USER
• Oracle Power Users
• Resources and Profiles
• Privileges pt. 1
• Privileges pt. 2
• Granting and Revoking Privileges
• Using GRANT pt. 1
• Using GRANT pt. 2
• Using REVOKE
• Group Privileges Using Roles
• Setting Roles
• Metadata Views pt. 1
• Metadata Views pt. 2

Specialized Database Objects

• Sequence Syntax
• What and Where and How of Sequences
• Using Sequences
• Synonym Syntax
• Using Synonyms
• Database Links
•  Views and Materialized Views
• Using Views
• Metadata Views pt. 1
• Metadata Views pt. 2

Working with Indexes

• Types of Indexes
• Index Attributes
• BTree Indexes
• Function-Based Indexes
• Bitmap Indexes
• Exotic Indexing
• Creating Indexes pt. 1
• Creating Indexes pt. 2
• Changing and Dropping Indexes
• Working with Indexes pt. 1
• Working with Indexes pt. 2
• Metadata Views

PL/SQL

• What PL/SQL Is pt. 1
• What PL/SQL Is pt. 2
• Why PL/SQL Is Programming
• Blocks & Exception Traps pt. 1
• Blocks & Exception Traps pt. 2
• Named Procedures pt. 1
• Named Procedures pt. 2
• Functions
• Triggers pt. 1
• Triggers pt. 2
• Triggers pt. 3
• Packages
• Variables and Datatypes pt. 1
• Variables and Datatypes pt. 2
• Programming Control Structures
• Simple PL/SQL Database Access
• Explicit Cursors
• Implicit Cursors pt. 1
• Implicit Cursors pt. 2
• Dynamic SQL pt. 1
• Dynamic SQL pt. 2
• Wrapping Up PL/SQL

Conclusion

• Course Wrap Up

Credits

• About the Author

Uploaded.net

1. http://ul.to/a6lr92ho
2. http://ul.to/8o7zelqy
3. http://ul.to/vxujy1er

Depfile.com

1. http://bit.ly/1gD0F0J
2. http://bit.ly/1bMNqx2
3. Uploading.....

Cloudzer.net

1. http://clz.to/agvfv9q5
2. http://clz.to/8p5hs7kx
3. http://clz.to/50u5f3ng