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