• Online, Self-Paced
Course Description

In this challenge you write several MySQL queries to join data from multiple tables by using outer joins. First, you will launch MySQL Workbench, and then you will compare inner and outer joins. Next, you will develop more specific queries that include joining tables by using multiple outer joins. Finally, you will explore queries that join tables using multiple join types. Note: Once you begin a challenge you will not be able to pause, save, or return to your progress. Please ensure you have set aside enough time to complete the challenge before you start.

Learning Objectives

In this challenge you write several MySQL queries to join data from multiple tables by using outer joins. First, you will launch MySQL Workbench, and then you will compare inner and outer joins. Next, you will develop more specific queries that include joining tables by using multiple outer joins. Finally, you will explore queries that join tables using multiple join types. Note: Once you begin a challenge you will not be able to pause, save, or return to your progress. Please ensure you have set aside enough time to complete the challenge before you start.

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.