Self-paced

Explore our extensive collection of courses designed to help you master various subjects and skills. Whether you're a beginner or an advanced learner, there's something here for everyone.

Bootcamp

Learn live

Join us for our free workshops, webinars, and other events to learn more about our programs and get started on your journey to becoming a developer.

Upcoming live events

Learning library

For all the self-taught geeks out there, here is our content library with most of the learning materials we have produced throughout the years.

It makes sense to start learning by reading and watching videos about fundamentals and how things work.

Search from all Lessons

Login

Start interactive tutorial

← Back to Projects

SQL Project: Global Life Institute Data Detectives

Difficulty

  • easy

Average duration

2 hrs

Technologies

Difficulty

  • easy

Average duration

2 hrs

Technologies

🚛 How to deliver this project
Solutions

This is what you will learn during this project:

  • Use a preloaded database with pre-existing data.
  • Execute SQL statements to explore and analyze data in a biodiversity and climate change scenario.
  • Practice inserting, updating, and deleting relevant data as part of a data quality maintenance simulation.
  • Use SQL Alchemy, the industry's most popular library for connecting to SQL databases.
  • Use Pandas to display the results of your queries as DataFrames.

Within this repository, you will find a file named ./INSTRUCTIONS.md with the necessary steps to complete it.

🌱 How to start this project

This project comes with the necessary files to start working immediately.

We recommend opening this very same repository using a provisioning tool like Codespaces (recommended) or Gitpod. Alternatively, you can clone it on your local computer using the git clone command.

This is the repository you need to fork and open:

1https://github.com/4GeeksAcademy/exploratory-sql-analysis-project

👉 Please follow these steps on how to start a coding project.

Once your project and code have finished opening, you can go ahead and open the ./src/sql/queries.sql file and start solving each exercise inside the notebook.

🚛 How to deliver this project

Once you have finished solving the exercises, be sure to commit your changes, push them to your repository, and go to 4Geeks.com to upload the repository link.

Solutions

We also incorporated the solution samples in ./src/solution.py that we strongly suggest you only use if you are stuck for more than 30 minutes or if you have already finished and want to compare it with your approach.

Sign up and get access to solution files and videos for free

We will use it to give you access to your account.
Already have an account? Login here.

By signing up, you agree to the Terms and conditions and Privacy policy.

Difficulty

  • easy

Average duration

2 hrs

Technologies

Difficulty

  • easy

Average duration

2 hrs

Technologies

Difficulty

  • easy

Average duration

2 hrs

Technologies

Difficulty

  • easy

Average duration

2 hrs

Technologies

Sign up and get access to solution files and videos for free

We will use it to give you access to your account.
Already have an account? Login here.

By signing up, you agree to the Terms and conditions and Privacy policy.

Difficulty

  • easy

Average duration

2 hrs

Technologies

Difficulty

  • easy

Average duration

2 hrs

Technologies