Learn SQL for Data Analysis with Google Big Query

Name: Learn SQL for Data Analysis with Google Big Query
Rating: 4.4 (2279 reviews)

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

(2,279 ratings)

7,596 students

Created by Annabel Lyle

Last updated 9/2019

English

English [Auto]

What you'll 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

Requirements

No prior SQL or database knowledge required!

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!

Featured review

Ramesh M.

16 courses

7 reviews

a year ago

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.

Annabel Lyle

Data Analyst - Data Studio & Google Analytics

4.3 Instructor Rating
4,348 Reviews
16,119 Students
4 Courses

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.