Oracle: Intro to Oracle SQL and Oracle PL/SQL Tutorial

We hope you enjoyed the FREE lessons above. To view the complete contents, including the chapters below, please purchase the CD.
CLICK HERE TO BUY THIS CD

The Architecture of Oracle
The Oracle Database and Oracle Instance - Lesson 1
The Oracle Database and Oracle Instance - Lesson 2
Control Files, Logging, Archiving and Recoverability

Creating Database Objects
Oracle Simple Datatypes - Lesson 1
Oracle Simple Datatypes - Lesson 2
Oracle Complex and Object Datatypes
Types of Tables
Methods of Table Creation
Create Table Syntax
Example Table Creations - Lesson 1
Example Table Creations - Lesson 2
Altering and Dropping Tables - Lesson 1
Altering and Dropping Tables - Lesson 2
What are Constraints?
Creating, Changing and Dropping Constraints
Types of Indexes - Lesson 1
Types of Indexes - Lesson 2
Creating, Altering and Dropping Indexes
Sequence Counters
Synonyms
Views - Lesson 1
Views - Lesson 2
Metadata Views and Error Messages

Users and Security
Schemas, Users, Privileges and Roles - Lesson 1
Schemas, Users, Privileges and Roles - Lesson 2
Schemas, Users, Privileges and Roles - Lesson 3
Types of Users
Creating Users - Lesson 1
Creating Users - Lesson 2
Altering and Dropping Users
Security
System Privileges
Object Privileges
Granting and Revoking Privileges - Lesson 1
Granting and Revoking Privileges - Lesson 2
Grouping Privileges Using Roles - Lesson 1
Grouping Privileges Using Roles - Lesson 2
Setting Roles

Retrieving Data from the Database
The SELECT Statement - Lesson 1
The SELECT Statement - Lesson 2
The SELECT Statement - Lesson 3
Types of SELECT Statement - Lesson 1
Types of SELECT Statement - Lesson 2
The DUAL Table - Lesson 1
The DUAL Table - Lesson 2
What is a NULL?
Pseudo-Columns - Lesson 1
Pseudo-Columns - Lesson 2
More About SQL Plus Formatting - Lesson 1
More About SQL Plus Formatting - Lesson 2
More About SQL Plus Formatting - Lesson 3

Oracle Built In Functions
Types of Functions - Lesson 1
Types of Functions - Lesson 2
String Functions - Lesson 1
String Functions - Lesson 2
String Functions - Lesson 3
Number Functions
Date Functions - Lesson 1
Date Functions - Lesson 2
Other Functions - Lesson 1
Other Functions - Lesson 2
Datatype Conversion Functions - Lesson 1
Datatype Conversion Functions - Lesson 2
Custom Functions Using PL/SQL

Filtering SELECT Statements
The WHERE Clause
Conditional Comparisons
Using the WHERE Clause
Using Logical Operators - Lesson 1
Using Logical Operators - Lesson 2
Using Conditional Comparisons - Lesson 1
Using Conditional Comparisons - Lesson 2

Sorting SELECT Statements
The ORDER BY Clause
Sorting Methods

Joining Multiple Tables
What is a Join?
Two Join Syntax Formats
Types of Joins in Oracle - Lesson 1
Types of Joins in Oracle - Lesson 2
Types of Joins in Oracle - Lesson 3
Cross Join or Cartesian Product
Natural or Inner Join - Lesson 1
Natural or Inner Join - Lesson 1
Natural or Inner Join - Lesson 1
Outer Join - Lesson 1
Outer Join - Lesson 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 - Lesson 1
Types of Grouping Functions - Lesson 2
Special Behavior - Lesson 1
Special Behavior - Lesson 2
Summary Functions
Statistical Functions
Other Functions
Filtering GROUP BY with the HAVING Clause
Extending the GROUP BY Clause - Lesson 1
Extending the GROUP BY Clause - Lesson 2

Subqueries and Other Advanced Queries
What is a Subquery?
Types of Subqueries
Comparison Conditions Revisited - Lesson 1
Comparison Conditions Revisited - Lesson 2
Comparison Conditions Revisited - Lesson 3
Regular vs. Correlated Subqueries
Nested Subqueries and Replacing Joins
Where can Subqueries be Used?
Hierarchical Queries
Set Operators and Composite Queries

Oracle’s Data Manipulation Language (DML)
What is DML?
Adding Data with INSERT
Multiple Table INSERT - Lesson 1
Multiple Table INSERT - Lesson 2
Changing Data with UPDATE - Lesson 1
Changing Data with UPDATE - Lesson 2
Remove Data with DELETE or TRUNCATE - Lesson 1
Remove Data with DELETE or TRUNCATE - Lesson 2
Merging Tables with MERGE - Lesson 1
Merging Tables with MERGE - Lesson 2
Transactional Control
Locking and Visibility of Data Changes
COMMIT vs ROLLBACK

PL/SQL (Programming Language SQL)
What is PL/SQL?
Modular Structure
Anonymous Procedures
Named Procedures
Functions
Packages
Triggers - Lesson 1
Triggers - Lesson 2
Variables and Types in PL/SQL - Lesson 1
Variables and Types in PL/SQL - Lesson 2
Objects and Object Datatypes
More About Objects - Lesson 1
More About Objects - Lesson 2
Programming Control Structures
Simple Database Access in PL/SQL
Cursors and Implicit Cursors - Lesson 1
Cursors and Implicit Cursors - Lesson 2
Explicit Cursors - Lesson 1
Explicit Cursors - Lesson 2
Dynamic SQL
Provided (DBMS_) Packages