BigQuery for Data Analysts

Focused View

Dan Sullivan

4:56:21

4 View

1. Introduction

1. Introduction.mp4

01:23

2. Creating Tables and Views in BigQuery

1. Creating Tables using the BigQuery Console.mp4

07:23

2. Creating Tables using the bq Command.mp4

09:33

3. Creating Tables using SQL Statements.mp4

07:01

4. Creating Views using the BigQuery Console.mp4

02:36

5. Creating Views using SQL Statements.mp4

02:47

6. Altering a Table.mp4

06:16

7. Creating a Table in BigQuery.html

8. Altering a Table in BigQuery.html

9. Creating Tables and Views Quiz.html

3. Review of Querying with SELECT Statements

1. Working with a 1 Table Public Data Set.mp4

07:56

2. Working with a 2 Table Public Data Set.mp4

04:24

3. Basic Select Statements.mp4

04:27

4. WHERE Clauses.mp4

04:28

5. ORDER BY Clauses.mp4

04:03

6. GROUP BY Clauses.mp4

05:36

7. WHERE, GROUP BY, and ORDER BY Clauses.mp4

03:46

8. HAVING Clauses.mp4

02:35

9. Aggregate Functions.mp4

04:51

10. Simple Math Expressions.mp4

03:21

11. CASE Statements and Error Checking.mp4

03:09

12. Joining Two Tables.mp4

04:52

13. Common Table Expressions.mp4

08:11

14. Find the name of the station with the smallest station id.html

15. Find the name of the station that was the start of the longest trip duration..html

4. Data Manipulation Language Statements

1. Inserting Data.mp4

04:23

2. Updating Data.mp4

05:40

3. Deleting and Truncating Data.mp4

02:47

4. Merging and Upserting Data.mp4

09:38

5. Create a SELECT Statement Using Aggregate Functions.html

6. Filter Aggregated Results.html

7. Data Manipulation Language Quiz.html

5. Arrays and Structs

1. Querying and Unnesting Arrays.mp4

07:06

2. Array Functions.mp4

09:30

3. Querying Structs.mp4

07:52

4. Querying Arrays of Structs.mp4

08:08

5. Arrays and Structs Quiz.html

6. SQL Math and Cast Functions

1. Basic Math Functions.mp4

04:10

2. Sample Data for Numeric Functions.mp4

05:05

3. ABS and SIGN Functions.mp4

03:29

4. SQRT and POWER Functions.mp4

05:12

5. RAND and MOD Functions.mp4

07:19

6. Safe Operations.mp4

02:36

7. Casting Data Types.mp4

05:08

8. SQL Math and Casting Functions Quiz.html

9. Randomly select rows from a table..html

7. Date and Time Functions

1. Date Functions.mp4

07:13

2. Datetime Functions.mp4

05:19

3. Time Functions.mp4

03:56

4. Timestamp Functions.mp4

05:06

5. Date and Time Function Quiz.html

8. Statistical Aggregate Functions

1. Pearson Correlation with the CORR Function.mp4

03:13

2. Calculating Covariance with COVAR Function.mp4

02:22

3. Calculating Standard Deviation with STDDEV Functions.mp4

03:06

4. Statistical Aggregation Functions.html

9. String Functions

1. Basic String Functions.mp4

08:02

2. Trimming and Padding.mp4

03:34

3. Splitting Delimited Strings.mp4

03:46

4. Working with Substrings.mp4

04:58

5. Matching with Regular Expressions.mp4

06:29

6. Write a SQL statement to split a string on a delimeter..html

7. Working with Strings Quiz.html

10. Window Functions

1. Introduction to Window Functions.mp4

03:12

2. Lead and Lag Functions.mp4

03:14

3. First Values Functions.mp4

05:24

4. Numbering Functions.mp4

07:48

5. Moving Average Functions.mp4

05:02

6. Window Functions Quiz.html

11. Access Controls in BigQuery

1. BigQuery and Identity and Access Management (IAM).mp4

08:07

2. Column Level Access Contols.mp4

02:53

3. Row Level Security.mp4

02:35

4. Access Controls in BigQuery Quiz.html

12. Cost Control and Query Performance Tips

1. Query Performance Tips.mp4

07:36

2. Cost Control Options.mp4

05:45

3. Cost Control and Query Performance Tips.html

13. Conclusion

1. Next Steps.mp4

01:00

Description

Data Modeling, SQL Functions, Access Controls, Performance Tips, and Controlling Costs

What You'll 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 is this for?

Data analysts

Data engineers

SQL developers

Database administrators

Analytics engineers

What You Need to Know?

Some basic experience with BigQuery

More details

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.

Who this course is for:
Data analysts
Data engineers
SQL developers
Database administrators
Analytics engineers

User Reviews

Rating

average 0

Total votes0

Focused display

Dan Sullivan is a cloud architect, systems developer, and author of the Official Google Cloud Professional Architect Study Guide, the Official Google Cloud Professional Data Engineer Study Guide, and the Official Google Cloud Associate Engineer Study Guide. He is an experienced trainer and his online training courses have been viewed over 1 million times. Dan has extensive experience in multiple fields, including cloud architecture, data architecture and modeling, machine learning, data science, and streaming analytics.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.