The Complete Google BiqQuery Masterclass Beginner to Expert

Master Google BigQuery Analytics with SQL used in Big Query to analyze Real data for data scientists, Developers, etc.
The Complete Google BiqQuery Masterclass Beginner to Expert
File Size :
4.02 GB
Total length :
8h 31m



Sandeep Kumar


Last update




The Complete Google BiqQuery Masterclass Beginner to Expert

What you’ll learn

What is google Bigquery?
Google Bigquery in analytics
Bigquery for Google Analytics
Master all the important concepts of Google BigQuery
Digital Marketers will be able to create their own analysis sheet using BigQuery
Students will be expert in Arrays, UNNEST, STRUCT, CTE, Derived Tables, Structed data, unstructured data, etc
Master all the concepts of SQL in Big Query
Can write all the commands like Joins, Group by, Order By, Having clause, SubQueries, etc.
Create tables with partitioning
Can easily connect the Google BigQuery to Google Data Studio
Learning based on real time project which helps students to apply the concepts in his job
Helps the students to be Job ready in Google BigQuery
The SQL command learned in Google Bigquery can also be used in other Database tools like mySQL, Oracle, SQL Server, SQLite, PostGreSQL, etc

The Complete Google BiqQuery Masterclass Beginner to Expert


A Free Google account(Free Gmail account)
PC with Internet connection
Knowledge of Digital marketing will be even better although it is not required at all.


‘Using this Course, you will master Google BigQuery( BigQuery) and you can apply the SQL queries used in this course in any other Database management tool in Oracle, MySql, PostgreSQL, Microsoft Access, SQLite, and DB2’.”Welcome to the most popular Quality complete Course on Google BigQuery(Big Query). This is a complete Google google bigquery training”Master all the important concepts of Google BigQueryDigital Marketers will be able to create their own analysis sheetStudents will be expert in arrays, UNNEST, STRUCT, CTE, Derived Tables, etcMaster all the concepts of SQL in BigQueryCan write all the commands like Joins, Group by, Order By, Having clause, SubQueries, etc.Create tables with partitioningCan easily connect the Google BigQuery to Google Data StudioLearning based on a real-time project helps students to apply the concepts in his jobHelps the students to be Job ready in Google BigQueryBigquery for Google Analytics========================================================================Join this course which is the best “Google BigQuery” course. I will share all the syntax of BigQuery SQL with multiple examples along the way!!!Want to start learning SQL from scratch with no previous coding experience?You have come to the right place. Please have a look at the Course content carefully and ask a few questions from yourself?I have shared all the codes which are used in this courseIs the Course taught by a real-time expert? I have more than 15 years of experience as an Instructor and more than 10 years of experience in SQL along with Big Query. I firmly believe that if an Instructor does not have a good experience, he/she will flood the course with poor content.Is the Course content clear and Precise? The content is short, crisp, and clear.The course assumes no prior knowledge of Google BigQuery(BigQuery) and teaches you from scratch to an advanced levelOnce you Enroll for this Course, you get lifetime access to this course and you will get all the future updates.The course does not cover T-SQL directly but it will help you to learn T-SQL also.This will also help you to link Google Data studio with Google Big QueryIf you aspire to be a data scientist, data analyst, SQL Developer, etc, then it is going to help you a lot.If you plan to work with other databases like Oracle, MySQL, SQLite, PostgreSQL, etc, it will be extremely helpful.If you are a data scientist (Data Analysis role) or willing to become a data scientist, then SQL is a must and this course helps in data analytics.Do you want to start on Google BigQuery but have no experience with SQL?If you have some prior knowledge on Google BigQuery or if you are a complete fresher, you are at the right place. The Course teaches you to Google Big Query with SQL right from Scratch. It will be the best course for absolute beginners.There’s no risk involved in taking this Course!I am sure that this is the best complete course on Google BigQuery and SQL and it is the perfect starting point to master complete BigQuery and SQL.What if you are stuck?I personally answer all the questions which are asked here. If you are stuck anywhere, ask a question or you can message me directly and I will answer all your doubts.Are you getting updated content?Yes, I keep updating the content always to make sure, I provide all the information to my students.Once you enroll for this course-Google bigquery in analyticsWhat is google bigquery?How to use google bigqueryComplete Google bigquery tutorial and course which covers everything step by step You can easily analyze the google bigquery public datasetsMaster the datasets and tables in BigQueryUpload files from multiple ways to tableAll major SQL Statements in Google Big Query like below -Different SELECT StatementsSELECT statements with conditionsFilter the Records in Google Big QueryCopy records from one table to another table in Big QueryAll the major numerical, Date, and String Functions of SQL with functions which are only present in Big QueryYou will master all the special operatorsJoins, SubQueries, UNIONs are covered in detailCTE and Derived tables are explained beautifully with a lot of examplesFind a pattern of records in Google Big QueryI have explained the concepts of Arrays, Struct, UNNEST, etc in detail which you will not find in any other courseAll the major functions which are exclusively available in Google BigQuery is covered with easy-going examples which are real-timeGoogle bigquery data types are shown clearlyCreation of tables and views are covered with real-time examplesInserting Record into a table is shown.I am going to cover all google bigquery sql statements.The course is packed with multiple real-time google bigquery examples.Note: This course is about Google BigQuery but it will also help you to learn SQL which can be used on Microsoft SQL Server, Oracle, MySql, PostgreSQL, SQLite, DB2, etc.Certification:Once you complete the course, you will get a course completion “Google Bigquery Certification” by Udemy


