hands-on lab
Reviewing Product Inventory in a Cloud SQL Database
Difficulty: Beginner
Duration: Up to 1 hour
Students: 79
Rating: 4/5
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.
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 starting out with databases
- Anyone interested in using Python to store and query data in a MySQL Database running in Google Cloud SQL
Prerequisites
You should possess:
- A basic understanding of Python
Updates
August 8th, 2024 - Added password protection to notebook
Covered topics
Lab steps
Signing In to the Google Cloud Console
Opening the Lab's Jupyter Notebook in Google Cloud