Free Course Image Learn to use Google BigQuery for Beginners

Free online courseLearn to use Google BigQuery for Beginners

Duration of the online course: 1 hours and 17 minutes

New

Build job-ready BigQuery skills fast with this free online course—write SQL, explore public datasets, schedule queries, and connect results to Sheets.

In this free course, learn about

  • BigQuery course goal and how to start learning effectively with hands-on practice
  • How to set up BigQuery free trial and what triggers billing after the trial
  • How to add and access BigQuery Public Datasets in the Explorer
  • How BigQuery on-demand query pricing works beyond the free tier
  • How to find and inspect tables: using the Schema tab to understand columns and types
  • How to write BigQuery SQL and reference tables as project.dataset.table
  • Tour of the Query Console: running queries, viewing results, and using settings
  • How scheduled queries automate recurring runs and refresh destination tables
  • How to create scheduled queries that overwrite/replace the destination table each run
  • How and why to use CTEs, including filtering on calculated aliases cleanly
  • How to connect BigQuery to Google Sheets and Looker Studio for reporting
  • How to make BigQuery results usable in Sheets (convert/import so formulas can reference data)
  • How to upload CSVs to BigQuery, including skipping header rows when column names exist
  • Key functions/queries for analysis: EXTRACT(YEAR FROM date) and DISTINCT + ORDER BY patterns

Course Description

Want to analyze large datasets without managing servers or worrying about complex infrastructure? This free online course helps beginners get comfortable with Google BigQuery and start working like a modern data analyst. You will learn how BigQuery fits into the Google Cloud ecosystem, what it is designed for, and how to navigate the interface with confidence so you can go from opening the console to producing useful insights.

From the start, the course focuses on practical progress: getting set up, understanding what triggers billing, and making smart choices during the free trial. You will explore how BigQuery pricing works in the real world so you can query responsibly, estimate costs, and build good habits early. Instead of feeling intimidated by cloud data warehouses, you will learn the simple workflow behind finding data, inspecting tables, and understanding what a schema tells you about columns, types, and structure.

As you move into SQL, you will practice writing queries the BigQuery way, including correct table referencing and the day-to-day tools inside the query console that speed up analysis. You will also see how scheduled queries can automate recurring work, making it easier to keep reports and datasets updated without manual repetition. Concepts like CTEs are introduced in a beginner-friendly way so you can write clearer queries and handle situations where you need to filter on calculated results.

To bridge analysis and reporting, the course shows how to connect BigQuery outputs to familiar tools like Google Sheets and Looker Studio, turning query results into something you can share, chart, and present. You will also learn how to bring your own data into BigQuery by uploading CSV files and configuring common settings correctly so your tables are clean from the first load.

Throughout, you will build the skill of learning efficiently by using documentation and community resources the right way, and you will finish with a capstone-style analysis that ties together querying, exploration, and problem solving. By the end, you will know the best next steps for continuing your BigQuery journey and applying these database skills to real projects in analytics, business intelligence, and data-driven decision-making.

Course content

  • Video class: BigQuery Tutorial for Beginners (Part 1 of 14) 02m
  • Exercise: What is the main goal of this beginner course on Google BigQuery?
  • Video class: BigQuery Tutorial for Beginners (Part 2 of 14) - Getting Set Up 05m
  • Exercise: What must happen before you will be billed for using BigQuery during the free trial setup?
  • Video class: BigQuery Tutorial for Beginners (Part 3 of 14) - Accessing Free Public Datasets 03m
  • Exercise: How do you add BigQuery Public Datasets so they appear in your Explorer?
  • Video class: BigQuery Tutorial for Beginners (Part 4 of 14) - Understanding BigQuery Pricing 04m
  • Exercise: How does BigQuery on-demand query pricing work after the free tier?
  • Video class: BigQuery Tutorial for Beginners (Part 5 of 14) - Finding Data to Analyze 04m
  • Exercise: In BigQuery, what does the Schema tab primarily show for a table?
  • Video class: BigQuery Tutorial for Beginners (Part 6 of 14) - How to Write SQL in BigQuery 04m
  • Exercise: In BigQuery, what is the correct way to reference a table using the full hierarchy?
  • Video class: BigQuery Tutorial for Beginners (Part 7 of 14) - Tour of the Query Console 07m
  • Exercise: In BigQuery, what does enabling a scheduled query typically help you do?
  • Video class: BigQuery Tutorial for Beginners (Part 8 of 14) - Scheduled Queries 06m
  • Exercise: When creating a scheduled query in BigQuery, what setting ensures the query results replace the existing destination table each run?
  • Video class: BigQuery Tutorial for Beginners (Part 9 of 14) - CTEs 06m
  • Exercise: Why does a CTE help when filtering on a calculated column alias in BigQuery?
  • Video class: BigQuery Tutorial for Beginners (Part 10 of 14) - Connecting to Google Sheets and Looker Studio 04m
  • Exercise: When exploring BigQuery query results in Google Sheets, what should you do to make the data usable for formulas and references?
  • Video class: BigQuery Tutorial for Beginners (Part 11 of 14) - Uploading CSV Data 07m
  • Exercise: When uploading a CSV into BigQuery, what should you set Header rows to skip to if the first row contains column names?
  • Video class: BigQuery Tutorial for Beginners (Part 12 of 14) - Using Google and Stack Overflow 05m
  • Exercise: Which BigQuery function is used to get just the year (e.g., 2018) from a DATE column?
  • Video class: BigQuery Tutorial for Beginners (Part 13 of 14) - Capstone Data Analysis 11m
  • Exercise: Which SQL query helps you find all unique seasons in a BigQuery table and sort them chronologically?
  • Video class: BigQuery Tutorial for Beginners (Part 14 of 14) - Conclusion 01m
  • Exercise: What is the recommended best way to get started learning Google BigQuery?

This free course includes:

1 hours and 17 minutes of online video course

Digital certificate of course completion (Free)

Exercises to train your knowledge

100% free, from content to certificate

Ready to get started?Download the app and get started today.

Install the app now

to access the course
Icon representing technology and business courses

Over 5,000 free courses

Programming, English, Digital Marketing and much more! Learn whatever you want, for free.

Calendar icon with target representing study planning

Study plan with AI

Our app's Artificial Intelligence can create a study schedule for the course you choose.

Professional icon representing career and business

From zero to professional success

Improve your resume with our free Certificate and then use our Artificial Intelligence to find your dream job.

You can also use the QR Code or the links below.

QR Code - Download Cursa - Online Courses

More free courses at Databases

Free Ebook + Audiobooks! Learn by listening or reading!

Download the App now to have access to + 5000 free courses, exercises, certificates and lots of content without paying anything!

  • 100% free online courses from start to finish

    Thousands of online courses in video, ebooks and audiobooks.

  • More than 60 thousand free exercises

    To test your knowledge during online courses

  • Valid free Digital Certificate with QR Code

    Generated directly from your cell phone's photo gallery and sent to your email

Cursa app on the ebook screen, the video course screen and the course exercises screen, plus the course completion certificate