Skip to content

This project focuses on analyzing data from the WORLD database. We utilize Python, Pandas, and MySQL to query and analyze the data.

Notifications You must be signed in to change notification settings

franciskyalo/sql_queries

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

19 Commits
 
 
 
 

Repository files navigation

SQL QUERIES WORLD DATABASE🛢

Static Badge Static Badge Jupyter NotebooksMySQL Pandas


Project Description✒️

This project focuses on analyzing data from the WORLD database, which includes three key tables: city, country, and countrylanguage. The aim is to gain insights into global demographics, language distribution, and regional characteristics. We utilize Python, Pandas, and MySQL to query and analyze the data, showcasing various including:

  • SQL operations
  • stored procedures
  • Views.

Entity Relationship Diagram🤝🏽

The database consists of the following tables:

city: Contains information about cities, including their names, country codes, districts, and populations. country: Provides details about countries, such as codes, names, continents, regions, surface areas, populations, and government forms. countrylanguage: Offers information on languages spoken in countries, including whether they are official and the percentage of speakers.

ERD (1)


Here are all the sql queries used:

To clone the repo, use the following:

git clone https://github.com/franciskyalo/sql_queries.git

Ensure you have python version greater than 3.8

To Create a virtual enviroment:

python -m venv newenviroment

To activate the enviroment use:

.\venv\Scripts\activate

carbon

carbon (1)

carbon (2)

carbon (3)

carbon (4)

carbon (5)

carbon (6)

About

This project focuses on analyzing data from the WORLD database. We utilize Python, Pandas, and MySQL to query and analyze the data.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published