Official Languages in Various Countries

Introduction

In this project, you will learn how to access the MySQL database, import data, and query the official languages spoken in different countries.

👀 Preview

🎯 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 file into the MySQL database
• How to write a query to retrieve the first 10 records of official languages from the countrylanguage table

🏆 Achievements

After completing this project, you will be able to:

• Understand how to access and manage a MySQL database using the command line
• Demonstrate the ability to import data into a MySQL database
• Write SQL queries to retrieve specific data from a database table

Skills Graph

Access MySQL and Import the Data

In this step, you will learn how to access the MySQL database using the sudo command without a password, and import the data from the /home/labex/project/world.sql file into the MySQL database.

1. Open a terminal and start the MySQL service:

sudo service mysql start

2. Access the MySQL database using the sudo command:

sudo mysql

3. Import the data from the /home/labex/project/world.sql file into the MySQL database:

SOURCE /home/labex/project/world.sql;

This will import the data from the world.sql file into the MySQL database.

Query the Official Languages

In this step, you will learn how to query the official languages for all countries listed in the countrylanguage table and retrieve the first 10 records.

1. Switch to the world database:

USE world;

2. Write the query to retrieve the first 10 records of official languages:

SELECT `CountryCode`, `Language`
FROM countrylanguage
WHERE IsOfficial = 'T'
LIMIT 10;

This query will select the CountryCode and Language columns from the countrylanguage table, where the IsOfficial column is set to 'T' (true), and limit the results to the first 10 records.

Save the Query as a Script

In this step, you will learn how to save the query as a script and place it in the /home/labex/project directory.

1. Copy the query from the previous step and paste it into the file:

   SELECT `CountryCode`, `Language`
   FROM countrylanguage
   WHERE IsOfficial = 'T'
   LIMIT 10;

   Now, the getOfficialLanguage.sql script is ready to be executed in the MySQL database.

2. In the MySQL client, run the following command to execute the getOfficialLanguage.sql script:

   SOURCE /home/labex/project/getOfficialLanguage.sql

You should see the following output:

MariaDB [world]> SOURCE /home/labex/project/getOfficialLanguage.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)

Summary

Congratulations! You have completed this project. You can practice more labs in LabEx to improve your skills.