Practical Google BigQuery for those who already know SQL

Practical Google BigQuery for those who already know SQL, available at $39.99, has an average rating of 4.15, with 19 lectures, based on 279 reviews, and has 1401 subscribers.

You will learn about How BigQuery works and how to use this knowledge to write fast and cost-effective queries Creating tables with all advanced properties like partitioning, clustering and retention policy Properly choose method of moving data into and out of BigQuery Using Python client and Pandas to access data in BigQuery Configuring an link between Google Sheets and BigQuery to access data online from spreadsheets over SQL Setting up a backup of your views SQL code Recovering when you delete data by mistake Setting up detailed costs monitoring of all queries that you perform Configure a scheduled query to work with partitioned table This course is ideal for individuals who are Data Scientists or Business Intelligence Analysts or Data Engineers or Developers It is particularly useful for Data Scientists or Business Intelligence Analysts or Data Engineers or Developers.

Enroll now: Practical Google BigQuery for those who already know SQL

Summary

Title: Practical Google BigQuery for those who already know SQL

Price: $39.99

Average Rating: 4.15

Number of Lectures: 19

Number of Published Lectures: 19

Number of Curriculum Items: 19

Number of Published Curriculum Objects: 19

Original Price: $22.99

Quality Status: approved

Status: Live

What You Will Learn

How BigQuery works and how to use this knowledge to write fast and cost-effective queries

Creating tables with all advanced properties like partitioning, clustering and retention policy

Properly choose method of moving data into and out of BigQuery

Using Python client and Pandas to access data in BigQuery

Configuring an link between Google Sheets and BigQuery to access data online from spreadsheets over SQL

Setting up a backup of your views SQL code

Recovering when you delete data by mistake

Setting up detailed costs monitoring of all queries that you perform

Configure a scheduled query to work with partitioned table

Who Should Attend

Data Scientists

Business Intelligence Analysts

Data Engineers

Developers

Target Audiences

Data Scientists

Business Intelligence Analysts

Data Engineers

Developers

Practical Google BigQuery for those who already know SQL

is made for Data Scientists, Data Engineers, Business Intelligence specialist and Developers that:

– don’t know how BigQuery works and why it’s such a game changer,

– don’t like spending hours browsing through documentation to do things right,

– worry that their queries will be slow and expensive,

– don’t need yet another course that explains types of JOINs in SQL.

If you fit the description, this course will help you understand deeply how BigQuery works, what are all its funky functionalities and how to make this powerful tool work for you.

Over the entire course you will:

learn how to access Google Sheets over BigQuery,

understand BigQuery resources hierarchy – datasets, tables, views,

make use of SQL editor shortcuts  (also hidden ones!) like a pro,

understand BigQuery additional functionalities like  google transfers,

learn how to access BigQuery from python client,

understand how BigQuery works under the hood – how it stores data and performs queries,

learn how BigQuery pricing works, and how to optimize query costs,

create table with all advanced options – applying partitioning, clustering and retention policy,

setup monitoring of costs of each query in BigQuery,

learn how to recover deleted data in BigQuery using SYSTEM TIME,

backup your view’s SQL code.

Except of the course videos you will get code snippets, SQL code of the examples, cheetsheets and slides.

Google BigQuery is revolutionizing data analysis world right now and this course is made to boost career of anyone that dare to use this amazing product!

Course Curriculum

Chapter 1: Make BigQuery work for you

Lecture 1: Introduction

Lecture 2: Setup

Lecture 3: Access Google Sheets over BigQuery

Lecture 4: Understand BigQuery resources hierarchy – datasets, tables, views

Lecture 5: Make use of scheduled queries

Lecture 6: Use SQL editor shortcuts (also hidden ones!)

Lecture 7: Refresh your SQL skills

Lecture 8: Get to know all advanced BigQuery UI functionalities

Lecture 9: Move data into BigQuery and out

Lecture 10: Use BigQuery from python – environment setup

Lecture 11: Use BigQuery from python – python client, pandas and jupyter magic

Chapter 2: BigQuery concepts that you have to understand to use it efficiently

Lecture 1: Understand how BigQuery works and how it effects its pricing

Lecture 2: Create a table with all advanced options: partitioning, clustering and retention

Lecture 3: Create a scheduled query with all advanced options

Chapter 3: BigQuery – usefull trics

Lecture 1: Monitor exact cost of each query in BigQuery

Lecture 2: Monitor Google Cloud Platform costs over BigQuery

Lecture 3: Access table columns names and last modification time from SQL

Lecture 4: Recover deleted data in BigQuery using SYSTEM TIME

Lecture 5: Backup your views SQL code

Instructors

George B.
Leader of professional data teams

Rating Distribution

1 stars: 5 votes

2 stars: 14 votes

3 stars: 61 votes

4 stars: 92 votes

5 stars: 107 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!