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.
Overview
Syllabus
- 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.
- 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.
Taught by
Rafiq Wayani
