Oracle SQL Basics (Coursera)

Course 3 of 4 in the Oracle SQL Databases Specialization.

We recommend that you have completed the first two courses (Oracle Database Foundations and Oracle Database Platform) prior to beginning this one.

Syllabus

WEEK 1

Table Design

In this module, we'll first talk about the topics we'll address in this course. Then, we'll explore how to create a simple table, and look at ways to modify the existing table.

Structured Query Language (SQL)

In this module we'll explore the Structured Query Language (SQL). We will look at the anatomy of an SQL statement, explore inserting data into a table, modifying existing data, and look at the delete statement.

WEEK 2

Index Design

What are indexes and how are they utilized in Oracle?

Exercise: Test what you've learned!

In this exercise, you'll write some basic SQL code to build a table. Then, you'll modify it.