Monthly Subscription Starting at AED 99 + VAT

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

عن

This course is designed to help you continue learning about Oracle SQL and prepares you to take the Oracle SQL Certification Exam. We'll review methodologies and terminology that we presented in the Oracle Specialization courses, show some demos and give in-depth explanations. You'll also have the opportunity to take a practice certification exam. We recommend that you first complete the Oracle SQL Databases Specialization.

الوحدات

Introduction and Why SQL

    • 2 Videos
Show info about module content

2 Videos

  • Introduction To The Course
  • Why SQL?

Table Design

    • 3 Videos
    • 2 Readings
Show info about module content

3 Videos

  • Table Design (Part 1 of 2)
  • Table Design (Part 2 of 2)
  • Schema Building Exercise

2 Readings

  • Activity: Creating a Schema
  • Reading: Schemas

Module 1 Review

    • 1 Assignment
Show info about module content

1 Assignment

  • Module 1 Quiz

Database Terms

    • 6 Videos
    • 2 Readings
Show info about module content

6 Videos

  • Database Terms (Part 1 of 6)
  • Database Terms (Part 2 of 6)
  • Database Terms (Part 3 of 6)
  • Database Terms (Part 4 of 6)
  • Database Terms (Part 5 of 6)
  • Database Terms (Part 6 of 6)

2 Readings

  • SQL Database Terms
  • More Database Terms to Know

Module 2 Review

    • 1 Assignment
Show info about module content

1 Assignment

  • Module 2 Quiz

Primary Key and Foreign Key Constraints

    • 4 Videos
    • 2 Readings
Show info about module content

4 Videos

  • Primary Key Constraint (Part 1 of 2)
  • Primary Key Constraint (Part 2 of 2)
  • Foreign Key Constraint
  • Foreign Key Constraint and the Using Clause

2 Readings

  • Primary Key Constraints
  • Foreign Keys and the USING Clause

Module 3 Review

    • 1 Assignment
Show info about module content

1 Assignment

  • Module 3 Quiz

Functions, Queries, Subqueries, and Pseudocolumns

    • 3 Videos
    • 1 Readings
Show info about module content

3 Videos

  • Using SQL Functions within Queries
  • Subqueries
  • More on Subqueries and Pseudocolumns

1 Readings

  • Subqueries Further Explained

Views

    • 2 Videos
    • 1 Readings
Show info about module content

2 Videos

  • Views
  • Materialized Views

1 Readings

  • View versus Materialized View

Module 4 Review

    • 1 Assignment
Show info about module content

1 Assignment

  • Module 4 Quiz

Oracle SQL Practice Certification Exam

    • 1 Assignment
Show info about module content

1 Assignment

  • Practice SQL Certification Exam

Auto Summary

Prepare for the Oracle SQL Certification Exam with this comprehensive Coursera course. Tailored for IT and Computer Science enthusiasts, it reviews key methodologies and terminology, offers demos, and provides in-depth explanations. The course includes a practice certification exam and recommends prior completion of the Oracle SQL Databases Specialization. With a duration of 420 minutes, it’s ideal for foundational learners looking to advance their SQL skills. Available with a Starter subscription.

Rafiq Wayani
Instructor

Rafiq Wayani