The Complete Google BigQuery & Data Analysis Course 2022

Focused View

Experiential Learning,Pragmatic Institute

4:07:56

13 View

1 - Introduction

1 - Introduction & Basics Data SQL and Google BigQuery.mp4

05:03

2 - Data Details Data Types & Conceptualizing Table Structure.mp4

07:14

3 - How to Structure a Query and Order of Operations.mp4

05:45

4 - Christian-Boccaccio-TOTAL-STORE-SALES.csv

4 - Getting Setup in BigQuery Sandbox.mp4

15:38

2 - Basic Queries

5 - Your First Query Understanding the GBQ UI SELECT DISTINCT Columns & FRO.mp4

13:43

6 - The WHERE clause AND OR IN function & Exporting results.mp4

13:34

7 - Basic Aggregations COUNT SUM AVG & the GROUP BY Clause and Naming.mp4

15:31

8 - Practice Analysis Lesson 1 Part 1.mp4

14:43

9 - Practice Analysis Lesson 1 Part 2.mp4

11:37

3 - Arithmetic Operations and Case When Statements

10 - Arithmetic Operators.mp4

10:15

11 - CASE WHEN Statements BETWEEN.mp4

16:03

12 - Practice Analysis Lesson 2 Part 1.mp4

15:30

13 - Practice Analysis Lesson 2 Part 2 MIN MAX HAVING.mp4

21:41

4 - Joins Concats Unions and more

14 - Conceptualizing a Join.mp4

14:15

15 - Christian-Boccaccio-LY-SALES-TRANSACTION-RECORD.csv

15 - Christian-Boccaccio-TY-SALES-TRANSACTION-RECORD.csv

15 - JOINS & CONCAT.mp4

19:09

16 - UNIONS Subqueries CASTING ROUND & WITHCTE Statements.mp4

22:26

17 - Practice Analysis Lesson 3 Bringing It All Together.mp4

25:49

Description

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

Who is this for?

Beginners to Google BigQuery especially business professionals

People looking for a simple yet effective introduction to Google BigQuery

What You Need to Know?

Just a PC with a web browser

More details

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
Who this course is for:
Beginners to Google BigQuery especially business professionals
People looking for a simple yet effective introduction to Google BigQuery

User Reviews

Rating

average 0

Total votes0

Focused display

Experiential Learning is a pioneer in education. Our courses span a variety of topics with a primary focus on the latest technologies. Each of our instructors are experts in their domain with a proven track record of success. Our goal is to deliver quality education to the masses at affordable rates.

Pragmatic Institute

Instructor's Courses

Pragmatic Institute is a pioneer in education. Our courses span a variety of topics with a primary focus on the latest technologies. Each of our instructors are experts in their domain with a proven track record of success. Our goal is to deliver quality education to the masses at affordable rates.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.