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