Course curriculum
-
1
Welcome!
-
2
Introduction to BigQuery
-
3
SQL
-
4
Querying Data in BigQuery
-
5
Advanced Features
-
6
Data Visualization
-
7
Data Cleaning and Preparation
-
8
Machine Learning with BigQuery
-
9
Summary
-
Welcome! FREE PREVIEW Welcome to BigQuery Course FREE PREVIEW Create a GCP Account FREE PREVIEW -
Introduction FREE PREVIEW Tables Structure FREE PREVIEW Slots FREE PREVIEW Data Structure FREE PREVIEW Demo - create a Data Set FREE PREVIEW Create an Empty Table Create Table from a Query Create Table from a Source Exercise 1 exercise 1 Exercise 1 Solution -
Introduction to SQL The Select Statement Join Aggregate Functions Group By Exercise 2 - SQL Queries Exercise 2 Exercise 2 Solution -
Chapter's Overview Dataset Overview The Dataset for this Chapter Run Query More Queries Union Tables Generate Code Tables Exercise 3 - Qurying in BigQuery Exercise 3 Exercise 3 Solution Exercise 3 Solution Files -
Normalization Nested and Repeated Fields Creating Tables with Nested Values Dataset for Creating nested Fields Querying Nested and Repeated Fields Partitioning Create Partitioned Tables Clustering Exercise 4 - Nested and repeated Fields Exercise 4 Dataset -
Introduction to Visualization View Data in Looker Studio Dataset for the Chapter Overview of Looker Studio UI Scoreboard Pie and Line Charts Calculated fields Bar Chart Box Plot Exercise 5 - Visualizing Data exercise 5 Files -
Introduction to Data Preparation Data Cleaning Challenges Dataset Overview Dataset for this Chapter Deleting Columns Removing Duplications Removing Null Values Categorized Strings Visualizing the Data Removing Outliers Recap Exercise 6 - Cleaning Data Exercise 6 Dataset -
Introduction to Machine Learning Linear Regression Create Model Evaluate Model Evaluate Model in BigQuery Make Predictions Exercise 7 - Create a Machine Learning Model Exercise 7 Files -
Course Summary
מחיר הסדנא
מחיר הסדנא הוא 50 שקלים והוא כולל השתתפות בשיעור החי וגישה לא מוגבלת בזמן להקלטה וחומרי הלמידה.
-
קח אותי לקורס
$35.00