Query Population of All Countries

Beginner

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.

SQLMySQL

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

Teacher

labby

Labby

Labby is the LabEx teacher.