Section 1: Introduction

Lecture 1 Introduction

Lecture 2 What is Google BigQuery and Why it is used?

Lecture 3 Setting up the BigQuery Sandbox account

Lecture 4 Explaining about Datasets and tables

Lecture 5 Uploading files from local to create tables under a dataset

Lecture 6 Overwrite a file

Lecture 7 Executing multiple Queries

Section 2: Retrieve the records

Lecture 8 SELECT Statement and SELECT DISTINCT

Lecture 9 SQL Code used

Lecture 10 CASE with SELECT Statement

Lecture 11 SQL Code used

Lecture 12 WHERE Clause and Comparison operator in WHERE Clause

Lecture 13 SQL Code used

Lecture 14 Logical Operators in WHERE Clause

Lecture 15 SQL Code used

Lecture 16 Copy Table to another table

Lecture 17 Arithmetic operators

Lecture 18 SQL Code used

Lecture 19 Order of execution with WHERE clause

Lecture 20 COUNT the rows from table

Lecture 21 SQL Code used

Section 3: Special Operators

Lecture 22 NULL and NOT NULL

Lecture 23 SQL Code used

Lecture 24 BETWEEN and NOT BETWEEN operator

Lecture 25 SQL Code used

Lecture 26 IN and NOT IN Operator

Lecture 27 SQL Code used

Lecture 28 LIKE Operator

Lecture 29 SQL Code used

Section 4: Sorting and grouping records

Lecture 30 ORDER BY Clause

Lecture 31 SQL Code used

Lecture 32 ORDER BY column position

Lecture 33 SQL Code used

Lecture 34 GROUP BY clause

Lecture 35 SQL Code used

Lecture 36 ORDER OF execution with GROUP BY and ORDER BY

Lecture 37 SQL Code used

Section 5: Google BigQuery SQL Functions

Lecture 38 Other Numerical functions

Lecture 39 SQL Code used

Lecture 40 String Functions

Lecture 41 SQL Code used

Lecture 42 Ltrim, rtrim, trim and strpos string functions

Lecture 43 SQL Code used

Lecture 44 replace, repeat, reverse and substr functions

Lecture 45 SQL Code used

Lecture 46 Date Functions in Google BigQuery

Lecture 47 SQL Code used

Lecture 48 Date Functions in Google BigQuery continued

Lecture 49 SQL Code used

Lecture 50 Strange behavior of BigQuery parser with GROUP BY and column Alias

Lecture 51 SQL Code used

Lecture 52 HAVING Clause

Lecture 53 SQL Code used

Section 6: Joins and Subqueries

Lecture 54 Subquery

Lecture 55 SQL Code used

Lecture 56 Subqueries as column expressions

Lecture 57 SQL Code used

Lecture 58 UNION ALL operator

Lecture 59 SQL Code used

Lecture 60 INTERSECT DISTINCT operator

Lecture 61 SQL Code used

Lecture 62 EXCEPT DISTINCT operator

Lecture 63 SQL Code used

Lecture 64 INNER JOIN – Theory

Lecture 65 INNER JOINs

Lecture 66 SQL Code used

Lecture 67 LEFT Join – Theory

Lecture 68 Note about next Lecture

Lecture 69 LEFT JOIN Example

Lecture 70 SQL Code used

Lecture 71 RIGHT JOIN

Lecture 72 SQL Code used

Lecture 73 FULL JOIN

Lecture 74 SQL Code used

Lecture 75 CROSS JOIN

Lecture 76 SQL Code used

Section 7: Derived Tables and CTE

Lecture 77 Derived Tables – Part 1

