Oracle: Introduction to Oracle SQL and PL/SQL
Author:Dave Mercer
Language:english
Category:Business Applications,Databases,
Lessons:0 | 0 hrs
Buy Now or get more information about 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.
First 3 Lessons Free Online (Press the links below to open up the free lessons. The lessons will open in a popup window from this screen and play in Quicktime):

Oracle: Introduction to Oracle SQL and PL/SQL

Welcome

Welcome
Useful Web Sites
What is Oracle Software?
The History of Databases
The History of Oracle
About this Course

The Relational Database Model

The Relational Database Model
The Concerts Schema
Normalization pt. 1
Normalization pt. 2
Denormalization pt. 1
Denormalization pt. 2

Oracle SQL and PL/SQL Tools

What are the Oracle SQL and PL/SQL Tools?
SQL Plus
Formatting Output
SQL Plus Worksheet
iSQL Plus
Oracle Enterprise Manager pt. 1
Oracle Enterprise Manager pt. 2

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

01 Welcome
0101 Welcome
0102 Useful Web Sites
0103 What is Oracle Software?
0104 The History of Databases
0105 The History of Oracle
0106 About this Course

02 The Relational Database Model
0201 The Relational Database Model
0202 The Concerts Schema
0203 Normalization pt. 1
0204 Normalization pt. 2
0205 Denormalization pt. 1
0206 Denormalization pt. 2

03 Oracle SQL and PL/SQL Tools
0301 What are the Oracle SQL and PL/SQL Tools?
0302 SQL Plus
0303 Formatting Output
0304 SQL Plus Worksheet
0305 iSQL Plus
0306 Oracle Enterprise Manager pt. 1
0307 Oracle Enterprise Manager pt. 2

04 The Architecture of Oracle
0401 The Oracle Database and Oracle Instance pt. 1
0402 The Oracle Database and Oracle Instance pt. 2
0403 Control Files, Logging, Archiving and Recoverability

05 Creating Database Objects
0501 Oracle Simple Datatypes pt. 1
0502 Oracle Simple Datatypes pt. 2
0503 Oracle Complex and Object Datatypes
0504 Types of Tables
0505 Methods of Table Creation
0506 Create Table Syntax
0507 Example Table Creations pt. 1
0508 Example Table Creations pt. 2
0509 Altering and Dropping Tables pt. 1
0510 Altering and Dropping Tables pt. 2
0511 What are Constraints?
0512 Creating, Changing and Dropping Constraints
0513 Types of Indexes pt. 1
0514 Types of Indexes pt. 2
0515 Creating, Altering and Dropping Indexes
0516 Sequence Counters
0517 Synonyms
0518 Views pt. 1
0519 Views pt. 2
0520 Metadata Views and Error Messages

06 Users and Security
0601 Schemas, Users, Privileges and Roles pt. 1
0602 Schemas, Users, Privileges and Roles pt. 2
0603 Schemas, Users, Privileges and Roles pt. 3
0604 Types of Users
0605 Creating Users pt. 1
0606 Creating Users pt. 2
0607 Altering and Dropping Users
0608 Security
0609 System Privileges
0610 Object Privileges
0611 Granting and Revoking Privileges pt. 1
0612 Granting and Revoking Privileges pt. 2
0613 Grouping Privileges Using Roles pt. 1
0614 Grouping Privileges Using Roles pt. 2
0615 Setting Roles

07 Retrieving Data from the Database
0701 The SELECT Statement pt. 1
0702 The SELECT Statement pt. 2
0703 The SELECT Statement pt. 3
0704 Types of SELECT Statement pt. 1
0705 Types of SELECT Statement pt. 2
0706 The DUAL Table pt. 1
0707 The DUAL Table pt. 2
0708 What is a NULL?
0709 Pseudo-Columns pt. 1
0710 Pseudo-Columns pt. 2
0711 More About SQL Plus Formatting pt. 1
0712 More About SQL Plus Formatting pt. 2
0713 More About SQL Plus Formatting pt. 3

