Oracle SQL and PL / SQL Tutorial Video

Welcome

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

The Oracle Relational Database Model

• The Relational Database Model
• The Concerts Schema
• Oracle PL SQL Normalization Tutorials 1
• Normalization 2
• Denormalization 1
• Denormalization 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 1
• Oracle Enterprise Manager 2

We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.

$99.95

The Architecture of Oracle

• The Oracle Database and Oracle Instance 1
• The Oracle Database and Oracle Instance 2
• Control Files, Logging, Archiving and Recoverability

Creating Database Objects

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

Users and Security

• Schemas, Users, Privileges and Roles 1
• Schemas, Users, Privileges and Roles 2
• Schemas, Users, Privileges and Roles 3
• Types of Users
• Creating Users Tutorials 1
• Creating Users 2
• Altering and Dropping Users
• Security
• Oracle SQL PL System Privileges
• Object Privileges
• Granting and Revoking Privileges Tutorials 1
• Granting and Revoking Privileges 2
• Grouping Privileges Using Roles 1
• Grouping Privileges Using Roles 2
• Setting Roles

Retrieving Data from the Database

• Oracle PL SQL SELECT Statement Tutorials 1
• The SELECT Statement 2
• The SELECT Statement 3
• Types of SELECT Statement 1
• Types of SELECT Statement 2
• The DUAL Table 1
• The DUAL Table 2
• What is a NULL?
• Pseudo-Columns 1
• Pseudo-Columns 2
• More About Oracle PL SQL Plus Formatting 1
• More About SQL Plus Formatting 2
• More About SQL Plus Formatting 3

Oracle Built In Functions

• Types of Functions Tutorials 1
• Types of Functions 2
• String Functions 1
• String Functions 2
• String Functions 3
• Number Functions
• Oracle PL SQL Date Functions 1
• Date Functions 2
• Other Functions 1
• Other Functions 2
• Datatype Conversion Functions 1
• Datatype Conversion Functions 2
• Custom Functions Using PL/SQL

Filtering SELECT Statements

• The WHERE Clause
• Conditional Comparisons
• Using the WHERE Clause
• Using Logical Operators Tutorials 1
• Using Logical Operators 2
• Using Conditional Comparisons 1
• Using Conditional Comparisons 2

Sorting SELECT Statements

• The ORDER BY Clause
• Sorting Methods Tutorials 1
• Sorting Methods 2
• Sorting Methods 3

Joining Multiple Tables

• What is a Join?
• Two Join Syntax Formats
• Types of Joins Tutorials 1
• Types of Joins 2
• Types of Joins 3
• Cross Join or Cartesian Product
• SQL PL Natural or Inner Join 1
• Change the Concerts Schema 1
• Change the Concerts Schema 2
• Oracle PL SQL Outer Join 1
• Outer Join 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 1
• Types of Grouping Functions 2
• Special Behavior 1
• Special Behavior 2
• Summary Functions
• Statistical Functions
• Other Functions
• Filtering GROUP BY with the HAVING Clause
• Extending the GROUP BY Clause Tutorials 1
• Extending the GROUP BY Clause 2

Subqueries and Other Advanced Queries

• What is a Subquery?
• Types of Subqueries
• Comparison Conditions Revisited 1
• Comparison Conditions Revisited 2
• Comparison Conditions Revisited 3
• Regular vs. Correlated Subqueries
• Nested Subqueries and Replacing Joins
• Where Can PL SQL 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 Tutorials 1
• Multiple Table INSERT 2
• Changing Data with UPDATE 1
• Changing Data with UPDATE 2
• Remove Data with DELETE or TRUNCATE Tutorials 1
• Remove Data with DELETE or TRUNCATE 2
• Merging Tables with MERGE 1
• Merging Tables with MERGE 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
• Oracle PL SQL Triggers Tutorials 1
• Triggers 2
• Variables and Types in PL/SQL 1
• Variables and Types in PL/SQL 2
• Objects and Object Datatypes
• More About Objects 1
• More About Objects 2
• Programming Control Structures
• Simple Database Access in PL/SQL
• Cursors and Implicit Cursors 1
• Cursors and Implicit Cursors 2
• Explicit Cursor Tutorials 1
• Explicit Cursors 2
• Dynamic SQL
• Provided (DBMS_) Packages