The Complete Google Bigquery & Data Analysis Course 2022
Last updated 12/2021
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 988.25 MB | Duration: 4h 8m

The Simple Guide to Google BigQuery & Data Analysis: Learn from a Fortune 10 Professional
What you'll learn
Knowledge of all the essential SQL commands in BigQuery
Learn sorting and filtering in SQL
Proficiency if GROUPBY, JOINS and subqueries
Hands-on example based exercises to solidify your knowledge
Requirements
Just a PC with a web browser
Description
I'm a Senior Analyst working for a Fortune 10 company, and I made this course to help others discover the power of BigQuery. Join me in this journey where take your through Google BigQuery and SQL step-by-step teaching you through practical examples and datasets. Why should you take this course?I have designed every lecture myself to make it accessible to everyone and have focused on teaching the fundamentals of SQL and Google BigQuery for anyone interested in Data analysis for business.The perfect introduction: This course covers the basics and intermediate level content for BigQuery, SQL and data analysis for beginners seeking a clear and practical introduction.Example-based learning. I believe that true education comes from practical application. This course is full of real datasets and dedicated lectures where you can join me in conducting analysis through examples.Downloadable datasets, and resources on SQL and Google BigQuery.Why choose my course?This course provides a hands-on and practical course aimed at beginners. The material can be covered at your own pace and has been designed to be of real use to people starting with BigQuery, SQL and data analysis.The Most Qualified Instructor?Why am I qualified to teach BigQuery? I work as a Senior Data Analyst for a Fortune 10 company and use BigQuery in my day-to-day work.Who is this course for?Any professional interested in learning, SQL, BigQuery or data analysis.Our primary focus is for business professional seeking an easy-to-understand course.Anyone interested in learning SQL through practical examples.Go ahead and click enroll button, if you don't love the course, a refund is always guaranteed.- Experiential Learning Team
Overview
Section 1: Introduction
Lecture 1 Introduction & Basics: Data, SQL and Google BigQuery
Lecture 2 Data Details: Data Types & Conceptualizing Table Structure
Lecture 3 How to Structure a Query and Order of Operations
Lecture 4 Getting Setup in BigQuery Sandbox
Section 2: Basic Queries
Lecture 5 Your First Query: Understanding the GBQ UI, SELECT, *, DISTINCT, Columns, & FRO
Lecture 6 The WHERE clause, AND, OR, =, IN() function & Exporting results
Lecture 7 Basic Aggregations: COUNT(), SUM(), AVG() & the GROUP BY Clause and Naming
Lecture 8 Practice Analysis Lesson