Query Population of All Countries

Introduction

In this project, you will learn how to access a MySQL database, import data, and retrieve population data for all countries. This project will help you develop skills in working with relational databases and SQL queries.

👀 Preview

MariaDB [world]> SOURCE /home/labex/project/getPopulation.sql;
+--------------------+
| Population / 10000 |
+--------------------+
| 10.3000            |
| 2272.0000          |
| 1287.8000          |
| 0.8000             |
| 340.1200           |
| 7.8000             |
| 21.7000            |
    ...
| 1064.0000          |
| 4037.7000          |
| 916.9000           |
| 1166.9000          |
+--------------------+
239 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 a database into MySQL
• How to write and execute SQL queries to retrieve data from a database

🏆 Achievements

After completing this project, you will be able to:

• Manage a MySQL database, including importing and querying data
• Write SQL queries to retrieve specific data from a database
• Understand how to work with population data and express it in units of ten thousand people