Querying Official Languages and Sorting

Introduction

In this project, you will learn how to query and sort the official languages spoken in different countries using SQL. You will access the MySQL database, import the necessary data, and write a SQL script to retrieve and order the official languages.

👀 Preview

MariaDB [world]> SOURCE /home/labex/project/getOfficialLanguageOrder.sql;
+-------------+------------+
| CountryCode | Language   |
+-------------+------------+
| ABW         | Dutch      |
| AFG         | Dari       |
| AFG         | Pashto     |
| AIA         | English    |
| ALB         | Albaniana  |
| AND         | Catalan    |
| ANT         | Dutch      |
| ANT         | Papiamento |
| ARE         | Arabic     |
| ARG         | Spanish    |
+-------------+------------+
10 rows in set (0.000 sec)

🎯 Tasks

In this project, you will learn:

• How to access the MySQL database using the sudo command without a password
• How to import data from a SQL script into the MySQL database
• How to write a SQL query to retrieve the official languages spoken in each country, sorted by their country codes
• How to run a SQL script in the MySQL database

🏆 Achievements

After completing this project, you will be able to:

• Understand how to work with the MySQL database using the command line
• Write SQL queries to extract and sort data from a database
• Apply your SQL knowledge to solve real-world data manipulation problems