VTC Legacy
Home / Programming

Intermediate Oracle 11g

by Gavin Powell
123 lessons12 chapters10.1 hReleased 20123 free
Start the free chapter

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.

Course content

Introduction3 lessons
Subqueries9 lessons
Specialized Queries11 lessons
Expressions and Regular Expressions10 lessons
Changing Tables10 lessons
Changing Data13 lessons
Users and Security21 lessons
Specialized Database Objects10 lessons
Working with Indexes12 lessons
PL/SQL22 lessons
Conclusion1 lessons
Credits1 lessons