This Oracle SQL training class helps students master SQL using an Oracle database and prepares students for a PL/SQL course. Note that this course is an Oracle SQL course, not a PL/SQL course.

• Introduction to Users and Schemas
• Definitions and Client Tools
• SQL Developer Login
• About the HR Schema
• Sample Schemas
• HR Schema Entities
• Creating An Application Schema
• Exercise: Create a User

• Using The Dual Table
• Functions
• Exercise: Use the SYSCONTEXT function
• Pseudo-Columns
• Using Rowid
• Using Rownum
• Exercise: Use ROWNUM

• Simple Subqueries
• Definition
• Nested Subquery
• Inline Views
• Subquery in the HAVING clause
• Correlated Subqueries
• Scalar Subquery
• Exercise: Subqueries

• Review of Joins
• Equijoins
• Inner Joins
• Outer Joins
• Cross Joins
• Reflexive Join
• Non-Key Join
• Natural Joins
• Semijoins and Antijoins
• Using Named Subqueries
• Exercise: Join Exercises

• What Are SQL Functions?
• Character Functions
• Regular Expressions
• Exercise: Character Functions

• Numeric Functions
• The TO_CHAR Function with numbers
• Date/Time Functions
• Date Format Functions
• Date Arithmetic Functions
• Null Value Functions
• Exercise: SQL Non-Character Functions

• The INSERT Statement
• INSERT Statement Categories
• The UPDATE Statement
• The DELETE Statement
• Transactions
• Complex Table References
• The MERGE statement
• Exercise: Data Manipulation Language (DDL)

• About SQL DDL
• Create Table Statement
• Populate the table
• Alter Table Statement
• Drop Table Statement
• CREATE TABLE using SELECT
• Truncate Table Statement

• About Constraints
• Unique Key
• Primary Key
• Referential Integrity
• Check Constraint
• Defining Constraints On Existing Tables
• Enabling & Disabling Constraints
• Renaming & Dropping Constraints
• Validate New Transactions Only
• Constraint Exceptions