Introduction

Preparing Course Environment (Part I)

Preparing Course Environment (Part II)

Introduction to SQL Developer

Demo - Getting Familiar with SQL Developer

Practice - Getting Familiar with SQL Developer

Overview of RDBMS ( Part 1)

Overview of RDBMS ( Part 2)

Data Models (PART I)

Data Models (PART II)

Introduction to Oracle SQL

Retrieving Data (PART I)

Retrieving Data (PART II)

Retrieving Data (PART III)

Restricting Data

Practice - Retrieving and Restricting Data

Quiz - Retrieving and Restricting Data

Sorting and Limiting Retrieved Rows

Practice - Sorting and Limiting Retrieved Rows

Quiz - Sorting and Limiting Retrieved Rows

Using Substitution Variables

Practice - Using Substitution Variables

Using Single-Row Functions

Practice - Using Single-Row Functions

Quiz - Using Single-row Functions

Working with DATE Data Type

Practice - Working with DATE Data Type

Using Conversion Functions (PART I)

Using Conversion Functions (PART II)

Practice - Using Conversion Functions

Converting Character to DATE Data Type

Practice - Converting Character to DATE Data Type

Quiz - Using Conversion Functions

Functions to Handle Null Values

Practice - Functions to Handle Null Values

Using Conditional Expressions

Practice - Using Conditional Expressions

Quiz - Conditional Expressions

Introducing Group Functions

Using Group Functions

Practice - Using Group Functions

Implementing Inner Joins (PART I)

Implementing Inner Joins (PART II)

Implementing Self and Non-equi Joins

Implementing Outer Joins

Practice - Using Joins

Quiz - Using Joins

Using Scalar Subqueries

Practice - Using Scalar Subqueries

Using Multiple-Row Subqueries

Using Multiple-Column Subqueries

Using Subqueries - More Options

Practice - Using Subqueries

Quiz - Subqueries

Using the Set Operators

Practice - Using Set Operators

Quiz - Set Operators

Hierarchical Retrieval

Using Oracle Database SQL Documentation

Using DML Statements - INSERT (PART I)

Using DML Statements - INSERT (PART II)

Using DML Statements - UPDATE

Using DML Statements - DELETE

Using DML Statements - MERGE

Practice - Using DML Statements

Quiz - DML

Using Transaction Control Commands (PART I)

Using Transaction Control Commands (PART II)

Demo - Using Transaction Control Commands

Practice - Using Transaction Control Commands

Read Consistency and Locking Data (PART I)

Read Consistency and Locking Data (PART II)

Demo - Read Consistency and Locking Data

Practice - Using Transaction Control Commands

Using SQL-Plus (PART I)

Using SQL-Plus (PART II)

Practice - Using SQL-Plus

Introduction to Oracle Database Built-in Data Types

Creating Tables

Demo - Creating Tables

Practice - Creating and Managing Tables

Quiz - Creating and Managing Tables

Modifying Table Structure

Demo - Modifying Table Structure

Managing Constraints - Fundamentals (PART I)

Managing Constraints - Fundamentals (PART II)

Managing Constraints - Fundamentals (PART III)

Demo - Managing Constraints - Fundamentals

Practice - Creating and Managing Constraints

Quiz - Constraint Fundamentals

Managing Views (PART I)

Managing Views (PART II)

Demo - Managing Views

Practice - Managing Views

Quiz - Views

Data Dictionary Views (PART I)

Data Dictionary Views (PART II)

Quiz - Data Dictionary Views

Creating and Managing Sequences

Demo - Creating and Managing Sequences

Quiz - Sequences

Creating Indexes

Demo - Creating Indexes

Creating Indexes - More Options

Demo - Creating Indexes - More Options

Practice - Creating Indexes

Quiz - Indexes

Defragmenting Indexes

Demo - Rebuilding Indexes

Creating Database Users

Controlling User Access - System Privileges

Demo - Managing System Privileges

Controlling User Access - Object Privileges

Demo - Managing Object Privileges

Managing Roles

Demo - Managing Roles

Practice - Managing Users and User Security

Quiz - Managing Privileges and Roles

Creating and Managing Synonyms

Demo - Creating and Managing Synonyms

Using TIMESTAMP Data Type

Demo - Using TIMESTAMP Data Type

Using TIMESTAMP WITH TIME ZONE Data Type

Demo - Using TIMESTAMP WITH TIME ZONE Data Type

Quiz - Using TIMESTAMP

Handling Daylight Saving Time

Demo - Handling Daylight Saving Time

More Datetime Functions

Demo - More Datetime Functions

Managing Interval Data Types

Demo - Managing Interval Data Types

Quiz - Managing Interval Data Types

Managing Temporary Tables

Demo - Managing Temporary Tables

Quiz - Managing Temporary Tables

Managing External Tables

Demo - Managing External Tables

Quiz - Managing External Tables

Managing Constraints - Advanced Topics

Demo - Managing Constraints - Advanced Topics

Quiz - Managing Constraints - Advanced Topics