Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Serverless Data Analysis with Big Query on Google's Cloud
Rating: 4.0 out of 5(125 ratings)
783 students

Serverless Data Analysis with Big Query on Google's Cloud

The Third Course in a Series for Attaining the Google Certified Data Engineer
Created byMike West
Last updated 7/2017
English

What you'll 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.

Course content

5 sections42 lectures1h 13m total length
  • Introduction1:33

    In this lesson let's high level what this course is about. 

    This is the same video as the course preview. 

  • What's in the Course?2:11

    Let's talk about what you are going to learn in the course. 

    This course is all about one cloud service in Google's cloud called BigQuery. 

  • Instructor Course Q&A1:41

    In this lesson I'll try to answer some questions that are specific about the course. 

  • The Data Engineer3:13

    In this lesson let's define the data engineer. 

    What do they do all day? 

    How can you become one? 

  • The Serverless Revolution2:10

    Serverless simply means that the hardware is abstracted away from us. 

    With BigQuery, this means all we do is log into the console, upload some data and write a SQL query. 

    There's no hardware we have to configure. 

  • Summary0:24
  • Quiz

Requirements

  • You should have taken the first two courses in the series for attaining the Google Certified Data Engineer.
  • You should be very comfortable with SQL. (any flavor)
  • It will be very helpful if you come from a data background.

Description

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

Who this course is for:

  • If you following along and are ready to tackle the third course in this series then this course is for you.
  • You want to be a Google Certified Data Engineer.
  • You need to know how to use BigQuery.