Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

The Complete Google BiqQuery Masterclass: Beginner to Expert

Name: The Complete Google BiqQuery Masterclass: Beginner to Expert
Rating: 4.4 (1432 reviews)

Master Google BigQuery Analytics with SQL used in Big Query to analyze Real data for data scientists, Developers, etc.

Bestseller

Created bySandeep Kumar

Last updated 4/2022

English

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

Course content

13 sections • 162 lectures • 8h 30m total length

Introduction3:15
What is Google BigQuery and Why it is used?2:55
Setting up the BigQuery Sandbox account6:31
Explaining about Datasets and tables6:21
Uploading files from local to create tables under a dataset11:12
Overwrite a file2:15
Learn how to overwrite or append data in a BigQuery table by uploading new files, selecting overwrite in advanced options, and choosing append to add rows.
Executing multiple Queries4:14

SELECT Statement and SELECT DISTINCT4:16
Master selecting all or specific columns with select star and select distinct in BigQuery, using project.dataset.table syntax to query data and retrieve unique records.
SQL Code used0:05
CASE with SELECT Statement5:16
SQL Code used0:09
WHERE Clause and Comparison operator in WHERE Clause6:14
Learn to filter records with the where clause using comparison operators—equal to, not equal to, greater than, less than, and their inclusive forms—through practical examples.
SQL Code used0:13
Logical Operators in WHERE Clause5:58
SQL Code used0:16
Copy Table to another table3:54
Arithmetic operators9:42
SQL Code used0:16
Order of execution with WHERE clause2:14
COUNT the rows from table4:49
SQL Code used0:02

Other Numerical functions6:23
SQL Code used0:10
String Functions6:47
Explore string functions in Google BigQuery, including split, length, and concat. Apply lower and upper, see practical examples with name and account number, and learn nesting techniques.
SQL Code used0:17
Ltrim, rtrim, trim and strpos string functions5:08
SQL Code used0:09
replace, repeat, reverse and substr functions5:17
SQL Code used0:08
Date Functions in Google BigQuery9:02
SQL Code used0:21
Date Functions in Google BigQuery continued6:02
Master extracting date parts with the extract function and constructing dates with the date function, using parts like day, week, month, quarter, and year, including date time.
SQL Code used0:07
Strange behavior of BigQuery parser with GROUP BY and column Alias3:49
Explore the strange behavior of the Google BigQuery parser with group by and column aliases, showing that select aliases can be used in group by despite apparent execution order.
SQL Code used0:07
HAVING Clause5:57
SQL Code used0:20

Subquery5:54
SQL Code used0:12
Subqueries as column expressions5:45
Learn subqueries as column expressions in BigQuery to obtain purchase order id and tax amount from the header, plus total order quantity from the detail table with grouping and aliases.
SQL Code used0:04
UNION ALL operator8:32
Master the union all operator, which joins rows from multiple select statements without removing duplicates. Understand the column and data type requirements and how to combine results across tables.
SQL Code used0:08
INTERSECT DISTINCT operator2:56
SQL Code used0:06
EXCEPT DISTINCT operator3:05
Learn how the except distinct operator compares records across tables and returns the distinct rows from the first query that do not appear in the others, with practical examples.
SQL Code used0:05
INNER JOIN - Theory3:11
INNER JOINs5:29
SQL Code used0:09
LEFT Join - Theory3:45
Note about next Lecture0:10
LEFT JOIN Example10:03
SQL Code used0:12
RIGHT JOIN3:37
SQL Code used0:10
FULL JOIN5:23
SQL Code used0:03
CROSS JOIN4:39
SQL Code used0:05

Derived Tables - Part 15:27
SQL Code used0:05
Derived Tables - Part 23:02
SQL Code used0:10
Creating 2 tables using CSV for Project 15:53
Get productid, Total Qty and profit using INNER JOIN and GROUP BY5:25
SQL Code used0:11
Getting the same result using derived tables7:14
SQL Code used0:14
Apply HAVING Clause on derived tables3:32
SQL Code used0:16
Derived Table with CASE with SELECT statement - Task and Solution9:06
SQL Code used0:28
Project 2 - Load 3 tables2:02
CTE - Theory2:31
Write SQL Query to get businessentityid and full name1:07
Solution and CTE Example4:26
Use concat to form a name from first, middle, and last names, and compare a query with a with clause CTE on the person table, ordered by business entity ID.
SQL Code used0:07
CTE Example with 2 Tables11:38
SQL Code used0:16
CTE Example with 3 Tables5:45
SQL Code used0:15

Project 3 - Arrays0:56
Arrays in BigQuery10:10
SQL Code used0:11
Write the same query using CTE1:28
SQL Code used0:11
UNNEST in Arrays3:39
Discover how to use the unnest function to turn array items into separate rows. Flatten nested data into flat tables and observe how row counts increase.
SQL Code used0:03
UNNEST() with CROSS JOIN4:59
SQL Code used0:12
GENERATE_ARRAY() function2:54
SQL Code used0:02
GENERATE_DATE_ARRAY() Function3:28
SQL Code used0:09
ARRAY_LENGTH() function1:18
SQL Code used0:02
STRUCT() Function4:12
SQL Code used0:11
Multiple Struct Statements2:52
SQL Code used0:07
Multiple Struct statements as arrays7:48
Learn to build semi-structured data by combining multiple struct statements into arrays, mapping the computer science stream to students and their courses with aliases and nested structs.
SQL Code used0:07
Joining multiple rows in Struct statements which has arrays4:21
SQL Code used0:18
Save Results of the Query4:05
Save the Result and get the output as flat tables4:04
SQL Code used0:14
Assignment - Using Multiple UNNEST functions9:36
SQL Code used0:11
Using Multiple UNNEST functions using CTE4:08
SQL Code used0:09
Assignment - UNNEST Function with SUM function5:14
SQL Code used0:28
ARRAY_AGG() Function11:15
SQL Code used0:24
Assignment - ARRAY_AGG() Function multiple times8:52
Master using array_agg to create nested arrays with struct fields, derive a table alias, and aggregate stream, name, roll number, and courses into a single result.
SQL Code used0:31

Project using bigquery-public-datasets7:31
Explore the BigQuery public data project by loading a large Google Analytics sample dataset, navigate nested record fields like traffic source and hits, and practice querying operations on underscore sessions.
Assignment - Analyzing the GA data using SELECT statement, group by, etc.8:42
Group g_sessions by channel grouping and traffic source in BigQuery. Sum total hits, page views, and time on site, filtering non-null transaction revenue and positive time, order by hits, descending.
SQL Code used0:07
Selecting Records for all the dates - not by partition.2:18
SQL Code used0:07
UNNEST multiple levels - Contains Assignment15:17
SQL Code used0:34
Exporting the BigQuery Data to Google Data Studio6:20
Keyboard Shortcuts in BigQuery2:18
SQL Dialects in BigQuery3:41
Optional - Identity and Access Management5:32

Requirements

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.

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 tables 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

The Complete Google BiqQuery Masterclass: Beginner to Expert

What you'll learn

Explore related topics

Course content

Introduction7 lectures • 37min

Retrieve the records14 lectures • 43min

Special Operators8 lectures • 20min

Sorting and grouping records8 lectures • 23min

Google BigQuery SQL Functions16 lectures • 50min

Joins and Subqueries23 lectures • 1hr 4min

Derived Tables and CTE22 lectures • 1hr 9min

Arrays, UNNEST, Struct, etc.36 lectures • 1hr 39min

Final Project and Queries11 lectures • 52min

Create Tables7 lectures • 29min

Requirements

Description

Who this course is for: