hands-on lab

Reviewing Product Inventory in a Cloud SQL Database

Difficulty: Beginner

Duration: Up to 1 hour

Students: 85

Rating: 4/5

Start lab

On average, students complete this lab in20m

Get guided in a real environmentPractice with a step-by-step scenario in a real, provisioned environment.

Learn and validateUse validations to check your solutions every step of the way.

See resultsTrack your knowledge and monitor your progress.

About

Author

Description

Databases are essential to organizing and understanding your data. Databases allow you to ask questions, or query your data, to find exactly what is needed. This lab is aimed at beginners who want to move beyond spreadsheets and migrate their data into a database. After completing this lab students will be able to use a MySQL Database in Google Cloud SQL, and populate it from a CSV file. Additionally, students will learn how to use basic queries against their data.

Learning Objectives

Upon completion of this lab, you will be able to:

Learn and understand Google Cloud SQL
Utilizing Python to interact with a MySQL Database in Google Cloud SQL to ingest CSV data
Learn how to query our newly populated database

Intended Audience

This lab is intended for:

Individuals interested in learning about databases
Anyone interested in using Python to store and query data in a MySQL Database running in Google Cloud SQL