This course, Oracle SQL Basics is the third course in the Oracle specialization. It is designed to help you learn the key elements of the Structured Query Language specific to Oracle. We recommend that you have completed the first two courses (Oracle Database Foundations and Oracle Database Platform) prior to beginning this one.
Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.
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.