City Names and Respective Countries

Introduction

In this project, you will learn how to retrieve city names and their corresponding country names from a MySQL database using an equi-join query. This project will help you understand the basics of SQL queries and how to work with relational databases.

👀 Preview

MariaDB [world]> SOURCE /home/labex/project/getCountryName.sql;
+----------------+-------------+
| CityName       | CountryName |
+----------------+-------------+
| Oranjestad     | Aruba       |
| Kabul          | Afghanistan |
| Qandahar       | Afghanistan |
| Herat          | Afghanistan |
| Mazar-e-Sharif | Afghanistan |
| Luanda         | Angola      |
| Huambo         | Angola      |
| Lobito         | Angola      |
| Benguela       | Angola      |
| Namibe         | Angola      |
+----------------+-------------+
10 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 a MySQL database
• How to write an equi-join query to retrieve data from multiple tables
• How to simplify table names and use aliases in SQL queries
• How to run a SQL script in MySQL

🏆 Achievements

After completing this project, you will be able to:

• Understand the basic structure and syntax of SQL queries
• Perform equi-join operations to retrieve data from multiple tables
• Simplify table names and use aliases to make your SQL queries more readable
• Import and manage data in a MySQL database
• Run SQL scripts to execute complex queries