Introduction to BigQuery (SQL) for Beginners

Name: Introduction to BigQuery (SQL) for Beginners
Rating: 5 (236 reviews)

This is an introductory BigQuery (SQL) course for beginners. Recommended for those curious about data processing methods. We teach SQL from a data analysis and data engineering perspective rather than a backend development perspective.

(5.0) 236 reviews

7,546 learners

kyleschool

이론 실습 모두

SQL

Google Cloud Platform

bigquery

Data literacy

Reviews from Early Learners

What you will gain after the course

BigQuery
SQL
Data Analysis
Data Results Validation
How to write readable queries

BigQuery, an essential data analysis tool these days
Wondering how to get started? 👀

As more and more companies use Google Analytics 4 (GA4) and Firebase, many companies are adopting BigQuery as their data warehouse. BigQuery is a data warehouse on Google Cloud Platform that focuses on data analysis. BigQuery can extract data using SQL.

I would like to recommend this course to those who are starting BigQuery (SQL) . It will also be a good guide for those who are just jumping into the world of data and want to analyze data . If you are looking for a BigQuery course, this course will be helpful.

💡 This course is for those who have never been exposed to BigQuery (SQL). It is easy to understand for beginners and focuses on essential knowledge of SQL. If you are interested in more in-depth content, I recommend the BigQuery Utilization (Funnel Analysis, Retention Analysis) course.

If you take the utilization course, you will be able to answer most of the SQL coding tests (this course covers all of the current SQL coding tests, such as writing window functions, funnels, and retention queries)

It is also comparable to in-house BigQuery training.
Only the essentials you need for your work!

I have been using BigQuery for a long time since 2017, and have continuously refined the core knowledge required for practical work through numerous BigQuery trainings. This lecture contains the contents that I thought were essential to know when using BigQuery in the field , such as query exploration cost, readable query, and data result verification. If you add this lecture as an onboarding or team training material at your company, you can use your time efficiently . Quickly proceed with the SQL training that is essential in the process of improving data literacy!

Recommended learning methods

Rather than studying alone, take the class with friends or colleagues and think about how you can apply this to your work.
- If necessary, you may wish to add this lecture to your company’s onboarding materials.
The problem exists in the lecture material PDF file. It is best to solve the problem first and see how it differs from my solution for better learning effectiveness.
When posting the content of a lecture on a blog, please be sure to specify the lecture URL, and if you post most of the lecture, there may be copyright issues. I recommend that you write a post by adding your own thoughts and the key points you want to remember from the lecture.

Kyungho Park (AI Product Owner)

I think that the most important source to know the past, present, and future of a product is data. Therefore, it is also important to store this important data well and have the organization members effectively search it to extract insights. This lecture is great because it describes in detail the purpose of using BigQuery in an organization, how to set it up, and many tips for effective use, and anyone can follow it. Furthermore, SQL grammar and techniques for effectively sending queries are explained kindly so that you can apply it right away in the field. If you acquire the contents of this lecture and use them in your work, you will be recognized as a beloved data analyst or a planner, PM, or marketer who can utilize data very well. I strongly recommend this lecture, which contains the AZ of BigQuery and practical techniques that I frequently used when I worked with Kyle.

Yoonhwan Kwon (Software Engineer, Glucofit)

The ability to freely handle data has become an essential ability required in many fields. This course is even more valuable because it covers all the essential abilities that a good data analyst must have, such as not only grammatical aspects but also the flow of thought for analysis, readability, data result verification, and thinking about various problem situations. If you are considering a career in the data field, this course will give you a clue to the right direction and will be of great help in starting your career successfully.

Woongwon Lee (Data Scientist)

Data has become a necessity in most companies, and being able to obtain data on your own has become a daily task for all positions. However, I feel that many people are still unfamiliar with BigQuery or SQL. There are many educational materials on SQL, but you may have found it difficult when actually working. In order to obtain the data I want, I need to know not only how to write SQL, but also what process to go through to obtain and verify the data. This course is highly recommended because it repeatedly shows the flow of obtaining data, allowing you to immediately apply it in your actual work!

