Live Training: Analyzing Carbon Footprints in SQL

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

• Webinar notebook here

• Solution notebook here

Follow along with this training in Workspace.