
Intermediate Oracle 11g
by Gavin Powell
Start the free chapterThis 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.
Course content
Introduction3 lessons
Subqueries9 lessons
- What is a Subquery?4:291 credit or ad
- Subquery Syntax5:211 credit or ad
- Types of Subqueries6:221 credit or ad
- Where Can Subqueries Be Used?5:401 credit or ad
- Comparison Conditions pt. 13:541 credit or ad
- Comparison Conditions pt. 25:401 credit or ad
- Regular vs. Correlated Subqueries5:191 credit or ad
- Using the WITH Clause5:451 credit or ad
- Nested Semi Joins6:451 credit or ad
Specialized Queries11 lessons
- Composite Query Syntax4:181 credit or ad
- Using Composite Queries pt. 16:021 credit or ad
- Using Composite Queries pt. 22:261 credit or ad
- Hierarchical Queries3:411 credit or ad
- Hierarchical Query Syntax3:481 credit or ad
- Hierarchical Family Trees pt. 16:091 credit or ad
- Hierarchical Family Trees pt. 26:211 credit or ad
- Flashback Query Syntax2:541 credit or ad
- Flashback Query Pseudocolumns2:021 credit or ad
- Using Flashback Queries pt. 14:471 credit or ad
- Using Flashback Queries pt. 23:011 credit or ad
Expressions and Regular Expressions10 lessons
- What an Expression Is6:071 credit or ad
- Types of Expressions1:421 credit or ad
- Expression Types Demo pt. 15:451 credit or ad
- Expression Types Demo pt. 24:371 credit or ad
- Expression Types Demo pt. 36:461 credit or ad
- Meta Characters6:301 credit or ad
- Regular Expression Functions5:011 credit or ad
- Using Regular Expression Patterns6:411 credit or ad
- Check Constraint Regular Expressions3:001 credit or ad
- Oracle Expression Filter2:471 credit or ad
Changing Tables10 lessons
- The ALTER TABLE Command2:301 credit or ad
- Table Properties pt. 16:521 credit or ad
- Table Properties pt. 26:221 credit or ad
- Columns pt. 14:001 credit or ad
- Columns pt. 25:311 credit or ad
- Columns pt. 35:071 credit or ad
- Columns pt. 43:561 credit or ad
- Constraints Options2:391 credit or ad
- Constraint States6:441 credit or ad
- Renaming and Dropping Constraints4:481 credit or ad
Changing Data13 lessons
- What the DML Commands Are3:041 credit or ad
- INSERT Statement Syntax5:371 credit or ad
- Using INSERT pt. 13:381 credit or ad
- Using INSERT pt. 24:461 credit or ad
- Using INSERT pt. 35:581 credit or ad
- UPDATE Statement Syntax2:011 credit or ad
- Using UPDATE4:561 credit or ad
- DELETE and TRUNCATE Syntax6:051 credit or ad
- Using DELETE and TRUNCATE6:291 credit or ad
- MERGE Statement Syntax3:461 credit or ad
- Using MERGE5:591 credit or ad
- Transactional Control6:261 credit or ad
- Demonstrating Transaction Control5:291 credit or ad
Users and Security21 lessons
- Oracle Security pt. 16:021 credit or ad
- Oracle Security pt. 25:061 credit or ad
- Types of Users6:101 credit or ad
- Create User Syntax pt. 15:461 credit or ad
- Create User Syntax pt. 24:131 credit or ad
- Using CREATE USER pt. 14:161 credit or ad
- Using CREATE USER pt. 23:501 credit or ad
- Alter and Drop User Syntax4:261 credit or ad
- Using ALTER and DROP USER5:561 credit or ad
- Oracle Power Users6:591 credit or ad
- Resources and Profiles1:411 credit or ad
- Privileges pt. 16:021 credit or ad
- Privileges pt. 25:411 credit or ad
- Granting and Revoking Privileges5:571 credit or ad
- Using GRANT pt. 14:001 credit or ad
- Using GRANT pt. 23:071 credit or ad
- Using REVOKE5:161 credit or ad
- Group Privileges Using Roles3:081 credit or ad
- Setting Roles1:411 credit or ad
- Metadata Views pt. 14:491 credit or ad
- Metadata Views pt. 23:261 credit or ad
Specialized Database Objects10 lessons
- Sequence Syntax5:081 credit or ad
- What and Where and How of Sequences3:301 credit or ad
- Using Sequences6:251 credit or ad
- Synonym Syntax4:311 credit or ad
- Using Synonyms6:161 credit or ad
- Database Links5:391 credit or ad
- Views and Materialized Views6:461 credit or ad
- Using Views4:231 credit or ad
- Metadata Views pt. 15:001 credit or ad
- Metadata Views pt. 26:021 credit or ad
Working with Indexes12 lessons
- Types of Indexes4:241 credit or ad
- Index Attributes6:091 credit or ad
- BTree Indexes5:511 credit or ad
- Function-Based Indexes4:491 credit or ad
- Bitmap Indexes5:451 credit or ad
- Exotic Indexing4:371 credit or ad
- Creating Indexes pt. 15:551 credit or ad
- Creating Indexes pt. 23:081 credit or ad
- Changing and Dropping Indexes6:531 credit or ad
- Working with Indexes pt. 16:491 credit or ad
- Working with Indexes pt. 26:051 credit or ad
- Metadata Views6:201 credit or ad
PL/SQL22 lessons
- What PL/SQL Is pt. 13:471 credit or ad
- What PL/SQL Is pt. 26:021 credit or ad
- Why PL/SQL Is Programming6:361 credit or ad
- Blocks & Exception Traps pt. 15:221 credit or ad
- Blocks & Exception Traps pt. 24:061 credit or ad
- Named Procedures pt. 13:521 credit or ad
- Named Procedures pt. 27:091 credit or ad
- Functions6:021 credit or ad
- Triggers pt. 14:481 credit or ad
- Triggers pt. 25:251 credit or ad
- Triggers pt. 34:511 credit or ad
- Packages6:081 credit or ad
- Variables and Datatypes pt. 16:261 credit or ad
- Variables and Datatypes pt. 22:471 credit or ad
- Programming Control Structures4:561 credit or ad
- Simple PL/SQL Database Access5:411 credit or ad
- Explicit Cursors6:261 credit or ad
- Implicit Cursors pt. 15:181 credit or ad
- Implicit Cursors pt. 26:531 credit or ad
- Dynamic SQL pt. 16:351 credit or ad
- Dynamic SQL pt. 25:181 credit or ad
- Wrapping Up PL/SQL4:111 credit or ad