Choi Bo-kyung (Data Scientist)

Data-driven decision-making has become an essential practice for many companies today. In this era, data analysis is a complex field that requires a variety of knowledge. However, Kyle's 'BigQuery (SQL) for Beginners' course provides the perfect starting point for easily understanding and approaching this complex field. This course starts from the basics of BigQuery and systematically covers the core concepts of SQL, and is structured so that learners can easily approach it through fun and easy-to-understand cases. Based on his deep expertise in BigQuery utilization and his experience communicating with people in various positions, Kyle goes beyond simple lectures and provides detailed guidance so that you can develop practical data analysis capabilities. If you are using BigQuery in your company, I am sure that this course will play an important role in taking the first step toward data analysis.

Recommended for
these people

Who is this course right for?

For those new to BigQuery
Those who want to learn SQL basic concepts
Those who want to start data analysis

Hello
This is

14,181

Learners

507

Reviews

373

Answers

4.9

Rating

Courses

9년차 데이터 과학자, 데이터 엔지니어, 머신러닝 엔지니어로 근무했으며, 쏘카와 타다에서 데이터 분석, 데이터 엔지니어링 개발, 머신러닝 알고리즘을 개발했습니다.

카일스쿨 유튜브에 데이터 커리어 관련 영상을 올리고 있으며, 어떻게 해야 강의를 수강하신 분들이 회사에서 일을 잘할 수 있을까?를 고민하며 자료를 만들고 있어요.

Google의 GDE(Cloud)로 활동하고 있어요.

카일스쿨 유튜브 : https://www.youtube.com/c/kyleschool
기술 블로그 : https://zzsza.github.io/
인스타그램 : https://www.instagram.com/data.scientist/
대표 컨텐츠 : https://github.com/Team-Neighborhood/I-want-to-study-Data-Science
데이터 과학자가 되기 위해 진행한 다양한 노력들 : https://zzsza.github.io/diary/2019/04/05/how-to-study-datascience/

Curriculum

All

52 lectures ∙ (9hr 1min)

Course Materials:

Lecture resources

Section 1. Course Introduction

2 lectures ∙ (17min)

Section 2. BigQuery Basics

2 lectures ∙ (27min)

3. 1-1. BigQuery Basic Knowledge
14:56
4. 1-2. Setting up a BigQuery environment
12:59

Section 3. Data Exploration - Condition, Extraction, Summary

12 lectures ∙ (2hr 15min)

5. 2-1. Data Utilization Overview
05:30
6. 2-2. Confirming the data (database, data warehouse, ERD)
15:56
7. 2-3. DATA SELECTION (SELECT, FROM, WHERE)
26:03
8. 2-4. SELECT Practice Problems
10:36
9. 2-5. Aggregation (GROUP BY + HAVING + SUM/COUNT)
26:48
10. 2-6. Practice Problems 1-3
14:26
11. 2-6. Practice Problems 4-6
09:27
12. 2-6. Practice Problems 7-9
05:45
13. 2-6. Practice Problems 10-12
04:17
14. 2-6. Practice Problems 13~17
12:24
15. 2-7. SORTING
02:42
16. 2-8. Introducing new aggregate functions (GROUP BY ALL, a function released on 2024-02-26)
02:01

Section 4. Writing Good SQL Queries, Query Writing Templates, and Debugging Errors

4 lectures ∙ (27min)

Section 5. Data Exploration - Transformation

11 lectures ∙ (2hr 18min)

Section 6. Connecting large amounts of data: JOIN

8 lectures ∙ (1hr 26min)

Section 7. Validating Data Results, Writing Readable Queries

6 lectures ∙ (51min)

Section 8. BigQuery Getting Started Practice Problems for Beginners

4 lectures ∙ (39min)

