Countries and Codes in Region

# 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

|60 : 00

Click the virtual machine below to start practicing