Oracle MOOC: SQL Fundamentals (2018)

In this course you are introduced to relational database concepts and SQL. Structured Query Language (SQL) is used to interact with a relational database and manipulate data. You will learn to write SQL statements to build query reports and manipulate data in Oracle Database 12c.

You will learn how to:

• Retrieve row and column data from tables with the SELECT statement
• Create reports of sorted and restricted data
• Employ SQL functions to generate and retrieve customized data
• Run complex queries to retrieve data from multiple tables
• Run data manipulation language (DML) statements to update data in Oracle Database
• Manage users with different levels of access privileges
• Use Data Dictionary Views

During this free, 4-week MOOC you will watch videos, complete homework and interact with fellow students and facilitators to guide your experience in gaining an introductory understanding of SQL and Oracle Database 12c.

Skills:  Familiarity with basic database and programming concepts.

Setup Required:

• Oracle Database 12c or access to Oracle Database Cloud Service
• Oracle SQL Developer

• Oracle Database 12c

• Oracle SQL Developer 

Join the SQL MOOC Community to ask questions, find FAQs and meet other students.

Enrollment is a multi-step process. After your enrollment is approved, you will be granted access to the course materials on the first day of the course.

Free!

4 weeks

Approximately 3 - 5 hours weekly

All the lesson information is made available to you on the first day of the course.  Lesson materials are available until the end of the course.  You can access the material any time, and interact with other students and the instructor using the Oracle Technology Network (OTN) Community for MOOCs.

A lesson consists of the following:

1. A series of videos and supporting materials, presented in order to explore the content for that week.
2. Demonstrations, a series of video's exploring the tasks learned each week.
3. Homework, a series of exercises which the student can follow to illustrate and reinforce the weeks content.
4. Assessments, a series of short quizzes are provided each week to assess your understanding.

There are course quizzes, by lesson. You will have 3 attempts to pass each quiz. Score 70% or greater on each of the quizzes and you will receive a course completion award. Quiz questions are based on the course content and homework.

English. The videos also have closed captions in English.