Oracle SQL Proficiency

Go to class
Write Review

Free Online Course: Oracle SQL Proficiency provided by Coursera is a comprehensive online course, which lasts for 2 weeks long, 6-7 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 Proficiency is taught by Rafiq Wayani.

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

Syllabus
    • Review SQL
      • In this module, we'll take a look at the three SQL Command Categories, and review the insert, update, and delete commands as well as the select statement.
    • Create And Alter Commands
      • In this module, we are going to take a closer look at the create, alter, and update commands, as well as demonstrate many ways they can be used.
    • Database Relationships
      • In this module, we are going to explore the relationships between tables and how they are linked using primary and foreign keys.
    • Views and Functions
      • In this module, we'll explore database views, their benefits, and how they are used. We'll also take a look at SQL functions.