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 by: George B.
Leader of professional data teams

What Will I 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

Requirements

• A computer with a browser 🙂
• You should know a little SQL

Target audience

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