Oracle MOOC : SQL Fundamentals (2018) : Lesson 3: Group Functions, Joins and Subqueries

Welcome to the third week of SQL Fundamentals MOOC. 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.


Instructional Materials

3-1: Getting Started

3-2: Executing Group Functions

3-3: Retrieving Data from Multiple Tables - I

3-4: Retrieving Data from Multiple Tables - II

3-5: Nesting Queries

3-6: Working with Advanced Subqueries

Homework 3