SQL for Data Analytics (with Google BigQuery) (MasterClass)

Course Details

Current Status
Not Enrolled


This course will teach you how to use SQL, the most widely used language for data analysis, with Google BigQuery, a scalable and powerful cloud data warehouse. You will learn how to write complex queries to extract, transform, and analyze data from various sources and formats. You will also learn how to optimize your queries for performance and cost, and how to use advanced features and functions of BigQuery to solve real-world data problems.

Course Objectives

  • Explain the concepts and benefits of SQL and Google BigQuery
  • Navigate the BigQuery user interface and key features
  • Write SQL syntax and commands to query data from tables and views
  • Use SQL operators and functions to manipulate and aggregate data
  • Use SQL joins and subqueries to combine data from multiple tables
  • Use SQL window functions and analytic functions to perform complex calculations
  • Use SQL common table expressions and scripting to organize and simplify your queries
  • Use SQL user-defined functions and stored procedures to create custom logic and reuse code
  • Optimize your queries for performance and cost using best practices and tools
  • Use BigQuery ML to create and evaluate machine learning models using SQL
  • Use BigQuery GIS to perform geospatial analysis using SQL

Delivery: Online – Weekdays & Weekends

Duration: 2 Months


Course Content

Expand All

Installment payment is available.

Can’t pay at once, we’ve got you covered, choose part payment during the sign up process so you can pay on installments

Refer a friend and get cashback

Get up to N20,000 cashback in your account when your friend registers. No hassle, you and your friend confirms to us and you get paid to your account.

Share with friends


Join our Channel