Home

All courses

The Complete Google BiqQuery Masterclass: Beginner to Expert

Business

Business Intelligence

Business Analytics & Intelligence

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.

4.3

(1222)

8316 enrolled on this course

Last updated 11/2021

None

₹ 3099.0

₹ 4599.0

Buy Now

30-Day Money-Back Guarantee

Lessons

Quizzes

Duration

13 Hours

Skill level

Beginner

Language

English

Certificate

Yes

Full lifetime access

Yes

Description

'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 BigQuery
Digital Marketers will be able to create their own analysis sheet
Students will be expert in arrays, UNNEST, STRUCT, CTE, Derived Tables, etc
Master all the concepts of SQL in BigQuery
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 a real-time project helps students to apply the concepts in his job
Helps the students to be Job ready in Google BigQuery
Bigquery 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 course
Is 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 level
Once 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 Query
If 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 analytics
What is google bigquery?
How to use google bigquery
Complete Google bigquery tutorial and course which covers everything step by step
You can easily analyze the google bigquery public datasets
Master the
datasets
and
tables
in BigQuery
Upload files from multiple ways to table
All major
SQL Statements
in Google Big Query like below -
Different
SELECT
Statements
SELECT statements with
conditions
Filter
the Records in Google Big Query
Copy records
from one table to another table in Big Query
All the major numerical, Date, and String Functions of SQL with
functions which are only present in Big Query
You will master all the
special operators
Joins
,
SubQueries, UNIONs
are covered in detail
CTE
and
Derived table
s are explained beautifully with a lot of examples
Find a
pattern
of records in Google Big Query
I have explained the concepts of
Arrays
,
Struct
,
UNNEST
, etc in detail which you will not find in any other course
All the major functions which are exclusively available in Google BigQuery is covered with easy-going examples which are real-time
Google bigquery data types
are shown clearly
Creation
of tables and views are covered with real-time examples
Inserting
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
Who this course is for:
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

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

Requirements

You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
No previous design experience is needed.
No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures

Expand All Sections

1-Introduction

1.1-Introduction

1.2-What is Google BigQuery and Why it is used?

1.3-Setting up the BigQuery Sandbox account

1.4-Explaining about Datasets and tables

1.5-Uploading files from local to create tables under a dataset

1.6-Overwrite a file

1.7-Executing multiple Queries

2-Retrieve the records

2.1-SELECT Statement and SELECT DISTINCT

2.2-SQL Code used

2.3-CASE with SELECT Statement

2.4-SQL Code used

2.5-WHERE Clause and Comparison operator in WHERE Clause

2.6-SQL Code used

2.7-Logical Operators in WHERE Clause

2.8-SQL Code used

2.9-Copy Table to another table

2.10-Arithmetic operators

2.11-SQL Code used

2.12-Order of execution with WHERE clause

2.13-COUNT the rows from table

2.14-SQL Code used

3-Special Operators

3.1-NULL and NOT NULL

3.2-SQL Code used

3.3-BETWEEN and NOT BETWEEN operator

3.4-SQL Code used

3.5-IN and NOT IN Operator

3.6-SQL Code used

3.7-LIKE Operator

3.8-SQL Code used

4-Sorting and grouping records

4.1-ORDER BY Clause

4.2-SQL Code used

4.3-ORDER BY column position

4.4-SQL Code used

4.5-GROUP BY clause

4.6-SQL Code used

4.7-ORDER OF execution with GROUP BY and ORDER BY

4.8-SQL Code used

5-Google BigQuery SQL Functions

5.1-Other Numerical functions

5.2-SQL Code used

5.3-String Functions

5.4-SQL Code used

5.5-Ltrim, rtrim, trim and strpos string functions

5.6-SQL Code used

5.7-replace, repeat, reverse and substr functions

5.8-SQL Code used

5.9-Date Functions in Google BigQuery

5.10-SQL Code used

5.11-Date Functions in Google BigQuery continued

5.12-SQL Code used

5.13-Strange behavior of BigQuery parser with GROUP BY and column Alias

5.14-SQL Code used

5.15-HAVING Clause

5.16-SQL Code used

6-Joins and Subqueries

6.1-Subquery

6.2-SQL Code used

6.3-Subqueries as column expressions

6.4-SQL Code used

6.5-UNION ALL operator

6.6-SQL Code used

6.7-INTERSECT DISTINCT operator

