Learn SQL for Data Analysis with Google Big Query (Udemy.com)

Learn SQL using Google's scalable analytics data warehouse. Super charge your data analysis skills with BigQuery

( 35 Reviews )

Created by: Annabel Lyle

Produced in 2022

What you will learn

Use SQL for Data Analysis
Navigate the BigQuery User Interface & Key Features
Export Data in a range of formats
Range of SQL statement e.g SELECT, WHERE, ORDER BY, GROUP BY and more
Join multiple tables together with JOIN and LEFT JOIN
Range of SQL Analytics Functions e.g MIN(), MAX(), AVG(), SUM(), COUNT() and more
All hosted online. Access Google BigQuery with google account

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 82 / 100

Live Chat with CourseDuck's Co-Founder for Help

Need help deciding on a google analytics course? Or looking for more detail on Annabel Lyle's Learn SQL for Data Analysis with Google Big Query? Feel free to chat below.

Join CourseDuck's Online Learning Discord Community

Course Description

Learn how to use SQL with BigQuery quickly and effectively with this course!
You'll learn how to read and write complex queries to a database using one of the most in demand skills and one of the most powerful databases: Google BigQuery.
In this course you will learn:

How to Navigate the BigQuery User Interface and its key features
How to write SQL syntax including a range of statements and functions to query your data sets.
Transferable SQL Skills that can be used with any SQL database (Whether you'll be using Bigquery or another database such as MySQL or Postgresql)
How to export your data for a varied range of use cases after you have completed your analysis.

Learning SQL is one of the fastest ways to improve your career prospects as it is one of the most in demand tech skills and one of the most important skills as a Data Analyst.
Check out the free preview videos for more information!
Who this course is for:

Data Analysts
Data Scientists
Engineers
Anyone interested in learning more about SQL, BigQuery or data analysis

As a Data Scientist with over 6 years of experience in Data Analytics, I look forward to introducing you to the world of analytics and SQL with Google BigQuery.Who this course is for:

Data Analysis
Data Scientist
Engineer
Anyone who wants to learn SQL or Data Analysis!

Time: 2h

*Some courses are excluded from this sale. Coupon not working? If the link above doesn't drop prices, clear the cookies in your browser and then click this link here.
Also, you may need to apply the coupon code directly on the cart page to get the discount.

Coupon Code

Instructor Details

Annabel Lyle

4.1 Rating
35 Reviews

My name is Annabel and I have over 5 years of experience as a Data Analyst within Marketing and Product Teams. I have also mentored and taught individuals and teams how to get the most out of a range of data visualisation tools, to ensure they have the greatest impact. My expertise is in storytelling with data, data visualisation and data analysis. Key tools that I teach and work with include Data Studio, Google Analytics, Google Tag Manager and R Studio.

Reviews

4.1

35 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Ruxpol Thongma on

Great explanation step-by-step for my first BigQuery

By Alexey on

??????? ????????????? ???? ? ?????? ? Google BigQuery, ?? ? ????? ?????? ????????????? ? ?????????? ?????? ?? Firebase)

By Cody Hartwich on

Very informative and thorough. Step by step instructions and examples were helpful in learning the material.

By Pallapothu tirupathinaidu on

Almost basic commands explained with examples feels better to improve

By Pat Kolar on

I have worked with Oracle SQL so it was a bit elementary for me. But I did learn how to use the Big Query tool and the differences between standard SQL and Oracle SQL, so it wasn't a waste of time. I think the pace would have been good if i hadn't used SQL before.

By Leslie McHugh on

Lots of great info and presented in an easy-to-follow kind of way. However, in some of the sessions (6 and & specifically), the picture was so fuzzy it was completely illegible. The last section about Data Studio seems to cut off midsentence and the course just ends.

By Danilo Gonalves on

It wasn't a good match for me cause I'm only watching to get an general idea of how Google Bigquery works. Nonetheless, I like the "teacher" very much. Good for beginners

By Dobromira Vasileva on

great quick starter to basic operations; for more sophisticated data analysis, maybe a more detailed course should follow after this one

By German Capuano on

It was a good summary of the basics. I would have liked a large example or something more challenging at the end.

By Pira Seligman C on

I like how she explained it, easy to follow and you can run some good queries after this course :)

By YenChing Tan on

I really benifited from the course. The explanation is clear with step-by-step demonstration.

By Thomas Schultz-Wenk on

My first contact with Big Query (SQL). The lessons are short and on point, very easy to understand!I would say that 95% of the questions I had during the course were clarified.I would like to learn the next steps. BigQueryML would be awesome!