Oracle Introduction to Oracle SQL and PL SQL Tutorials

Course Title: Oracle Introduction to Oracle SQL and PL SQL

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 Author/Expert: Gavin Powell

Language: english

Full Online Training Available: Yes

Number of Course Movies: 165

Course Duration: 12 hours

Never has it been so easy to learn Oracle Introduction to Oracle SQL and PL SQL.
No expensive classroom training courses.
No boring hard to follow books to read.
Learn from your own desk at a pace that suits you.
High quality affordable training that is easy to use and follow.
Use unique training methods, it makes learning easy no matter what your learning style.

Course Outline:

The FIRST THREE chapters of this online training course can be viewed right now!

Click Here Now To View the First Three Chapters of Oracle Introduction to Oracle SQL and PL SQL Online Training For Free

If you then need all the lessons or complete access to over seven hundred different courses then join the online university for as long as you need them and even get an online university certificate.

The Architecture of Oracle

The Oracle Database and Oracle Instance pt. 1

The Oracle Database and Oracle Instance pt. 2

Control Files, Logging, Archiving and Recoverability

Creating Database Objects

Oracle Simple Datatypes pt. 1

Oracle Simple Datatypes pt. 2

Oracle Complex and Object Datatypes

Types of Tables

Methods of Table Creation

Create Table Syntax

Example Table Creations pt. 1

Example Table Creations pt. 2

Altering and Dropping Tables pt. 1

Altering and Dropping Tables pt. 2

What are Constraints?

Creating, Changing and Dropping Constraints

Types of Indexes pt. 1

Types of Indexes pt. 2

Creating, Altering and Dropping Indexes

Sequence Counters

Synonyms

Views pt. 1

Views pt. 2

Metadata Views and Error Messages

Users and Security

Schemas, Users, Privileges and Roles pt. 1

Schemas, Users, Privileges and Roles pt. 2

Schemas, Users, Privileges and Roles pt. 3

Types of Users

Creating Users pt. 1

Creating Users pt. 2

Altering and Dropping Users

Security

System Privileges

Object Privileges

Granting and Revoking Privileges pt. 1

Granting and Revoking Privileges pt. 2

Grouping Privileges Using Roles pt. 1

Grouping Privileges Using Roles pt. 2

Setting Roles

Retrieving Data from the Database

The SELECT Statement pt. 1

The SELECT Statement pt. 2

The SELECT Statement pt. 3

Types of SELECT Statement pt. 1

Types of SELECT Statement pt. 2

The DUAL Table pt. 1

The DUAL Table pt. 2

What is a NULL?

Pseudo-Columns pt. 1

Pseudo-Columns pt. 2

More About SQL Plus Formatting pt. 1

More About SQL Plus Formatting pt. 2

More About SQL Plus Formatting pt. 3

Oracle Built In Functions

Types of Functions pt. 1

Types of Functions pt. 2

String Functions pt. 1

String Functions pt. 2

String Functions pt. 3

Number Functions

Date Functions pt. 1

Date Functions pt. 2

Other Functions pt. 1

Other Functions pt. 2

Datatype Conversion Functions pt. 1

Datatype Conversion Functions pt. 2

Custom Functions Using PL/SQL

Filtering SELECT Statements

The WHERE Clause

Conditional Comparisons

Using the WHERE Clause

Using Logical Operators pt. 1

Using Logical Operators pt. 2

Using Conditional Comparisons pt. 1

Using Conditional Comparisons pt. 2

Sorting SELECT Statements

The ORDER BY Clause

Sorting Methods pt. 1

Sorting Methods pt. 2

Sorting Methods pt. 3

Joining Multiple Tables

What is a Join?

Two Join Syntax Formats

Types of Joins pt. 1

Types of Joins pt. 2

Types of Joins pt. 3

Cross Join or Cartesian Product

Natural or Inner Join pt. 1

Change the Concerts Schema pt. 1

Change the Concerts Schema pt. 2

Outer Join pt. 1

Outer Join pt. 2

Self Join

Equi-Joins, Anti-Joins and Range-Joins

Mutable and Complex Joins

Summarizing with GROUP BY

What does GROUP BY Do?

The GROUP BY Clause

Types of Grouping Functions pt. 1

Types of Grouping Functions pt. 2

Special Behavior pt. 1

Special Behavior pt. 2

Summary Functions

Statistical Functions

Other Functions

Filtering GROUP BY with the HAVING Clause

Extending the GROUP BY Clause pt. 1

Extending the GROUP BY Clause pt. 2

Subqueries and Other Advanced Queries

What is a Subquery?

Types of Subqueries

Comparison Conditions Revisited pt. 1

Comparison Conditions Revisited pt. 2

Comparison Conditions Revisited pt. 3

Regular vs. Correlated Subqueries

Nested Subqueries and Replacing Joins

Where Can Subqueries be Used?

Hierarchical Queries

Set Operators and Composite Queries

Oracle Data Manipulation Language (DML)

What is DML?

Adding Data with INSERT

Multiple Table INSERT pt. 1

Multiple Table INSERT pt. 2

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

Transactional Control

Locking and Visibility of Data Changes

COMMIT vs ROLLBACK

PL/SQL (Programming Language SQL)

What is PL/SQL?

Anonymous Procedures

Modular Structure

Named Procedures

Functions

Packages

Triggers pt. 1

Triggers pt. 2

Variables and Types in PL/SQL pt. 1

Variables and Types in PL/SQL pt. 2

Objects and Object Datatypes

More About Objects pt. 1

More About Objects pt. 2

Programming Control Structures

Simple Database Access in PL/SQL

Cursors and Implicit Cursors pt. 1

Cursors and Implicit Cursors pt. 2

Explicit Cursors pt. 1

Explicit Cursors pt. 2

Dynamic SQL

Provided (DBMS_) Packages

To continue your learning, Click Here for the Online University and get access to all of the training courses, that's over 550 software programmes including 60,000 tutorial videos, for editing, image manipulation and graphics programmes. All for just $30 (approx £16) month. Unlimited access for as long as you need, cancel when you're finished, no contract, no minimum period, no hassle.

or

Click Here and we'll send you the training CD itself for Oracle Introduction to Oracle SQL and PL SQL at £79.95