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

Create a Dataset in BigQuery

In this exercise, we will learn about creating a dataset in BigQuery.

Delete a Dataset in BigQuery

In this exercise, we will learn about deleting a dataset in BigQuery.

List Datasets in BigQuery

In this exercise, we will learn about listing datasets in BigQuery.

Copy a Dataset in BigQuery

In this exercise, we will learn about copying a dataset in BigQuery.

Table and its Operations

Create a Table in BigQuery

In this exercise, we will learn about creating a table in BigQuery.

Delete a Table in BigQuery

In this exercise, we will learn about deleting a table in BigQuery.

Rename a Table in BigQuery

In this exercise, we will learn about renaming a table in BigQuery.

Basic SQL Commands in BigQuery

Comments in BigQuery

In this exercise, we will learn about the Comments in BigQuery.

SELECT Statement in BigQuery

In this exercise, we will learn about the SELECT Statement in BigQuery.

INSERT INTO Statement in BigQuery

In this exercise, we will learn about the INSERT INTO Statement in BigQuery.

DELETE command in BigQuery

In this exercise, we will learn about the DELETE command in BigQuery.

GROUP BY clause in BigQuery

In this exercise, we will learn about the GROUP BY clause in BigQuery.

Order By clause in BigQuery

In this exercise, we will learn about the Order By clause in BigQuery.

DISTINCT keyword in BigQuery

In this exercise, we will learn about the DISTINCT keyword in BigQuery.

Aliases in BigQuery

In this exercise, we will learn about the aliases in BigQuery.

Update command in BigQuery

In this exercise, we will learn about the update command in BigQuery.

Aggregate Functions

SUM function in BigQuery

In this exercise, we will learn about the SUM function in BigQuery.

COUNT function in BigQuery

In this exercise, we will learn about the COUNT function in BigQuery.

AVG function in BigQuery

In this exercise, we will learn about the AVG function in BigQuery.

MIN function in BigQuery

In this exercise, we will learn about the MIN function in BigQuery.

MAX function in BigQuery

In this exercise, we will learn about the MAX function in BigQuery.

Set Functions

UNION operator in BigQuery

In this exercise, we will learn about the UNION operator in BigQuery.

UNION ALL operator in BigQuery

In this exercise, we will learn about the UNION ALL operator in BigQuery.

INTERSECT operator in BigQuery

In this exercise, we will learn about the INTERSECT operator in BigQuery.

EXCEPT operator in BigQuery

In this exercise, we will learn about the EXCEPT operator in BigQuery.

Text Functions in BigQuery

LOWER function in BigQuery

In this exercise, we will learn about the LOWER function in BigQuery.

LEFT function in BigQuery

In this exercise, we will learn about the LEFT function in BigQuery.

RIGHT function in BigQuery

In this exercise, we will learn about the RIGHT function in BigQuery.

REVERSE function in BigQuery

In this exercise, we will learn about the REVERSE function in BigQuery.

LENGTH function in BigQuery

In this exercise, we will learn about the LENGTH function in BigQuery.

CONCAT function in BigQuery

In this exercise, we will learn about the CONCAT function in BigQuery.

UPPER function in BigQuery

In this exercise, we will learn about the UPPER function in BigQuery.

REPLACE function in BigQuery

In this exercise, we will learn about the REPLACE function in BigQuery.

Condition Clauses and Function

AND operator in BigQuery

In this exercise, we will learn about the AND operator in BigQuery.

OR operator in BigQuery

In this exercise, we will learn about the OR operator in BigQuery.

NOT operator in BigQuery

In this exercise, we will learn about the NOT operator in BigQuery.

IN and NOT IN operator in BigQuery

In this exercise, we will learn about the IN operator in BigQuery.

LIKE operator in BigQuery

In this exercise, we will learn about the LIKE operator in BigQuery.

WHERE clause in BigQuery

In this exercise, we will learn about the WHERE clause in BigQuery.

LIMIT keyword in BigQuery

In this exercise, we will learn about the LIMIT or TOP keyword in BigQuery.

CASE WHEN statement in BigQuery

In this exercise, we will learn about the CASE WHEN statement in BigQuery.

BETWEEN operator in BigQuery

In this exercise, we will learn about the BETWEEN operator in BigQuery.

Having clause in BigQuery

In this exercise, we will learn about the Having clause in BigQuery.

COALESCE function in BigQuery

In this exercise, we will learn about the COALESCE function in BigQuery.

Date Functions

LAST_DAY function in BigQuery

In this exercise, we will learn about the LAST_DAY function in BigQuery.

DATE_SUB function in BigQuery

In this exercise, we will learn about the DATE_SUB function in BigQuery.

DATE_ADD function in BigQuery

In this exercise, we will learn about the DATE_ADD function in BigQuery.

Window Functions

Window Function in BigQuery

In this exercise, we will learn about the Window Function in BigQuery.

LAG function in BigQuery

In this exercise, we will learn about the LAG function in BigQuery.

LEAD function in BigQuery

In this exercise, we will learn about the LEAD function in BigQuery.

RANK function in BigQuery

In this exercise, we will learn about the RANK function in BigQuery.

DENSE_RANK function in BigQuery

In this exercise, we will learn about the DENSE_RANK function in BigQuery.

ROW_NUMBER function in BigQuery

In this exercise, we will learn about the ROW_NUMBER function in BigQuery.

FIRST_VALUE function in BigQuery

In this exercise, we will learn about the FIRST_VALUE function in BigQuery.

LAST_VALUE function in BigQuery

In this exercise, we will learn about the LAST_VALUE function in BigQuery.

Join Functions

LEFT JOIN in BigQuery

In this exercise, we will learn about the LEFT JOIN in BigQuery.

INNER JOIN in BigQuery

In this exercise, we will learn about the INNER JOIN in BigQuery.

FULL JOIN in BigQuery

In this exercise, we will learn about the FULL JOIN in BigQuery.

RIGHT JOIN in BigQuery

In this exercise, we will learn about the RIGHT JOIN in BigQuery.

Advanced BigQuery or SQL Concepts

WITH clause in BigQuery

In this exercise, we will learn about the WITH clause in BigQuery.