Section 9. In conclusion

3 lectures ∙ (17min)

Published:

Last updated:

Reviews

All

236 reviews

5.0

236 reviews

morejasmine59827
Reviews 1
∙
Average Rating 5.0
5
27% enrolled
I'm a data worker, and I got goosebumps while listening to the lecture, so I'm leaving in the middle to write a lecture review. I've listened to some SQL-related lectures, and I can't understand why they're free. The curriculum and content are so good that it's just as good as the others. Those who have been looking for other lectures will save time and money if they settle here. I'm actually a YouTube subscriber, so I came here simply because I was curious about what you filmed, but the magic is that I keep listening... No, it's ridiculous that it's free, and I didn't know you'd include data verification in the curriculum. Thumbs up!! I'll listen to the intermediate and advanced versions even if I have to pay for them myself. Kyle School, please make one!!
- kyleschool
  Instructor
  Hello ACB 5! Thank you for leaving a review. I'm so happy that you caught what I intended while listening to the lecture..! When I think about what mistakes people who are new to working with data often make, or what they find most difficult when actually working, grammar doesn't come to mind first. Grammar becomes familiar as you practice, and SQL is simpler than other programming languages, so it's not difficult. When actually using data, how to verify data, how to make it more readable, what kind of flow is used to write queries? I thought it would have been better if we had learned this part from the beginning, so I added this part. And I hope that many people will know this content, so I made it free. I hope that even one more person will take the course and gain experience. Thank you so much for taking the course on YouTube and leaving a review :)
jeongdo
Reviews 2
∙
Average Rating 5.0
5
100% enrolled
This is not a free lecture level. For those interested in SQL queries, this is highly recommended as a pre-course.
- kyleschool
  Instructor
  Thank you for your kind words! I think it was a good idea to make the lecture public. If you have any questions, please let me know at any time!
tett77
Reviews 18
∙
Average Rating 5.0
5
46% enrolled
Please listen... It's a shame to listen to it alone🙏 [Course scope] I can write simple SQL statements, so I took the course mainly for confusing parts + practice problems. [Course review] 1. The lecture structure and explanation are neat : Among the SQL lectures I've taken, this one has the best lecture structure, and the explanations are brief and only give you the key points, which was really great. 2. It points out confusing and difficult parts well : I don't use SQL often in the field, so I often forget and don't have much opportunity to write long codes, but it was good to be able to learn the basics again and check the parts I find difficult while taking the course. 3. Learning for practitioners : It's not a coding test or formal education, but it's really great that it focuses on explaining SQL query writing methods that can be realized while working in the field. 4. The blog is well organized : I already knew about Kyle School, but I was impressed when I saw that a separate page was organized for the lectures. Even the errors that beginners can make were kindly written down, which helped me learn. The best! 5. Free ⭐<- There is no better advantage than this : There are more paid SQL lectures than I thought, but this quality is even free... I took the class without expecting much, but I was surprised by the quality and the fact that it was free. 6. Wishes I didn't finish the course, so I might not have found it, but I wish there was a page that organized the correct queries for the practice problems. I sometimes missed things when I watched the video! [Recommended for] - Beginners to SQL : I recommend this to beginners because it explains the necessary content really simply!!! I studied SQL on my own, struggling! At that time, I regretted that I could have saved a lot of time if I had taken this lecture. That's why I really recommend it! - Coding test preparation students I felt that the difficulty level was around beginner or intermediate, but I think it would be helpful for those preparing for a simple coding test with SQL. It's not just learning how to write queries and get the right answer, but I expect that I can get some points in code interviews because I can learn the process of why it was written this way. When I study alone, I understand better than I thought, and there are many times when it's hard to find organized materials, but Kyle's blog is a great help whenever that happens. I always read it with gratitude. Personally, I wish there were lectures on using big data engineering tools used in the field! I hope you prosper.
- kyleschool
  Instructor
  Hello Mango! Thank you so much for the detailed course review. It's a review that inspires me as well. I think it was well-written because you left many of the things I thought about in the course review. I will continue to create materials that can be helpful in the future. Before going into data engineering, there is a utilization section, and in the utilization section, I am sharing some tools for automation. I am preparing to release a data engineering lecture in the second half of the year or early next year. Regarding the answer to the query, I did not share it because I wanted you to actually input it in case you would copy and paste the answer right away, but I will think about it! I think it would be possible to upload it to the web or lecture notes.
