Oracle Cloud: Basic Oracle SQL with hands on Experience

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Introduction to SQL

Lecture 1: What is SQL?

Lecture 2: Database Tables

Lecture 3: Overview of table data types

Lecture 4: SQL query structure

Chapter 3: Setup course environment

Lecture 1: Downloading the course VM

Chapter 4: Using Oracle SQL Developer

Lecture 1: Introduction to Oracle SQL Developer

Lecture 2: Creating a connection to the database

Lecture 3: Managing existing connections

Lecture 4: Exploring database objects

Lecture 5: Filtering specific objects

Lecture 6: Using SQL Developer tabs

Lecture 7: Viewing query output

Lecture 8: Case sensitivity of SQL commands

Lecture 9: Viewing SQL execution history

Lecture 10: Query output as grid or script

Chapter 5: Basic SELECT Queries

Lecture 1: Writing your first SELECT query

Lecture 2: Selecting only specific columns

Lecture 3: Using WHERE to filter specific rows

Lecture 4: Using multiple WHERE conditions

Lecture 5: Using WHERE to filter partial strings

Lecture 6: Using WHERE to filter numeric ranges

Lecture 7: Using WHERE IN and NOT IN for strings

Lecture 8: Using WHERE IN and NOT IN for numbers

Lecture 9: Using WHERE to filter dates

Lecture 10: Using WHERE to filter exact strings

Lecture 11: Using DISTINCT to eliminate duplicates

Lecture 12: Performing basic numeric calculations

Lecture 13: Using column aliases

Lecture 14: Describe the structure of a table

Lecture 15: Using ORDER BY

Chapter 6: String, Number, and Date Functions

Lecture 1: Introduction to functions

Lecture 2: Using SUBSTRING, LENGTH, and CONCAT

Lecture 3: Using LENGTH

Lecture 4: Using CONCAT

Lecture 5: Using LOWER and UPPER

Lecture 6: Using INSTR

Lecture 7: Using RPAD and LPAD

Lecture 8: Using TO_CHAR to convert numbers

Lecture 9: Using TO_CHAR to format DATE values

Lecture 10: Using TO_CHAR to filter DATE values

Lecture 11: The special Oracle DUAL table

Lecture 12: Using ROUND

Lecture 13: Using TRUNC

Lecture 14: Using SYSDATE

Lecture 15: Using SYSTIMESTAMP

Lecture 16: Using MONTHS_BETWEEN

Lecture 17: Using ADD_MONTHS

Chapter 7: Joining Table Data

Lecture 1: Introduction to SQL joins

Lecture 2: Joining data from tables

Lecture 3: INNER JOIN

Lecture 4: LEFT JOIN

Lecture 5: RIGHT JOIN

Lecture 6: FULL OUTER JOIN

Lecture 7: Joins with table aliases

Lecture 8: Oracle join syntax vs. ANSI syntax

Chapter 8: Manipulating Data

Lecture 1: Introduction to DML and DDL commands

Lecture 2: Creating a simple table

Lecture 3: Inserting a new row to a table

Lecture 4: COMMIT and ROLLBACK

Lecture 5: Introduction to transactions

Lecture 6: Deleting rows for a table

Lecture 7: Updating values

Lecture 8: Multiple-statement transactions

Lecture 9: Adding and dropping columns from a table

Lecture 10: Truncating all data from a table

Chapter 9: Grouping Data

Lecture 1: Introduction to aggregate functions

Lecture 2: Using aggregate functions

Lecture 3: Using GROUP BY

Lecture 4: Using GROUP BY with MAX, MIN, and AVG

Lecture 5: Using HAVING

Chapter 10: Advanced Topics

Lecture 1: Primary keys

Lecture 2: NOT NULL constraints

Lecture 3: Check constraints

Lecture 4: Foreign key constraints

Lecture 5: Subqueries