SQL for Data Analysis with Google BigQuery

Name: SQL for Data Analysis with Google BigQuery
Rating: 4.5 (47 reviews)

Learn the most important language for Data Science

Created byData Driven School | +30 mil alunos

Last updated 1/2025

English

What you'll learn

Learn DQL (a subset of SQL)
Learn to perform queries in a Relational Database
Learn how a query is structured
Learn, IN PRACTICE, the main Commands and Operators of the Data Query Language
Learn Aggregation Functions
Learn JOINS, with examples for each case
Create an account on BigQuery and run queries on databases with SQL

Course content

3 sections • 36 lectures • 1h 40m total length

Instructor Introduction1:22
Course Dynamics1:14
Modules1:18
Master sql for data analysis with Google BigQuery through three modules: introduction and tool overview; BigQuery basics and table uploads; and core sql commands with joins and aggregations.
Tools, Tips, and Contact Information2:00

Definition2:34
Explore Google BigQuery, a serverless data warehouse for analyzing large data in the cloud, with fast queries and free quotas, plus integration with Google Sheets, Analytics, and Ads.
Signing up for BigQuery4:01
Platform Interface6:32
Explore the Google BigQuery interface, focusing on the left menu and BigQuery Studio to write SQL queries for analysis, manage projects, data sets, and tables, and run and save results.
Explanation of Some Tables We'll Use2:36
Explore five tables in a fictional e-commerce data set—customers, categories, products, items, and orders—learn relationships via primary and foreign keys, and how to upload to BigQuery.
Table Upload: Hands-On!3:16
Upload and organize data in Google BigQuery by creating a data set, uploading CSV tables, auto-detecting schemas, and preparing multiple tables for SQL queries.

Selection Commands and Operators (Theory)1:51
Explore SQL for data analysis in Google BigQuery. Learn SQL, operators, functions, and left, inner, right, and full joins, and recognize SQL as a declarative language with results as tables.
Selection Commands and Operators (Practical Class)3:53
Explore basic SQL queries in Google BigQuery by writing select statements, selecting specific columns, using string literals and arithmetic, and referring to tables with and without project identifiers using backticks.
Limit and Distinct (Practical Class)2:18
Operators: Arithmetic, Logical, Comparison, “is” (Theory)1:44
Operators: Arithmetic, Logical, Comparison, “is” (Practical Class)5:54
Explore arithmetic operations, comparison operators, the between operator, the like operator, the in operator, and handling null values in SQL with Google BigQuery.
Aliases: AS (Theory)1:15
Aliases: AS (Practical Class)2:37
Restriction Commands: WHERE (Theory)0:56
Restriction Commands: WHERE (Practical Class)2:24
Conditional Commands: IF, CASE, COALESCE (Theory)1:56
Conditional Commands: IF, CASE, COALESCE (Practical Class)3:21
Explore conditional expressions in SQL with Google BigQuery, using case statements, the if function, and coalesce to label categories, handle multiple conditions and null values in queries.
Grouping and Sorting Commands: GROUP BY, ORDER BY (Theory)1:54
Grouping and Sorting Commands: GROUP BY, ORDER BY (Practical Class)3:11
Aggregation Functions: COUNT, MAX, MIN, SUM, AVG (Theory)1:27
Learn how SQL aggregate functions count, max, min, sum, and avg summarize large data sets, optionally with distinct, and apply these concepts in practical SQL queries for data analysis.
Aggregation Functions I (Practical Class)3:59
Aggregation Functions II (Practical Class)3:25
Table Relationships: Definition (Theory)1:55
Tables Summary and Upload3:29
Table Relationships: INNER JOIN (Theory)1:59
Table Relationships: INNER JOIN (Practical Class)2:27
Table Relationships: LEFT JOIN (Theory)2:47
Table Relationships: LEFT JOIN (Practical Class)2:43
Table Relationships: RIGHT JOIN (Theory)2:45
Table Relationships: RIGHT JOIN (Practical Class)2:50
Learn how to use the right join to return all purchases with matching login data, using aliases A and C, and filter for purchases without logins where logins.user_id is null.
Table Relationships: FULL JOIN (Theory)2:34
Table Relationships: FULL JOIN (Practical Class)3:34
Explore the full join operation in SQL with Google BigQuery to merge logins and purchases. Identify unmatched records with where clauses, handle nulls with coalesce, and perform double full joins.
Exercises6:41

Requirements

You don't need to be from the exact sciences field to take this course
Willingness to learn new languages
Willpower

Description

100% UPDATED LESSONS IN 2024 WITH THE NEW BIGQUERY INTERFACE

ABOUT THE COURSE

This is NOT just another complicated course with unclear explanations or impractical examples for the job market.

This course IS a simple way for you to learn SQL (more specifically DQL, Data Query Language).

You don't need to have experience in Data or exact sciences to follow the entire course, which was designed with simple didactics and progressive modules so you can advance with confidence! To help you progress throughout the course, the modules will have exercises and quizzes to reinforce your knowledge.

Start exploring the field of Business Intelligence and Data Science today with ease. Even if you're already in the field, this is your opportunity to improve your skills with a new language.

The job market increasingly demands that various professionals have knowledge in data analysis! Learn to extract information from different databases to relate and create strategic analyses.

ABOUT THE INSTRUCTOR

My name is Caio Avelino, and the knowledge I'll share with you in this course was mainly acquired through my experience in the job market. I have been working in the fields of Business Intelligence, Data Science, and Artificial Intelligence for years and had the opportunity to develop my skills in various startups.

I guarantee that you will leave this course ready to query any Database, without difficulties. I will be online and always available to clarify doubts and enhance your professional experience with SQL learning.

See you soon!

Who this course is for:

Beginners and those curious about Business Intelligence
Data Science students who would like to learn SQL
Employees of a company, from any area, who would like to learn SQL for database queries
BI analysts interested in learning SQL to build custom analyses and dashboards, without the limitations of software that only allow drag and drop charts
Anyone, from any field, who wants to enter the Data World
Marketing professionals who would like to bring more analytical power

SQL for Data Analysis with Google BigQuery

What you'll learn

Explore related topics

Course content

Introduction4 lectures • 6min

Google BigQuery5 lectures • 19min

SQL Basics27 lectures • 1hr 16min

Requirements

Description

Who this course is for: