Querying Official Languages of Each Country

# Introduction In this project, you will learn how to retrieve the official languages of each country using an equijoin query in MySQL. This project will help you understand how to work with relational databases, perform complex queries, and extract specific information from a database. ## 👀 Preview ``` +--------------------------------------+------------------+------------+ | Name | Language | IsOfficial | +--------------------------------------+------------------+------------+ | Aruba | Dutch | T | | Afghanistan | Dari | T | | Afghanistan | Pashto | T | ... | South Africa | Zulu | T | | Zimbabwe | English | T | +--------------------------------------+------------------+------------+ 238 rows in set (0.002 sec) ``` ## 🎯 Tasks In this project, you will learn: - How to access MySQL using the `sudo` command without any password - How to import data into MySQL from a SQL script - How to write an equijoin query to retrieve the official languages of each country - How to execute a SQL script in the MySQL console ## 🏆 Achievements After completing this project, you will be able to: - Understand the basics of relational databases and SQL queries - Perform complex queries involving multiple tables and conditions - Extract specific information from a database based on given requirements - Apply your knowledge of SQL to solve real-world data retrieval problems

|60 : 00

Click the virtual machine below to start practicing