Oracle SQL Basics

Go to class
Write Review

Free Online Course: Oracle SQL Basics provided by Coursera is a comprehensive online course, which lasts for 2 weeks long, 7-8 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from Coursera. Oracle SQL Basics is taught by Rafiq Wayani.

Overview
  • 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.

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.