Countries and Codes in Region

Beginner

In this project, you will learn how to retrieve the countries and their corresponding codes for the Caribbean region from the `world` database. This project will help you understand how to access MySQL, import data, and execute SQL queries to extract specific information from a database.

SQLMySQL

Introduction

In this project, you will learn how to retrieve the countries and their corresponding codes for the Caribbean region from the world database. This project will help you understand how to access MySQL, import data, and execute SQL queries to extract specific information from a database.

👀 Preview

+------+----------------------------------+
| Code | Name                             |
+------+----------------------------------+
| ABW  | Aruba                            |
| AIA  | Anguilla                         |
| ANT  | Netherlands Antilles             |
    ...
| VGB  | Virgin Islands, British          |
| VIR  | Virgin Islands, U.S.             |
+------+----------------------------------+
24 rows in set (0.001 sec)

🎯 Tasks

In this project, you will learn:

  • How to access MySQL using the sudo command without a password
  • How to import data from a SQL file into the MySQL database
  • How to switch to a specific database and execute SQL queries
  • How to retrieve data from a table based on a specific condition

🏆 Achievements

After completing this project, you will be able to:

  • Understand the basic operations of accessing and managing a MySQL database
  • Write SQL queries to extract data from a database based on specific criteria
  • Apply your knowledge of SQL to solve real-world data retrieval problems

Teacher

labby

Labby

Labby is the LabEx teacher.