Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Practical Google BigQuery for those who already know SQL
Rating: 4.2 out of 5(305 ratings)
1,449 students

Practical Google BigQuery for those who already know SQL

Learn how to become BigQuery power user and kick-off you career as Data Scientist, Data Engineer, Analyst or Developer
Created byGeorge B.
Last updated 4/2020
English

What you'll 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

Course content

3 sections • 19 lectures • 3h 9m total length

  • Introduction2:22
  • Setup5:18

    In this class you will learn how to create an account on Google Cloud Platform, create a project and access BigQuery.

  • Access Google Sheets over BigQuery7:48

    In this class you will learn how to use BigQuery to query data directly from Google Sheets.

  • Understand BigQuery resources hierarchy - datasets, tables, views11:06

    After this class video you will understand the hierarchy resources in BigQuery - logical division on project and datasets. This video consists also an explanation of difference between views and tables.

  • Make use of scheduled queries6:30

    After this lecture you will know how to setup a scheduled query.

  • Use SQL editor shortcuts (also hidden ones!)9:45

    In this lecture you will learn all useful SQL editor shortcuts including those mentioned in Google documentation and those that are not.

  • Refresh your SQL skills25:01

    This is a lecture that we will build an SQL query together to refresh your SQL language skills. If you are confident about your SQL, you can skip this one!

  • Get to know all advanced BigQuery UI functionalities10:10

    In this lecture we will discuss all BigQuery functionalities like Query history, Transfers, Reservations etc. 

  • Move data into BigQuery and out12:08

    In this class you will learn what are the options of moving data in and out of BigQuery - f.e. using client libraries, command line interface or data manipulation language. In this videa we will discuss what is a characteristic of each of those and when to use each option.

  • Use BigQuery from python - environment setup8:43

    In this class you will learn how to prepare python environment to access the data using BigQuery python client.

  • Use BigQuery from python - python client, pandas and jupyter magic10:37

    In this class you will learn how use access BigQuery data from python - using python client, pandas and jupyther magic command.

Requirements

  • A computer with a browser :)
  • You should know a little SQL

Description

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!

Who this course is for:

  • Data Scientists
  • Business Intelligence Analysts
  • Data Engineers
  • Developers

Report abuse