O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Intermediate Oracle 11g

Video Description

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.

Table of Contents

  1. Introduction
    1. Welcome to Intermediate 00:01:13
    2. Prerequisites for This Course 00:02:34
    3. About This Course 00:02:55
  2. Subqueries
    1. What is a Subquery? 00:04:29
    2. Subquery Syntax 00:05:21
    3. Types of Subqueries 00:06:22
    4. Where Can Subqueries Be Used? 00:05:40
    5. Comparison Conditions pt. 1 00:03:54
    6. Comparison Conditions pt. 2 00:05:40
    7. Regular vs. Correlated Subqueries 00:05:19
    8. Using the WITH Clause 00:05:45
    9. Nested Semi Joins 00:06:45
  3. Specialized Queries
    1. Composite Query Syntax 00:04:18
    2. Using Composite Queries pt. 1 00:06:02
    3. Using Composite Queries pt. 2 00:02:26
    4. Hierarchical Queries 00:03:41
    5. Hierarchical Query Syntax 00:03:48
    6. Hierarchical Family Trees pt. 1 00:06:09
    7. Hierarchical Family Trees pt. 2 00:06:21
    8. Flashback Query Syntax 00:02:54
    9. Flashback Query Pseudocolumns 00:02:02
    10. Using Flashback Queries pt. 1 00:04:47
    11. Using Flashback Queries pt. 2 00:03:01
  4. Expressions and Regular Expressions
    1. What an Expression Is 00:06:07
    2. Types of Expressions 00:01:42
    3. Expression Types Demo pt. 1 00:05:45
    4. Expression Types Demo pt. 2 00:04:37
    5. Expression Types Demo pt. 3 00:06:46
    6. Meta Characters 00:06:30
    7. Regular Expression Functions 00:05:01
    8. Using Regular Expression Patterns 00:06:41
    9. Check Constraint Regular Expressions 00:03:00
    10. Oracle Expression Filter 00:02:47
  5. Changing Tables
    1. The ALTER TABLE Command 00:02:30
    2. Table Properties pt. 1 00:06:52
    3. Table Properties pt. 2 00:06:22
    4. Columns pt. 1 00:04:00
    5. Columns pt. 2 00:05:31
    6. Columns pt. 3 00:05:07
    7. Columns pt. 4 00:03:56
    8. Constraints Options 00:02:39
    9. Constraint States 00:06:44
    10. Renaming and Dropping Constraints 00:04:48
  6. Changing Data
    1. What the DML Commands Are 00:03:04
    2. INSERT Statement Syntax 00:05:37
    3. Using INSERT pt. 1 00:03:38
    4. Using INSERT pt. 2 00:04:46
    5. Using INSERT pt. 3 00:05:58
    6. UPDATE Statement Syntax 00:02:01
    7. Using UPDATE 00:04:56
    8. DELETE and TRUNCATE Syntax 00:06:05
    9. Using DELETE and TRUNCATE 00:06:29
    10. MERGE Statement Syntax 00:03:46
    11. Using MERGE 00:05:59
    12. Transactional Control 00:06:26
    13. Demonstrating Transaction Control 00:05:29
  7. Users and Security
    1. Oracle Security pt. 1 00:06:02
    2. Oracle Security pt. 2 00:05:06
    3. Types of Users 00:06:10
    4. Create User Syntax pt. 1 00:05:46
    5. Create User Syntax pt. 2 00:04:13
    6. Using CREATE USER pt. 1 00:04:16
    7. Using CREATE USER pt. 2 00:03:50
    8. Alter and Drop User Syntax 00:04:26
    9. Using ALTER and DROP USER 00:05:56
    10. Oracle Power Users 00:06:59
    11. Resources and Profiles 00:01:41
    12. Privileges pt. 1 00:06:02
    13. Privileges pt. 2 00:05:41
    14. Granting and Revoking Privileges 00:05:57
    15. Using GRANT pt. 1 00:04:00
    16. Using GRANT pt. 2 00:03:07
    17. Using REVOKE 00:05:16
    18. Group Privileges Using Roles 00:03:08
    19. Setting Roles 00:01:41
    20. Metadata Views pt. 1 00:04:49
    21. Metadata Views pt. 2 00:03:26
  8. Specialized Database Objects
    1. Sequence Syntax 00:05:08
    2. What and Where and How of Sequences 00:03:30
    3. Using Sequences 00:06:25
    4. Synonym Syntax 00:04:31
    5. Using Synonyms 00:06:16
    6. Database Links 00:05:39
    7. Views and Materialized Views 00:06:46
    8. Using Views 00:04:23
    9. Metadata Views pt. 1 00:05:00
    10. Metadata Views pt. 2 00:06:02
  9. Working with Indexes
    1. Types of Indexes 00:04:24
    2. Index Attributes 00:06:09
    3. BTree Indexes 00:05:51
    4. Function-Based Indexes 00:04:49
    5. Bitmap Indexes 00:05:45
    6. Exotic Indexing 00:04:37
    7. Creating Indexes pt. 1 00:05:55
    8. Creating Indexes pt. 2 00:03:08
    9. Changing and Dropping Indexes 00:06:53
    10. Working with Indexes pt. 1 00:06:49
    11. Working with Indexes pt. 2 00:06:05
    12. Metadata Views 00:06:20
  10. PL/SQL
    1. What PL/SQL Is pt. 1 00:03:47
    2. What PL/SQL Is pt. 2 00:06:02
    3. Why PL/SQL Is Programming 00:06:36
    4. Blocks & Exception Traps pt. 1 00:05:22
    5. Blocks & Exception Traps pt. 2 00:04:06
    6. Named Procedures pt. 1 00:03:52
    7. Named Procedures pt. 2 00:07:09
    8. Functions 00:06:02
    9. Triggers pt. 1 00:04:48
    10. Triggers pt. 2 00:05:25
    11. Triggers pt. 3 00:04:51
    12. Packages 00:06:08
    13. Variables and Datatypes pt. 1 00:06:26
    14. Variables and Datatypes pt. 2 00:02:47
    15. Programming Control Structures 00:04:56
    16. Simple PL/SQL Database Access 00:05:41
    17. Explicit Cursors 00:06:26
    18. Implicit Cursors pt. 1 00:05:18
    19. Implicit Cursors pt. 2 00:06:53
    20. Dynamic SQL pt. 1 00:06:35
    21. Dynamic SQL pt. 2 00:05:18
    22. Wrapping Up PL/SQL 00:04:11
  11. Conclusion
    1. Course Wrap Up 00:04:51
  12. Credits
    1. About the Author 00:01:19