Intro to Oracle SQL

Overview

This course provides a step-by-step guide for users on how to create an Oracle Cloud Infrastructure account, provision an Autonomous Database, and connect to the Oracle Autonomous Database using SQL Worksheet. It also introduces users to Structured Query Language (SQL). It provides detailed instructions on creating, updating, and deleting tables that include primary keys, columns, constraints, indexes, and foreign keys, as well as other SQL-related topics.

Syllabus

Intro to the course, OCI Account Creation, ADB Creation and SQL Worksheet Access

This module is divided into four lessons: Introduction to the course, Create an Oracle Cloud Infrastructure Account, Provision an Oracle Autonomous AI Database and SQL Worksheet and run your first query

Run Basic Oracle SQL Commands - Part 1

This module is divided into seven lessons: Run Basic Oracle SQL Commands - Part 1, Creating Tables, Creating Triggers, Inserting Data, Indexing Columns, Querying Data and Adding Columns

Run Basic Oracle SQL Commands - Part 2

This module is divided into eight lessons: Run Basic Oracle SQL Commands - Part 2, Querying the Oracle Data Dictionary, Updating Data, Aggregate Queries, Compressing Data, Deleting Data, Dropping Tables and Un-dropping Tables