Introduction to BigQuery (SQL) for Beginners

Practice environment

• The lecture was filmed on MacOS, but BigQuery is accessible via the web, so anyone can use it.

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.

Learning Materials

• We provide PDF files.

• You can also refer to the webpage for assistance: https://zzsza.github.io/bigquery/

• If you are curious about more general information about BigQuery, I also recommend reading the book <Google BigQuery Complete Guide> .

• You may add this course to your onboarding training within your company, but you may not use the course material for any additional commercial purposes. You may leave a review on your blog, provided you cite the source.

Shin Min-a (Data Analyst)

It was a journey that allowed me to learn everything from A to Z about the BigQuery environment. After learning the basics of writing SQL in BigQuery, I was able to learn how to write structured SQL and how to plan data for analysis by solving example problems. It is a complete lecture on the basics of data analysis that can also reach EDA and approaches for problem solving.

Hye-Ram Lee (Data Analyst)

I recommend this book to anyone who wants to learn BigQuery for the first time, as it explains not only simple SQL, but also error message interpretation and how to apply BigQuery to practical situations!!

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!

Dongmin Jo (Data Analyst)

There are countless lectures on the market that cover SQL grammar, but it is not easy to process data just by looking at the grammar. This is because processing data accurately is another story. I recommend this lecture to those who want to extract data accurately, not just learn grammar!

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.