Skip to content
UdemyGoogle AnalyticsPaid courseBeginner levelCertificate

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

Created by: Annabel Lyle

Last updated September 2019

icon
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

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 86 / 100

icon
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.

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Annabel Lyle

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.

icon
More courses by Annabel Lyle

$10.99

$11.99

$49.99

icon
More Google Analytics courses

$79.99

$79.99

$74.99

$59.99

$84.99

$79.99

icon
Reviews

4.3

3,834 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Chinmay Bhulkar on 9/5/2024

This course served as a great refresher for SQL, highlighting how its capabilities extend beyond just Google BigQuery. I appreciated the concise lessons on each topic, especially the step-by-step walk throughs that allowed for hands-on practice. Having already worked with Data Studio, this course helped me see how BigQuery can be effectively integrated with Data Studio to enhance its power and functionality.

By Cameron Zuniga on 6/29/2022

Overall, I think this is great course for someone with a SQL background who is unfamiliar with the interface of BigQuery. The intro videos helped me tremendously with getting acquainted with BigQuery. The remaining videos are concise and cover basic SQL syntax. Since they are to the point, I don't think this course is ideal for someone without a background in SQL.

By Anonymized User on 5/29/2022

The only issue I had in the sandbox was that the bigquery-public-data project would not appear. I selected +Add Data then Explore Public Datasets, searched for "cycle," selected London Bicycle Hires, then View Dataset. I also tried this with other public datasets and still no luck in the sandbox. This did not populate the bigquery-public-data project on the left menu of the screen and I was unable to manually search for this project either. Therefore, I was unable to follow along in the sandbox.

By Kevin Carpenter on 3/28/2022

Annabel does an excellent job at explaining the basic functionality and syntax of Google Big Query. As a beginner in SQL and Big Query, I found that the course gave me a solid foundation of the most commonly used functions that I can now try out for myself with my own data. Many thanks, Annabel! :)

By Ramesh Manickavel on 2/6/2021

It's a great refresher for SQL (which can be leveraged beyond Google Big Query). I liked the short lessons for each topic with a walk-through (which helped in parallel hands-on). Since I have already explored Data Studio, this course helped me in combining the power of BigQuery with Data Studio.

By Prathmesh Chourey on 1/13/2021

I have been long waiting to learn SQL but was apprehensive as I didnt have any background in coding. But this lecture series is so detailed and hits the very basics through which one can learn SQL at ease. I am glad i opted for this course.

By Xavier Gilbert on 8/30/2020

+ Good course, good introduction to big query and SQL + Good starter - Throwing exercises and saying "just go to Q&A" is a bit easy - A bit overselling on the "write complex queries", this should be more fairly marketed as an introductory course. - Big query is only here as an easy setup for SQL querying, and if data export is covered, data import isn't

By Mayank Agrawal on 3/14/2020

Whole course is Average even for beginners. Some more topics could have been covered in this session like creating tables using different methods such as using existing query and storing the table in temporary table, how to create and use temporary tables in BigQuery etc. I hope if there is any plan to update the course then above topics would also be covered in that update. After that this could be a whole lot better course for beginners.

By Ryan Hauk on 8/14/2019

Good introductory course that just scratches the very top surface. I wish there was more content because it was helpful. In comparison to some other courses I've purchased, it's overpriced. I've spent the same amount on other large courses and they easily have 10 times the content and are updating it regularly. That's not to say this course is bad, just wish it had more content to offer because it was good. I'm hopeful the author produces more content and releases some new sections.

By Thomas Schultz-Wenk on 7/9/2019

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!

Showing all 10 reviews on CourseDuck

Read all 3,834 reviews on Udemy