lilykim
Reviews 7
∙
Average Rating 5.0
5
35% enrolled
I think beginners to SQL will be able to approach this without difficulty. Usually, many people have difficulty starting with SQL installation, but I didn't feel any difficulty from the beginning to the end :-) And the instructor's communication skills are very good. He explained difficult terms easily using real-life terms, and there were many simple but practice problems, so I think it would be good for beginners to go through it 2-3 times.
- kyleschool
  Instructor
  Thank you, Lily, for your kind words. I will continue to make good lectures!!
- journey
  Infraon Team Capital T, Human Robot Lily acknowledged it... I also applied for the course without asking or questioning ^.^
jyeon94657208
Reviews 3
∙
Average Rating 5.0
5
10% enrolled
I can't believe this course is free.
- kyleschool
  Instructor
  Thank you Je Ho for your kind words! I made this with the hope that it will be helpful to those studying :)

Free

kyleschool's other courses

Check out other courses by the instructor!

Data Literacy for PMs (Product Data Analysis)

kyleschool

This is a course for PMs who want to utilize data. This course covers the entire process of utilizing data in the PM role, including the flow of work from day 1 of a job change through the start and end of a project. It is an introductory data course that covers data-driven thinking, logical thinking, metric definition, log design, experiment design, creating a data culture, and more, to help you develop critical thinking skills. Although created as a course for PMs, it is structured with content that data analysts would also find beneficial (in fact, many analysts have taken the course). In addition, many people in marketing, design, and business planning roles are also taking the course.

초급

Data literacy, metric hierarchy, AB test

Data Literacy for PMs (Product Data Analysis)

kyleschool

BigQuery(SQL) Application (Funnel Analysis, Retention Analysis)

kyleschool

We conduct app log analysis using data from Google Analytics 4 and Firebase. It includes useful content for practical use, such as arrays, window functions, funnels, retention, Google Sheets, and more.

중급이상

bigquery, SQL, Firebase

BigQuery(SQL) Application (Funnel Analysis, Retention Analysis)

kyleschool

From 3 Million Blog Pageviews: 'Pragmatic Tech Blog Writing'

kyleschool

This is a lecture for those who want to consistently write a technical blog. Starting is easy, but trying to do it consistently leads to many trials and errors. This lecture compiles what I've tried and the know-how gained from operating a technical blog for over 7 years. It contains all my 7 years of experience, including SEO, technical blog writing strategies, writing process, etc.

입문

Blog, SEO, writing

From 3 Million Blog Pageviews: 'Pragmatic Tech Blog Writing'

kyleschool

Similar courses

Explore other courses in the same field!

Introduction to GA4 BigQuery for Marketers and Planners (2025)

GA4 Guide