Lecture 78 SQL Code used

Lecture 79 Derived Tables – Part 2

Lecture 80 SQL Code used

Lecture 81 Creating 2 tables using CSV for Project 1

Lecture 82 Get productid, Total Qty and profit using INNER JOIN and GROUP BY

Lecture 83 SQL Code used

Lecture 84 Getting the same result using derived tables

Lecture 85 SQL Code used

Lecture 86 Apply HAVING Clause on derived tables

Lecture 87 SQL Code used

Lecture 88 Derived Table with CASE with SELECT statement – Task and Solution

Lecture 89 SQL Code used

Lecture 90 Project 2 – Load 3 tables

Lecture 91 CTE – Theory

Lecture 92 Write SQL Query to get businessentityid and full name

Lecture 93 Solution and CTE Example

Lecture 94 SQL Code used

Lecture 95 CTE Example with 2 Tables

Lecture 96 SQL Code used

Lecture 97 CTE Example with 3 Tables

Lecture 98 SQL Code used

Section 8: Arrays, UNNEST, Struct, etc.

Lecture 99 Project 3 – Arrays

Lecture 100 Arrays in BigQuery

Lecture 101 SQL Code used

Lecture 102 Write the same query using CTE

Lecture 103 SQL Code used

Lecture 104 UNNEST in Arrays

Lecture 105 SQL Code used

Lecture 106 UNNEST() with CROSS JOIN

Lecture 107 SQL Code used

Lecture 108 GENERATE_ARRAY() function

Lecture 109 SQL Code used

Lecture 110 GENERATE_DATE_ARRAY() Function

Lecture 111 SQL Code used

Lecture 112 ARRAY_LENGTH() function

Lecture 113 SQL Code used

Lecture 114 STRUCT() Function

Lecture 115 SQL Code used

Lecture 116 Multiple Struct Statements

Lecture 117 SQL Code used

Lecture 118 Multiple Struct statements as arrays

Lecture 119 SQL Code used

Lecture 120 Joining multiple rows in Struct statements which has arrays

Lecture 121 SQL Code used

Lecture 122 Save Results of the Query

Lecture 123 Save the Result and get the output as flat tables

Lecture 124 SQL Code used

Lecture 125 Assignment – Using Multiple UNNEST functions

Lecture 126 SQL Code used

Lecture 127 Using Multiple UNNEST functions using CTE

Lecture 128 SQL Code used

Lecture 129 Assignment – UNNEST Function with SUM function

Lecture 130 SQL Code used

Lecture 131 ARRAY_AGG() Function

Lecture 132 SQL Code used

Lecture 133 Assignment – ARRAY_AGG() Function multiple times

Lecture 134 SQL Code used

Section 9: Final Project and Queries

Lecture 135 Project using bigquery-public-datasets

Lecture 136 Assignment – Analyzing the GA data using SELECT statement, group by, etc.

Lecture 137 SQL Code used

Lecture 138 Selecting Records for all the dates – not by partition.

Lecture 139 SQL Code used

Lecture 140 UNNEST multiple levels – Contains Assignment

Lecture 141 SQL Code used

Lecture 142 Exporting the BigQuery Data to Google Data Studio

Lecture 143 Keyboard Shortcuts in BigQuery

Lecture 144 SQL Dialects in BigQuery

Lecture 145 Optional – Identity and Access Management

Section 10: Create Tables

Lecture 146 Available Data types in BigQuery

Lecture 147 CREATE Table Statement

Lecture 148 SQL Code used


Lecture 150 SQL Code used

Lecture 151 CREATE TABLE with NOT NULL and Partition

Lecture 152 SQL Code used

Section 11: Views

Lecture 153 CREATE VIEWS

Lecture 154 SQL Code used


Lecture 156 SQL Code used

Lecture 157 Dropping a view

Lecture 158 SQL Code used

Section 12: Insert Records

Lecture 159 CREATE TABLE with columns manually

Lecture 160 INSERT Statement

Lecture 161 SQL Code used

Section 13: Bonus Section – Thank You

Lecture 162 Bonus Lesson : Let us stay connected

A person who analyses the data regularly,Digital marketers,Data Scientists,Software Engineers,Professional who works on Google Cloud,Campaign Managers,Social Media aspirants/experts,SEO/SEM Managers,Who wants to master SQL using Big Query,Software Developers,Anyone who analyses Google Analytics data

Course Information:

Udemy | English | 8h 31m | 4.02 GB
Created by: Sandeep Kumar

You Can See More Courses in the Business >> Greetings from

New Courses

Scroll to Top