6.8-SQL Code used

6.9-EXCEPT DISTINCT operator

6.10-SQL Code used

6.11-INNER JOIN - Theory

6.12-INNER JOINs

6.13-SQL Code used

6.14-LEFT Join - Theory

6.15-Note about next Lecture

6.16-LEFT JOIN Example

6.17-SQL Code used

6.18-RIGHT JOIN

6.19-SQL Code used

6.20-FULL JOIN

6.21-SQL Code used

6.22-CROSS JOIN

6.23-SQL Code used

7-Derived Tables and CTE

7.1-Derived Tables - Part 1

7.2-SQL Code used

7.3-Derived Tables - Part 2

7.4-SQL Code used

7.5-Creating 2 tables using CSV for Project 1

7.6-Get productid, Total Qty and profit using INNER JOIN and GROUP BY

7.7-SQL Code used

7.8-Getting the same result using derived tables

7.9-SQL Code used

7.10-Apply HAVING Clause on derived tables

7.11-SQL Code used

7.12-Derived Table with CASE with SELECT statement - Task and Solution

7.13-SQL Code used

7.14-Project 2 - Load 3 tables

7.15-CTE - Theory

7.16-Write SQL Query to get businessentityid and full name

7.17-Solution and CTE Example

7.18-SQL Code used

7.19-CTE Example with 2 Tables

7.20-SQL Code used

7.21-CTE Example with 3 Tables

7.22-SQL Code used

8-Arrays, UNNEST, Struct, etc.

8.1-Project 3 - Arrays

8.2-Arrays in BigQuery

8.3-SQL Code used

8.4-Write the same query using CTE

8.5-SQL Code used

8.6-UNNEST in Arrays

8.7-SQL Code used

8.8-UNNEST() with CROSS JOIN

8.9-SQL Code used

8.10-GENERATE_ARRAY() function

8.11-SQL Code used

8.12-GENERATE_DATE_ARRAY() Function

8.13-SQL Code used

8.14-ARRAY_LENGTH() function

8.15-SQL Code used

8.16-STRUCT() Function

8.17-SQL Code used

8.18-Multiple Struct Statements

8.19-SQL Code used

8.20-Multiple Struct statements as arrays

8.21-SQL Code used

8.22-Joining multiple rows in Struct statements which has arrays

8.23-SQL Code used

8.24-Save Results of the Query

8.25-Save the Result and get the output as flat tables

8.26-SQL Code used

8.27-Assignment - Using Multiple UNNEST functions

8.28-SQL Code used

8.29-Using Multiple UNNEST functions using CTE

8.30-SQL Code used

8.31-Assignment - UNNEST Function with SUM function

8.32-SQL Code used

8.33-ARRAY_AGG() Function

8.34-SQL Code used

8.35-Assignment - ARRAY_AGG() Function multiple times

8.36-SQL Code used

9-Final Project and Queries

9.1-Project using bigquery-public-datasets

9.2-Assignment - Analyzing the GA data using SELECT statement, group by, etc.

9.3-SQL Code used

9.4-Selecting Records for all the dates - not by partition.

9.5-SQL Code used

9.6-UNNEST multiple levels - Contains Assignment

9.7-SQL Code used

9.8-Exporting the BigQuery Data to Google Data Studio

9.9-Keyboard Shortcuts in BigQuery

9.10-SQL Dialects in BigQuery

9.11-Optional - Identity and Access Management

10-Create Tables

10.1-Available Data types in BigQuery

10.2-CREATE Table Statement

10.3-SQL Code used

10.4-CREATE IF NOT EXISTS and CREATE OR REPLACE TABLE

10.5-SQL Code used

10.6-CREATE TABLE with NOT NULL and Partition

10.7-SQL Code used

11-Views

11.1-CREATE VIEWS

11.2-SQL Code used

11.3-CREATE or REPLACE VIEW or CREATE VIEW IF NOT EXISTS

11.4-SQL Code used

11.5-Dropping a view

11.6-SQL Code used

12-Insert Records

12.1-CREATE TABLE with columns manually

12.2-INSERT Statement

12.3-SQL Code used

13-Bonus Section - Thank You

13.1-Bonus Lesson : Let us stay connected

Course Categories

Popular Courses

The Complete Google BiqQuery Masterclass: Beginner to Expert

Description

What you'll learn

Requirements

Course Content

You May Like