Skip to main content
HomeCode alongsData Analysis

Live Training: Analyzing Carbon Footprints in SQL

In this code-along, we’ll use SQL to explore data of product carbon footprints.
Feb 2023
Code along with us onCode Along

Have you ever wondered about the carbon footprint of your jeans or soft drink? In this code-along, we’ll use SQL to explore product carbon footprints at companies like Levi’s and Coca-Cola.

Understanding emissions along a product’s lifecycle is important to achieving the steep carbon reductions required to meet global carbon goals. Our dataset shows how product emissions have changed over the years, and which part of the product’s life is most problematic for the environment. Watch this code-along and use your SQL powers for planet earth!

Key Takeaways

  • Filter data to spotlight information of interest

  • Calculate metrics to summarize data

  • Analyze and visualize data changes over time

Materials

  • When in Workspace, go to integrations on the left-side bar, then:

  • Click “Create integration,” select PostgreSQL, and enter:

  • Integration name: SQL Carbon Emissions Training

  • Port: 5432

  • Hostname: workspacedemodb.datacamp.com

  • Database: emissions

  • Username: emissions_codealong

  • Password: emissions_codealong

  • Solution notebook here

Topics

Learn Topics Related to This Code Along

Live Training: Analyzing Olympics Data with SQL and Python

Learn how to load data from different sources and perform exploratory analyses.

Webinars

Spend Less Time in Spreadsheets with SQL

Hate wrangling data in spreadsheets? SQL does it better.

Webinars