Introduces methods for utilizing GA4 data in Bigquery. Using the GA4 Bigquery demo data publicly available in Bigquery from the Google Merchandise Store (https://www.googlemerchandisestore.com/), we introduce methods for marketers and planners to easily utilize GA4 Bigquery data, along with hands-on practice of basic SQL queries.

입문

SQL, Google Analytics, bigquery

Introduction to GA4 BigQuery for Marketers and Planners (2025)

GA4 Guide

GCP BigQuery Tutorial for Beginners

Sungmin Kim

Let's learn together about Columnar Storage, which allows you to conveniently handle both structured and unstructured data provided by GCP and allows for a free table format, and BigQuery, a universal database.

입문

SQL, Google Cloud Platform, bigquery

GCP BigQuery Tutorial for Beginners

Sungmin Kim

High-Performance SQL for JPA (ORM) Developers

Vlad Mihalcea

Make the most of relational database systems!

중급이상

SQL, performance-tuning, sql-query

High-Performance SQL for JPA (ORM) Developers

Vlad Mihalcea

Automatically generate CRUD SQL

dlqorgod

Automatically generate executable SQL files using JDBC (DatabaseMetaData, ResultSetMetaData). Install the e-Government Standard Framework 3.10.0 development environment. Install local DB (mariadb-10.6.4-winx64.zip).

초급

SQL

Automatically generate CRUD SQL

dlqorgod

SQL Survival Kit for Data Beginners

swa

Through a hands-on curriculum using MariaDB and HeidiSQL, you can learn the core concepts of SQL and how to use it in practice while collecting, preprocessing, and analyzing data.

초급

MariaDB, MySQL, SQL

SQL Survival Kit for Data Beginners

swa

Practical Google Analytics (GA4+GTM) for Practitioners (2025 Update)

GA4 Guide

This is a specific and practical course for Google Analytics beginners. Instead of focusing on fragmented features, you can learn the practical analysis process using GA4 by conducting scenario-based analysis. It is continuously being updated to match the latest GA4 revisions!

초급

GA4, Google Analytics, Data literacy

Practical Google Analytics (GA4+GTM) for Practitioners (2025 Update)

GA4 Guide

GA4 Looker Studio Practice for Data Analysis (2025)

GA4 Guide

Learn various features of Looker Studio (formerly Google Data Studio) using GA4 demo data. This includes explanations and hands-on practice with Looker Studio's visualization elements. In particular, marketers and planners who are not familiar with SQL can learn easy ways to integrate and use BigQuery data with Looker Studio. You can learn methods to create dashboards using Looker Studio.

입문

Google Datastudio, Google Analytics, looker-studio

GA4 Looker Studio Practice for Data Analysis (2025)

GA4 Guide

Practical GA4 Reports You Can Use Right Away (2025) + Microsoft Clarity

GA4 Guide

You can learn to use GA4 immediately in practice while creating essential reports for GA4 utilization. You can learn specific examples of what reports to create and how to create them for data analysis. For practical analysis, the installation and usage of Microsoft Clarity, a heatmap tool, is also explained together.

초급

Google Analytics, Google Tag Manager, Data literacy

Practical GA4 Reports You Can Use Right Away (2025) + Microsoft Clarity

GA4 Guide

Data Literacy for PMs (Product Data Analysis)

kyleschool

초급

Data literacy, metric hierarchy, AB test

Data Literacy for PMs (Product Data Analysis)

kyleschool

The Problem Definition for Data Analysis That SQL Lectures Don't Teach

platter

Learn the problem definition and hypothesis formulation process, core competencies for data analysis!

입문

product-management, Data literacy

The Problem Definition for Data Analysis That SQL Lectures Don't Teach

platter

Kim Younghan's Practical Database Introduction - SQL First Steps for All IT Professionals (Step by Step from SQL)

Not only developers, but also planners and data analysts learn databases step-by-step, starting from SQL basics.

입문

SQL, MySQL, DBMS/RDBMS

Kim Younghan's Practical Database Introduction - SQL First Steps for All IT Professionals (Step by Step from SQL)

Hands-on Practice for Mastering SQLD Fundamentals (Subject 2)

coddatg

For those who feel overwhelmed preparing for the SQLD exam, this is a comprehensive course that analyzes the entire Norang-i scope, organizes necessary theory, conducts practice-focused classes, and solves all problems systematically. With short, concise clips and topic-based segmented structure, you can build skills that work directly in the exam room.

초급

SQL, Oracle, MSSQL

Hands-on Practice for Mastering SQLD Fundamentals (Subject 2)

coddatg

[2025] SQLD All-in-One for Non-Majors to Pass in One Shot

algolearn

SQLD, where should I start? This course is for you who feel so overwhelmed; you'll meet a changed you after completing it. SQLD All-in-One Pass!

입문

SQLD, Big Data, Data Engineering

[2025] SQLD All-in-One for Non-Majors to Pass in One Shot

algolearn

SQLD Certification Preparation Course

SoYoung Yoon

This is a course aimed at obtaining the nationally recognized SQLD certification, and SQLD refers to developers who can write accurate SQL for manipulating and extracting data while developing application software based on database and data modeling knowledge.

입문

SQL, SQLD

SQLD Certification Preparation Course

SoYoung Yoon

[2025] SQLD Problem Solutions - 176 Yellow Problems for Those Who Find SQLD Questions Difficult

algolearn

SQLD Yellow Book 176 Problem Solving Lecture for You Who Studied but Cannot Solve Problems. After Completing the Course, You Will Become an Expert Beyond Passing. SQLD All-in-One Pass!

초급

SQL, SQLD, Big Data

[2025] SQLD Problem Solutions - 176 Yellow Problems for Those Who Find SQLD Questions Difficult

algolearn

[Infraon] PM/PO Meetup (with Kim Min-woo)

inflearn

입문

Service Planning, Business Problem Solving, Data literacy

[Infraon] PM/PO Meetup (with Kim Min-woo)

inflearn

SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questions

Masocampus

From understanding SQL to using actual functions, Complete preparation for SQLD certification with the latest past exam questions!

입문

SQL, SQLD

SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questions

Masocampus

Excel Data Visualization | Everything About Business Charts & Graphs

niniexcel

Data Visualization Storytelling That's Perfectly Achievable with Excel Alone

입문

Excel, Data literacy

Excel Data Visualization | Everything About Business Charts & Graphs

niniexcel

Fashion Retail Analysis

pnuswedu

Let's understand data analysis suitable for advanced retail business and learn how to utilize tools utilized in the industry!

입문

scm, SQL, Google Analytics

Fashion Retail Analysis

pnuswedu

Introduction to BigQuery (SQL) for Beginners

Reviews from Early Learners

What you will gain after the course

BigQuery, an essential data analysis tool these days
Wondering how to get started? 👀

It is also comparable to in-house BigQuery training.
Only the essentials you need for your work!

Features of this course 📌

Even if you are new to SQL/BigQuery, it’s not difficult!

Providing practical experience that can be applied in practice!

Make it easier with diagrammatic/visualized lecture materials!

I recommend this to these people

After class

Who created this course

Things to note before taking the class

Practice environment

Recommended learning methods

Learning Materials

Those who watched the lecture first
Reviews and Testimonials 💫

Recommended for
these people

Hello
This is

Curriculum

Reviews

kyleschool's other courses

Similar courses

Introduction to BigQuery (SQL) for Beginners

Reviews from Early Learners

What you will gain after the course

BigQuery, an essential data analysis tool these days Wondering how to get started? 👀

It is also comparable to in-house BigQuery training. Only the essentials you need for your work!

Features of this course 📌

Even if you are new to SQL/BigQuery, it’s not difficult!

Providing practical experience that can be applied in practice!

Make it easier with diagrammatic/visualized lecture materials!

I recommend this to these people

After class

Who created this course

Things to note before taking the class

Practice environment

Recommended learning methods

Learning Materials

Those who watched the lecture first Reviews and Testimonials 💫

Recommended for these people

HelloThis is .css-1q3zd4q{text-decoration-line:underline;text-underline-position:under;text-underline-offset:1px;}

Curriculum

Reviews

kyleschool's other courses

Similar courses

BigQuery, an essential data analysis tool these days
Wondering how to get started? 👀

It is also comparable to in-house BigQuery training.
Only the essentials you need for your work!

Those who watched the lecture first
Reviews and Testimonials 💫

Recommended for
these people

Hello
This is