BigQuery for Data Analysts

Description

Analyze data in BigQuery using both basic SQL statements as well as specialized functions to help you gain insight into your data.  If you need to analyze data in BigQuery and have some familiarity with using BigQuery, then this course will help you expand your skills with lectures, quizzes, and assignments.  (If you are new to BigQuery, consider taking the Introduction to BigQuery course first.)

The course begins with data definition language statements for creating and altering tables and views followed by a review of data manipulation statements, including SELECT, INSERT, UPDATE, DELETE, and MERGE.  Learn how to use common table expressions (CTEs) effectively to modularize your SQL and make even complex logic easy to understand.

Note: There are several basic videos reviewing SELECT statements which you can skip if you have taken Introduction to BigQuery or are comfortable writing SELECT statements.

Working with BigQuery has some differences from working with relational databases like Postgres and SQL Server. We often use arrays and structures in BigQuery and this course will teach you how to work with arrays, querying and unnesting arrays, using array functions as well as working with structures and arrays of structures.

SQL functions are foundational building blocks for data analytics work and it is important to know the functions available in BigQuery to rapidly and effectively analyze data. In this course, we will learn about a range of SQL functions for:

• Math and statistics

• Aggregate functions

• Data type casting

• Dates and times

• String manipulation

• Regular expressions

• Approximate functions for working with large datasets

• Analytical and window functions

Data analysts need to be familiar with BigQuery operations so the course also covers BigQuery security, including access controls, column security, and row-level security, as well as performance and cost management.

Test your understanding of BigQuery concepts with 8 assignments and 10 quizzes.

In this course, you will learn a wide range of topics that data analysts need to understand and you will know how to apply that knowledge effectively in BigQuery while working cost-effectively.

After completing this course you will know a wide range of functions and techniques for analyzing and transforming data in BigQuery, understand how access to data is controlled using IAM, row-level, and column security, and how to control the cost of your BigQuery operations.

What You Will Learn!

• Learn how to work with SQL functions for math, strings, datetimes, and more
• Use structured and repeated fields for efficient data modeling
• Apply access controls to columns, rows, tables, and datasets
• Cost controls and performance optimizations

Who Should Attend!

• Data analysts
• Data engineers
• SQL developers
• Database administrators
• Analytics engineers

TAKE THIS COURSE