We will be undergoing scheduled maintenance on May 20th, 2013 at 02:00 GMT.
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.
What are the Oracle SQL and PL/SQL Tools?
Oracle Enterprise Manager pt. 1
Oracle Enterprise Manager pt. 2
Oracle Complex and Object Datatypes
Altering and Dropping Tables pt. 1
Altering and Dropping Tables pt. 2
Creating, Changing and Dropping Constraints
Creating, Altering and Dropping Indexes
Metadata Views and Error Messages
Schemas, Users, Privileges and Roles pt. 1
Schemas, Users, Privileges and Roles pt. 2
Schemas, Users, Privileges and Roles pt. 3
Granting and Revoking Privileges pt. 1
Granting and Revoking Privileges pt. 2
Grouping Privileges Using Roles pt. 1
Grouping Privileges Using Roles pt. 2
Types of SELECT Statement pt. 1
Types of SELECT Statement pt. 2
More About SQL Plus Formatting pt. 1
More About SQL Plus Formatting pt. 2
More About SQL Plus Formatting pt. 3
Using Conditional Comparisons pt. 1
Using Conditional Comparisons pt. 2
Cross Join or Cartesian Product
Change the Concerts Schema pt. 1
Change the Concerts Schema pt. 2
Equi-Joins, Anti-Joins and Range-Joins
Types of Grouping Functions pt. 1
Types of Grouping Functions pt. 2
Filtering GROUP BY with the HAVING Clause
Extending the GROUP BY Clause pt. 1
Extending the GROUP BY Clause pt. 2
Comparison Conditions Revisited pt. 1
Comparison Conditions Revisited pt. 2
Comparison Conditions Revisited pt. 3
Regular vs. Correlated Subqueries
Nested Subqueries and Replacing Joins
Set Operators and Composite Queries
Changing Data with UPDATE pt. 1
Changing Data with UPDATE pt. 2
Remove Data with DELETE or TRUNCATE pt. 1
Remove Data with DELETE or TRUNCATE pt. 2
Merging Tables with MERGE pt. 1
Merging Tables with MERGE pt. 2
Locking and Visibility of Data Changes
Variables and Types in PL/SQL pt. 1
Variables and Types in PL/SQL pt. 2
Programming Control Structures
Simple Database Access in PL/SQL
Cursors and Implicit Cursors pt. 1
Cursors and Implicit Cursors pt. 2
Every course on the vtc.com website contains free movies that let you assess the quality of our tutorials before you subscribe - just click on the blue links to watch them. Become a member today to access over 100,000 instructional videos!
Sign Up NowIf you are already an active vtc.com member, please log in to access the tutorials.