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.

Happy Learning!

The following is a setup checklist for this SQL course.

1. Complete prep
2. Install VM
3. Start VM
4. Connect as SYS
5. Run Setup Scripts
6. Connect as User
7. Validate Scripts

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:

• Introduction to Oracle Cloud
• Relational database concepts
• Data storage terminologies
• Introduction to Oracle SQL

  Lesson 2: Retrieving, Restricting and Sorting Data

In lesson 2, you will learn to write SQL queries to do the following:

• Query data from tables using SELECT statement.
• Use operators and column aliases
• Limit row selection using WHERE clause
• Learn comparison and logical operators
• Sort the rows using ORDER BY clause
• Understand substitution variables
• Compute with single row functions
• Understand conversion functions and conditional expressions

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.

Enjoy!

  Lesson 3: Group Functions, Joins and Subqueries

In lesson 3, you will learn to write SQL queries to do the following:

• Create and restrict groups of data using group functions
• Retrieve data from multiple tables using joins
• Solve queries using subqueries

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.

Enjoy!

  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:

• Create and modify tables
• Insert and manage data
• Handle database transactions
• Control user access
• Query Data Dictionary views

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.

Good luck!