Monthly Subscription Starting at AED 99 + VAT

Oracle SQL Basics
  • Level Foundation
  • المدة 7 ساعات hours
  • الطبع بواسطة LearnQuest
  • Offered by

عن

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.

الوحدات

Introduction To Designing a Table

    • 3 Videos
    • 1 Plugin
Show info about module content

3 Videos

  • Welcome and Introduction
  • Introduction to Table Design
  • Walkthrough: Creating A Simple Table

Altering Tables

    • 2 Videos
    • 3 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Module 1 Quiz

2 Videos

  • Walkthrough: Altering an existing Table Schema
  • Walkthrough: Modifying a Column and Execute DDL Script

3 Readings

  • Managing Tables
  • Oracle Instance
  • Tables and Table Clusters

Understanding and Writing Simple SQL Statements

    • 3 Videos
    • 3 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • To GUI or Not To GUI?

3 Videos

  • The Anatomy of an SQL Statement
  • Insert Statement Example
  • Walkthrough Using An Insert Statement

3 Readings

  • SQL Standards
  • Types Of SQL Statements
  • Syntax for Schema Objects and Parts in SQL Statements

Updating a Table

    • 3 Videos
    • 1 Plugin
    • 1 Assignment
Show info about module content

1 Assignment

  • Module 2 Quiz

3 Videos

  • Update Statement Example
  • Walkthrough Using An Update Statement
  • The Delete Statement

Indexes

    • 5 Videos
    • 2 Readings
    • 1 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • Module 3 Quiz

1 Discussions

  • Why or Why Not?

5 Videos

  • Introduction To Indexes
  • Walkthrough: Creating Indexes
  • Types of Indexes
  • Walkthrough: Using Indexes
  • Walkthrough: Composite Indexes

2 Readings

  • Indexes and Index-Organized Tables
  • How the Database Maintains Indexes

Exercises: Table Simulations

    • 3 Plugin
Show info about module content

Auto Summary

Oracle SQL Basics, offered by Coursera, is a foundational course in IT & Computer Science designed to teach key elements of Oracle-specific Structured Query Language. As the third course in the Oracle specialization, it builds on prior courses, Oracle Database Foundations and Oracle Database Platform. With a duration of 420 minutes, it caters to beginners and offers both Starter and Professional subscription options. Ideal for those looking to deepen their SQL expertise within the Oracle environment.

Rafiq Wayani
Instructor

Rafiq Wayani