VTC Legacy
Home / Certification

Oracle: Introduction to Oracle SQL and PL/SQL

by Gavin Powell
165 lessons16 chapters12.1 hReleased 20036 free
Start the free chapter

Virtual Training Company\'s Introduction to Oracle SQL and PL/SQL tutorial will cover the relational Database Model, the Oracle Architecture and the Physical database. The tutorial is aimed at programmers, and individuals who have had prior SQL and relational database experience. Gavin Powell, your instructor, will begin teaching you many Oracle tools such as the SQL Plus, SQL Plus Worksheet, and Oracle Enterprise Manager. This tutorial will explain how to maintain the Logical Database, and the difference between the Logical Database and the Physical database. You will be guided, in great detail, in the following areas: retrieving, changing, adding, and deleting data from the Database. From there, you will learn about Logical Database objects, Security, Select Statements, and much more. Introduction to Oracle SQL and PL/SQL will cover areas for the Oracle Certification course (1Z0-007). To get started, click one of the movie topics below.

Course content

Welcome6 lessons
The Relational Database Model6 lessons
Oracle SQL and PL/SQL Tools7 lessons
The Architecture of Oracle3 lessons
Creating Database Objects20 lessons
Users and Security15 lessons
Retrieving Data from the Database13 lessons
Oracle Built In Functions13 lessons
Filtering SELECT Statements7 lessons
Sorting SELECT Statements4 lessons
Joining Multiple Tables14 lessons
Summarizing with GROUP BY12 lessons
Subqueries and Other Advanced Queries10 lessons
Oracle Data Manipulation Language (DML)13 lessons
PL/SQL (Programming Language SQL)21 lessons
Credits1 lessons