4.20 (121 reviews)
☑ 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
SQL on BigQuery
Structured Data Storage
Getting Data into BigQuery
Asynchronous Job Manager
What BigQuery Isn't
BigQuery Abstraction Model
Query Editor Overview
Running and Saving Our Queries
Upload Customer Dataset
Export Data with Cloud Shell
3 Categories of BigQuery Pricing
BigQuery Data Durability
Queries on BigQuery
Cross Table Field Joins
GROUP EACH BY
COUNT DISTINCT Behavior
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.
It is not even suitable for beginners. Very low level of information which known by everyone who even studied in higher secondary SQL
A touch outdated, doesn't get into "views" and other functionalities of BigQuery, but sufficient nonetheless
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.
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.
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.
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.
a great overview of BQ with clear explanations on how to structure the query.. more importantly highlights some of the SQL constraints .. thanks Mike..
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.
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.
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.
Lectures along with the practical usecases on Bigquery were very informative. Looking forward for next set of courses in the Data Engineer track.
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.