IT Certification


Serverless Data Analysis with Big Query on Google's Cloud

The Third Course in a Series for Attaining the Google Certified Data Engineer

4.20 (121 reviews)

Serverless Data Analysis with Big Query on Google's Cloud


1 hour


Jul 2017

Last Update
Regular Price

Exclusive SkillShare Offer
Unlimited access to 30 000 Premium SkillShare courses

What you will learn

At the end of this course you'll understand serverless data analysis and architecture.

At the end of this course you'll be one third of the way there, course wise, in preparing for the Google Certified Data Engineering Exam.

You'll be able to import data sets and use SQL to explore them with BigQuery.

When you've completed the course you'll be able to explain in detail why BigQuery is the fastest data warehouse in the world.


Welcome to Serverless Data Analysis with Big Query on Google's Cloud This is the second course in a series of courses designed to help you attain the coveted Google Certified Data Engineer. 

Additionally, the series of courses is going to show you the role of the data engineer on the Google Cloud Platform

At this juncture the Google Certified Data Engineer is the only real world certification for data and machine learning engineers.

Note: This is not a programmers course on BigQuery. The goal of this course and the entire series of courses is to provide students with the foundation of the services you'll need to know for the Google Certified Data Engineering Exam. 

Because SQL is a prerequisite for the course this course is mostly lecture. Don't let that lull to sleep though, this service is heavily covered on the exam

BigQuery is Google's fully managed, petabyte scale, low cost enterprise data warehouse for analytics. BigQuery is serverless. There is no infrastructure to manage and you don't need a database administrator, so you can focus on analyzing data to find meaningful insights using familiar SQL. 

We are in a data revolution. Data used to be viewed as a simple necessity and lower on the totem pole. Now it is more widely recognized as the source of truth. As we move into more complex systems of data management, the role of the data engineer becomes extremely important as a bridge between the DBA, developer and the data consumer. Beyond the ubiquitous spreadsheet, graduating from RDBMS (which will always have a place in the data stack), we now work with NoSQL and Big Data technologies.

Most cloud computing vendors are moving to a serverless architecture. What's serverless?  Serverless is about abstracting users away from servers, infrastructure, and having to deal with low-level configuration or the core operating system. Instead, developers make use of single purpose services to execute code.

Imagine for a second being able to upload data into a storage bucket and then run SQL like queries against it. Many data analysts call this the grail to data analysis. With BigQuery, that's exactly what you do. There's no spinning up or configuring anything. You upload data in the form of a csv or json file and an query against it. I don't mean a hundred thousand rows. I mean a billion. 

                                                           *Five Reasons to take this Course.*

1) You Want to be a Data Engineer 

It's the number one job in the world. (not just within the computer space) The growth potential career wise is second to none. You want the freedom to move anywhere you'd like. You want to be compensated for your efforts. You want to be able to work remotely. The list of benefits goes on. 

2) The Google Certified Data Engineer 

Google is always ahead of the game. If you were to look back at at timeline of their accomplishments in the data space you might believe they have a crystal ball. They've been a decade ahead of everyone.  Now, they are the first and the only cloud vendor to have a data engineering certification. With their track record I'll go with Google. 

3) The Growth of Data is Insane 

Ninety percent of all the world's data has been created in the last two years. Business around the world generate approximately 450 billions transactions a day. The amount of data collected by all organizations is approximately 2.5 Exabytes a day. That number doubles every month. 

4) The Data Revolution is Here

We are in a data revolution. Data used to be viewed as a simple necessity and lower on the totem pole. Now it is more widely recognized as the source of truth. As we move into more complex systems of data management, the role of the data engineer becomes extremely important as a bridge between the DBA and the data consumer.

5) You want to be ahead of the Curve 

The data engineer role is fairly new.  While your learning, building your skills and becoming certified you are also the first to be part of this burgeoning field.  You know that the first to be certified means the first to be hired and first to receive the top compensation package. 

Thank you for your interest in Serverless Data Analysis with Big Query on Google's Cloud and we will see you in the course!!




What's in the Course?

Instructor Course Q&A

The Data Engineer

The Serverless Revolution



BigQuery Overivew

Why BigQuery?

SQL on BigQuery

Columnar Storage

Structured Data Storage

Getting Data into BigQuery

Massively Parallel

Global Namespace

Asynchronous Job Manager

What BigQuery Isn't



BigQuery Basics

Section Assumptions

BigQuery Abstraction Model

Query Editor Overview

Running and Saving Our Queries

Query Visibility

Upload Customer Dataset

Naming Conventions

Export Data with Cloud Shell

3 Categories of BigQuery Pricing

BigQuery Data Durability

Reserved Capacity



Queries on BigQuery

Simple Query

Query Anatomy

Simple Join

Inner Join



Cross Table Field Joins



Advanced Features

Advanced Subquery

Using Contains

Windowing Functions





Martin26 March 2020

I would have liked more examples/further discussion on moving data in and out of big query. May be outdated as did not address BI Engine, Reservation, Transfers.

Shashank21 December 2019

It is not even suitable for beginners. Very low level of information which known by everyone who even studied in higher secondary SQL

McHbmn5 November 2019

A touch outdated, doesn't get into "views" and other functionalities of BigQuery, but sufficient nonetheless

Conroy13 March 2019

A good intro to the topic. But to pass the exam you need to dive much deeper to every single piece of detail, including troubleshooting and choosing the best option out of several possible options.

Rashid29 January 2019

Issue playing Sec 7.2 and 7.10 and many others giving up on section 3 until i get a resolution i have tried different pcs and browsers same flash issue error message ...This "resolved" its self and I was able to continue through the course. But I am afraid this one was a little bit rushed. But I got enough out of it to write simple queries and build from there. It does help to know SQL first.

Sergio20 January 2019

Básico, da lo que promete. Los subtítulos en inglés están incorporados fonéticamente, así que las palabras no suelen corresponder con la locución.

Lucas7 November 2018

Podiam existir legendas na minha língua. Ou já que não temos, as legendas em inglês podiam não ser automáticas com vários erros. Podia ser um pouco mais lento também.

James2 August 2018

a great overview of BQ with clear explanations on how to structure the query.. more importantly highlights some of the SQL constraints .. thanks Mike..

Kenneth2 August 2018

Mike West is clear and concise. You leave a message and it's returned right away. You can tell he likes teaching and is interested in the subject material. You get a lot here for your money.

Kenneth1 May 2018

While the material is well done and teaches about the Google Cloud products, I don't think it is actually going to help with taking the Google Data Engineer certification exam. I have taken it once already and the exam seems to be more oriented towards best practices and industry standards.

Valentina14 October 2017

This course increased my knowledge of Big Query. Specifically, I enjoyed the details that the instructor provides especially when he completes a "show-and-tell" example, by showing the actual service in the console. As well, the details for the query portion were very helpful. He explained all the code including the functionality for each clause. Mike is very engaging and explains everything well. I am looking forward to the next course.

Anand7 September 2017

Lectures along with the practical usecases on Bigquery were very informative. Looking forward for next set of courses in the Data Engineer track.

Julie26 August 2017

Another Excellent course from an Brilliant Instructor.Really well explained, and precisely the right amount of information.Mark provide a clear and concise explanations, have deep subject knowledge Google Cloud.


Udemy ID


Course created date


Course Indexed date
Course Submitted by