Oracle SQL Basics by Coursera
Skills you will learn!
Curriculum
10 Topics
Welcome and Introduction
Introduction to Table Design
Walkthrough: Creating A Simple Table
Walkthrough: Altering an existing Table Schema
Walkthrough: Modifying a Column and Execute DDL Script
Managing Tables
Oracle Instance
Tables and Table Clusters
Module 1 Quiz
Activity: Creating a Table
12 Topics
The Anatomy of an SQL Statement
Insert Statement Example
Walkthrough Using An Insert Statement
Update Statement Example
Walkthrough Using An Update Statement
The Delete Statement
SQL Standards
Types Of SQL Statements
Syntax for Schema Objects and Parts in SQL Statements
Module 2 Quiz
To GUI or Not To GUI?
Activity: Updating a Table
9 Topics
Introduction To Indexes
Walkthrough: Creating Indexes
Types of Indexes
Walkthrough: Using Indexes
Walkthrough: Composite Indexes
Indexes and Index-Organized Tables
How the Database Maintains Indexes
Module 3 Quiz
Why or Why Not?
3 Topics
Create a Simple Table - Simulation
Insert and Filter - Simulation
Update and Delete - Simulation
Oracle SQL Basics
Related Oracle SQL Courses
Thank You!
Your review has been submitted successfully.