08 Oracle Built In Functions
0801 Types of Functions pt. 1
0802 Types of Functions pt. 2
0803 String Functions pt. 1
0804 String Functions pt. 2
0805 String Functions pt. 3
0806 Number Functions
0807 Date Functions pt. 1
0808 Date Functions pt. 2
0809 Other Functions pt. 1
0810 Other Functions pt. 2
0811 Datatype Conversion Functions pt. 1
0812 Datatype Conversion Functions pt. 2
0813 Custom Functions Using PL/SQL

09 Filtering SELECT Statements
0901 The WHERE Clause
0902 Conditional Comparisons
0903 Using the WHERE Clause
0904 Using Logical Operators pt. 1
0905 Using Logical Operators pt. 2
0906 Using Conditional Comparisons pt. 1
0907 Using Conditional Comparisons pt. 2

10 Sorting SELECT Statements
1001 The ORDER BY Clause
1002 Sorting Methods pt. 1
1003 Sorting Methods pt. 2
1004 Sorting Methods pt. 3

11 Joining Multiple Tables
1101 What is a Join?
1102 Two Join Syntax Formats
1103 Types of Joins pt. 1
1104 Types of Joins pt. 2
1105 Types of Joins pt. 3
1106 Cross Join or Cartesian Product
1107 Natural or Inner Join pt. 1
1108 Change the Concerts Schema pt. 1
1109 Change the Concerts Schema pt. 2
1110 Outer Join pt. 1
1111 Outer Join pt. 2
1112 Self Join
1113 Equi-Joins, Anti-Joins and Range-Joins
1114 Mutable and Complex Joins

12 Summarizing with GROUP BY
1201 What does GROUP BY Do?
1202 The GROUP BY Clause
1203 Types of Grouping Functions pt. 1
1204 Types of Grouping Functions pt. 2
1205 Special Behavior pt. 1
1206 Special Behavior pt. 2
1207 Summary Functions
1208 Statistical Functions
1209 Other Functions
1210 Filtering GROUP BY with the HAVING Clause
1211 Extending the GROUP BY Clause pt. 1
1212 Extending the GROUP BY Clause pt. 2

13 Subqueries and Other Advanced Queries
1301 What is a Subquery?
1302 Types of Subqueries
1303 Comparison Conditions Revisited pt. 1
1304 Comparison Conditions Revisited pt. 2
1305 Comparison Conditions Revisited pt. 3
1306 Regular vs. Correlated Subqueries
1307 Nested Subqueries and Replacing Joins
1308 Where Can Subqueries be Used?
1309 Hierarchical Queries
1310 Set Operators and Composite Queries

14 Oracle Data Manipulation Language (DML)
1401 What is DML?
1402 Adding Data with INSERT
1403 Multiple Table INSERT pt. 1
1404 Multiple Table INSERT pt. 2
1405 Changing Data with UPDATE pt. 1
1406 Changing Data with UPDATE pt. 2
1407 Remove Data with DELETE or TRUNCATE pt. 1
1408 Remove Data with DELETE or TRUNCATE pt. 2
1409 Merging Tables with MERGE pt. 1
1410 Merging Tables with MERGE pt. 2
1411 Transactional Control
1412 Locking and Visibility of Data Changes
1413 COMMIT vs ROLLBACK

15 PL/SQL (Programming Language SQL)
1501 What is PL/SQL?
1502 Anonymous Procedures
1503 Modular Structure
1504 Named Procedures
1505 Functions
1506 Packages
1507 Triggers pt. 1
1508 Triggers pt. 2
1509 Variables and Types in PL/SQL pt. 1
1510 Variables and Types in PL/SQL pt. 2
1511 Objects and Object Datatypes
1512 More About Objects pt. 1
1513 More About Objects pt. 2
1514 Programming Control Structures
1515 Simple Database Access in PL/SQL
1516 Cursors and Implicit Cursors pt. 1
1517 Cursors and Implicit Cursors pt. 2
1518 Explicit Cursors pt. 1
1519 Explicit Cursors pt. 2
1520 Dynamic SQL
1521 Provided (DBMS_) Packages

Sponsors