In this course, you will be introduced to Oracle Database 12c, Oracle SQL Developer, relational database concepts and Structured Query Language (SQL). You will interact with a relational database and practice manipulating data.
By the end of this course, you will be able to retrieve data, create reports, run complex queries, run data manipulation language (DML), manage various user access levels and use Data Dictionary Views.
We are excited you are interested in this course.
The following is a setup checklist for this SQL course.
Download the Getting Started (PDF) for instructions on how to set up your environment. Complete the instructions are you are ready to go!
Congratulations! Now you are ready to practice the code examples or homework assignments provided in this course.
Lesson 1: Introducing Oracle SQL
SQL has been around for over 30 years. So why are we still teaching people this language? And why do they want to learn it? And why is it one of the most popular programming languages in the world today?
Because it's one of the most successful technologies for managing data in a database that has ever been created. Even with all the changes that have taken place in software and hardware in the past decades, SQL remains the most popular, powerful and effective way to work with data.
This lesson covers the following topics:
Lesson 2: Retrieving, Restricting and Sorting Data
In lesson 2, you will learn to write SQL queries to do the following:
Please watch each video carefully to ensure that you get the information you need to complete this lesson. The videos and tutorials are listed sequentially, and we recommend that you use the instructional materials in that order. At the end of the lesson, don't forget to take the quiz.
Solve the homework assignments to improve your understanding.
Ask any question or leave a comment in the SQL MOOC Community.
Lesson 3: Group Functions, Joins and Subqueries
In lesson 3, you will learn to write SQL queries to do the following:
Lesson 4: DML, DDL, User Access and Data Dictionary Views
Congratulations on making it to Lesson 4!
Till now, you have learned the various ways to retrieve data from the database tables. Now you will learn how to create tables and manage data in those tables. In lesson 4, you will learn to do the following: