MENU


According to QWIKLABS:  Big data, machine learning, and scientific data? It sounds like the perfect match. In this advanced-level quest, you will get hands-on practice with GCP services like Big Query, Dataproc, and Tensorflow by applying them to use cases that employ real-life, scientific data sets. By getting experience with tasks like earthquake data analysis and satellite image aggregation, Scientific Data Processing will expand your skill set in big data and machine learning so you can start tackling your own problems across a spectrum of scientific disciplines.



Lab Name Lab Code Lab Link Youtube Link
Introduction to SQL for BigQuery and Cloud SQL GSP281 https://google.qwiklabs.com/focuses/2802?parent=catalog https://youtu.be/l-2b0HCO8iI
Rent-a-VM to Process Earthquake Data GSP008 https://google.qwiklabs.com/focuses/1846?parent=catalog https://youtu.be/ayI_M_8aKWQ
Weather Data in BigQuery GSP009 https://google.qwiklabs.com/focuses/609?parent=catalog https://youtu.be/pJf4E3LpCuc
Distributed Image Processing in Cloud Dataproc GSP010 https://google.qwiklabs.com/focuses/5834?parent=catalog https://youtu.be/yIcyTpE5Pmc
Analyzing Natality Data Using AI Platform and BigQuery GSP012 https://google.qwiklabs.com/focuses/604?parent=catalog #
Predict Baby Weight with TensorFlow on AI Platform GSP013 https://google.qwiklabs.com/focuses/607?parent=catalog https://youtu.be/UZyBa3vWIJw


According to QWIKLABS:  Learn best practices to Extract, Transform, and Load your data into Google Cloud with BigQuery. In this series of interactive labs you will create and optimize your own data warehouse using a variety of large-scale BigQuery public datasets. BigQuery is Google's fully managed, NoOps, low cost analytics database. With BigQuery you can query terabytes and terabytes of data without having any infrastructure to manage or needing a database administrator. BigQuery uses SQL and can take advantage of the pay-as-you-go model.



Lab Name Lab Code Lab Link Youtube Link
BigQuery: Qwik Start - Command Line GSP071 https://google.qwiklabs.com/focuses/577?parent=catalog #
Creating a Data Warehouse Through Joins and Unions GSP413 https://google.qwiklabs.com/focuses/3640?parent=catalog #
Creating Date-Partitioned Tables in BigQuery GSP414 https://google.qwiklabs.com/focuses/3694?parent=catalog #
Troubleshooting and Solving Data Join Pitfalls GSP412 https://google.qwiklabs.com/focuses/3638?parent=catalog #
Working with JSON, Arrays, and Structs in BigQuery GSP416 https://google.qwiklabs.com/focuses/3696?parent=catalog #
Build and Execute MySQL, PostgreSQL, and SQLServer to Data Catalog Connectors GSP814 https://google.qwiklabs.com/focuses/11999?parent=catalog #

According to QWIKLABS:  Cloud SQL is a fully managed database service that stands out from its peers due to high performance, seamless integration, and impressive scalability. In this fundamental-level quest, you will receive hands-on practice with the basics of Cloud SQL and quickly progress to advanced features, which you will apply to production frameworks and application environments. From creating instances and querying data with SQL, to building Deployment Manager scripts and highly available databases that run on GKE containers, Cloud SQL will give you the knowledge and experience needed so you can start integrating this service right away.



Lab Name Lab Code Lab Link Youtube Link
Introduction to SQL for BigQuery and Cloud SQL GSP281 https://google.qwiklabs.com/focuses/2802?parent=catalog https://youtu.be/l-2b0HCO8iI
Cloud SQL for MySQL: Qwik Start GSP151 https://google.qwiklabs.com/focuses/936?parent=catalog #
Loading Data into Google Cloud SQL GSP196 https://google.qwiklabs.com/focuses/1157?parent=catalog #
Cloud SQL with Terraform GSP234 https://google.qwiklabs.com/focuses/1215?parent=catalog #
Using Ruby on Rails with Cloud SQL for PostgreSQL GSP109 https://google.qwiklabs.com/focuses/1854?parent=catalog #
APIs Explorer: Cloud SQL GSP423 https://google.qwiklabs.com/focuses/3685?parent=catalog #
Connect to Cloud SQL from an Application in Kubernetes Engine GSP449 https://google.qwiklabs.com/focuses/5625?parent=catalog #

According to QWIKLABS:  This advanced-level quest is unique amongst the other Qwiklabs offerings. The labs have been curated to give IT professionals hands-on practice with topics and services that appear in the Google Cloud Certified Professional Data Engineer Certification. From Big Query, to Dataprep, to Cloud Composer, this quest is composed of specific labs that will put your Google Cloud data engineering knowledge to the test. Be aware that while practice with these labs will increase your skills and abilities, you will need other preparation, too. 



Lab Name Lab Code Lab Link Youtube Link
Creating a Data Transformation Pipeline with Cloud Dataprep GSP430 https://google.qwiklabs.com/focuses/4415?parent=catalog https://youtu.be/p3m9gH7i8oM
Building an IoT Analytics Pipeline on Google Cloud GSP088 https://google.qwiklabs.com/focuses/605?parent=catalog https://youtu.be/TQ4FPxzu00s
ETL Processing on Google Cloud Using Dataflow and BigQuery GSP290 https://google.qwiklabs.com/focuses/3460?parent=catalog https://youtu.be/Zdp42ZaQcTk
Predict Visitor Purchases with a Classification Model in BQML GSP229 https://google.qwiklabs.com/focuses/1794?parent=catalog https://youtu.be/d_1UvIUPokU
Predict Housing Prices with Tensorflow and AI Platform GSP418 https://google.qwiklabs.com/focuses/3644?parent=catalog https://youtu.be/CTFnfXQt9IY
Cloud Composer: Copying BigQuery Tables Across Different Locations GSP283 https://google.qwiklabs.com/focuses/3528?parent=catalog #

According to QWIKLABS: When you complete this activity, you can earn the badge displayed above! View all the badges you have earned by visiting your profile page. Boost your cloud career by showing the world the skills you have developed!



Lab Name Lab Code Lab Link Youtube Link
Introduction to SQL for BigQuery and Cloud SQL GSP281 https://google.qwiklabs.com/focuses/2802?parent=catalog https://youtu.be/l-2b0HCO8iI
Visualize the 10,000 Bitcoin Pizza Transaction Using BigQuery and AI Notebooks GSP604 https://google.qwiklabs.com/focuses/5568?parent=catalog https://youtu.be/J0bu--EMVQs
Tracking Cryptocurrency Exchange Trades with Google Cloud Platform in Real-Time GSP603 https://google.qwiklabs.com/focuses/5570?parent=catalog https://youtu.be/4f6m8sO-eJw
Getting Started with Blockchain on GCP using Hyperledger Fabric and Composer GSP420 https://google.qwiklabs.com/focuses/3744?parent=catalog https://youtu.be/XJrVHAobr1c
Exploring the Public Cryptocurrency Datasets Available in BigQuery GSP665 https://google.qwiklabs.com/focuses/8486?parent=catalog https://youtu.be/KBUcVLkMXYI
Spin Up A Blockchain Node with BlockApps STRATO in 3 minutes GSP705 https://google.qwiklabs.com/focuses/10505?parent=catalog #