BigQuery Course - Google Cloud Platform
Hi Everyone, welcome to our BigQuery course. In this course, we will learn about the different BigQuery commands and various terms and concepts in BigQuery. Click on any card topic of your choice and start learning.
Happy Learning!
Dataset in BigQuery
In this exercise, we will learn about creating a dataset in BigQuery.
In this exercise, we will learn about deleting a dataset in BigQuery.
In this exercise, we will learn about listing datasets in BigQuery.
In this exercise, we will learn about copying a dataset in BigQuery.
Table and its Operations
Basic SQL Commands in BigQuery
In this exercise, we will learn about the Comments in BigQuery.
In this exercise, we will learn about the SELECT Statement in BigQuery.
In this exercise, we will learn about the INSERT INTO Statement in BigQuery.
In this exercise, we will learn about the DELETE command in BigQuery.
In this exercise, we will learn about the GROUP BY clause in BigQuery.
In this exercise, we will learn about the Order By clause in BigQuery.
In this exercise, we will learn about the DISTINCT keyword in BigQuery.
In this exercise, we will learn about the aliases in BigQuery.
In this exercise, we will learn about the update command in BigQuery.
Aggregate Functions
In this exercise, we will learn about the SUM function in BigQuery.
In this exercise, we will learn about the COUNT function in BigQuery.
In this exercise, we will learn about the AVG function in BigQuery.
In this exercise, we will learn about the MIN function in BigQuery.
In this exercise, we will learn about the MAX function in BigQuery.
Set Functions
In this exercise, we will learn about the UNION operator in BigQuery.
In this exercise, we will learn about the UNION ALL operator in BigQuery.
In this exercise, we will learn about the INTERSECT operator in BigQuery.
In this exercise, we will learn about the EXCEPT operator in BigQuery.
Text Functions in BigQuery
In this exercise, we will learn about the LOWER function in BigQuery.
In this exercise, we will learn about the LEFT function in BigQuery.
In this exercise, we will learn about the RIGHT function in BigQuery.
In this exercise, we will learn about the REVERSE function in BigQuery.
In this exercise, we will learn about the LENGTH function in BigQuery.
In this exercise, we will learn about the CONCAT function in BigQuery.
In this exercise, we will learn about the UPPER function in BigQuery.
In this exercise, we will learn about the REPLACE function in BigQuery.
Condition Clauses and Function
In this exercise, we will learn about the AND operator in BigQuery.
In this exercise, we will learn about the OR operator in BigQuery.
In this exercise, we will learn about the NOT operator in BigQuery.
In this exercise, we will learn about the IN operator in BigQuery.
In this exercise, we will learn about the LIKE operator in BigQuery.
In this exercise, we will learn about the WHERE clause in BigQuery.
In this exercise, we will learn about the LIMIT or TOP keyword in BigQuery.
In this exercise, we will learn about the CASE WHEN statement in BigQuery.
In this exercise, we will learn about the BETWEEN operator in BigQuery.
In this exercise, we will learn about the Having clause in BigQuery.
In this exercise, we will learn about the COALESCE function in BigQuery.
Date Functions
In this exercise, we will learn about the LAST_DAY function in BigQuery.
In this exercise, we will learn about the DATE_SUB function in BigQuery.
In this exercise, we will learn about the DATE_ADD function in BigQuery.
Window Functions
In this exercise, we will learn about the Window Function in BigQuery.
In this exercise, we will learn about the LAG function in BigQuery.
In this exercise, we will learn about the LEAD function in BigQuery.
In this exercise, we will learn about the RANK function in BigQuery.
In this exercise, we will learn about the DENSE_RANK function in BigQuery.
In this exercise, we will learn about the ROW_NUMBER function in BigQuery.
In this exercise, we will learn about the FIRST_VALUE function in BigQuery.
In this exercise, we will learn about the LAST_VALUE function in BigQuery.
Join Functions
In this exercise, we will learn about the LEFT JOIN in BigQuery.
In this exercise, we will learn about the INNER JOIN in BigQuery.
In this exercise, we will learn about the FULL JOIN in BigQuery.
In this exercise, we will learn about the RIGHT JOIN in BigQuery.