Oracle: Introduction to Oracle SQL and PL/SQL Training Course
Improve job skills - Become more efficient - Produce better results !
Learn Oracle: Introduction to Oracle SQL and PL/SQL (in only 12 hours)
Watch these professional training videos at your convenience. All you need is a computer or mobile device with an Internet connection. Login to learn anytime and view the videos as many times as you want.
Course Description: 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 video tutorials below.
Click a play button below to view a free training video. Place your order online for full access.
Video Tutorials Included: 162
The Relational Database Model
Oracle SQL and PL/SQL Tools
The Architecture of Oracle
Creating Database Objects
Users and Security
Retrieving Data from the Database
Oracle Built In Functions
Filtering SELECT Statements
Sorting SELECT Statements
Joining Multiple Tables
Summarizing with GROUP BY
Subqueries and Other Advanced Queries
Oracle Data Manipulation Language (DML)
PL/SQL (Programming Language SQL)