Monthly Subscription Starting at AED 99 + VAT

Oracle SQL Proficiency
  • Level Foundation
  • Duration 6 hours
  • Course by LearnQuest
  • Offered by

About

This course is designed to help you continue learning about Oracle SQL and database management. We will look more closely at the Create, Alter, and Update commands, explore database relationships, and demonstrate how to use database views and SQL functions. It is recommended that you complete the first three courses of this specialization prior to this one.

Modules

SQL Command Structure & Examples

    • 6 Videos
    • 4 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Module 1 Quiz

6 Videos

  • SQL Command Categories
  • Select Statement
  • Insert Command
  • Update Command
  • Delete Command
  • DDL Statements Demonstration

4 Readings

  • Writing Select Statements
  • Insert Statement
  • Update Statement
  • Power behind the DELETE Statement

DDL & DML Proficiency

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

1 Assignment

  • Module 2 Quiz

6 Videos

  • Create & Alter DDL Demo Part 1 of 2
  • Create & Alter DDL Demo Part 2 of 2
  • Alter DDL Command Explained Part 1 of 2
  • Alter DDL Command Explained Part 2 of 2
  • Alter DDL Command Demonstration
  • Update DML Command Demonstration

2 Readings

  • Create DDL Statement
  • Alter Table Statement

How Are Database Tables Related in Oracle

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

1 Assignment

  • Module 3 Quiz

3 Videos

  • Database Relationships Defined
  • Table Relationships Demonstration Part 1 of 2
  • Table Relationships Demonstration Part 2 of 2

1 Readings

  • Data Modeling

Using views

    • 3 Videos
    • 1 Readings
Show info about module content

3 Videos

  • Views - Defined
  • Views - Demonstrated
  • Views - Benefits

1 Readings

  • Managing Views

Using Functions

    • 2 Videos
    • 1 Readings
Show info about module content

2 Videos

  • Functions - Defined
  • Functions - Demonstration

1 Readings

  • Oracle SQL Functions

Module 4 Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Module 4 Quiz

Auto Summary

Unlock the potential of Oracle SQL and elevate your database management skills with the "Oracle SQL Proficiency" course. Ideal for those in IT and Computer Science, this foundational course delves deeper into essential SQL commands such as Create, Alter, and Update, while exploring database relationships, views, and functions. Taught by experts from Coursera, the course spans 360 minutes of intensive learning, ensuring you gain a comprehensive understanding of Oracle SQL. Perfect for beginners who have completed the initial three courses in the specialization, this course offers a solid foundation for anyone looking to advance their SQL expertise. Enjoy flexible learning with the Starter subscription option and take the next step in your database management journey today.

Rafiq Wayani
Instructor

Rafiq Wayani