Learn Bigquery
Introduction
Architecture
Architecture Compute Storage
Unique Features
Enncryption Column Level Security Time Travel Caching Compression
Database Management
Create Table Create View Create Procedure
Best Practices
Execution plans
Interview Questions
Top Questions
03 Dec 20 · npack · #Bigquery ·   Bookmark  

Learn Google BigQuery - Course, Tutorials and Examples


Why learn Data Warehousing?

Data warehousing is huge! Its a ever growing industry with ample shortage of talent. Organizing petabytes of data and mining insights from a data warehouse needs skilled (And of course high paid) engineers. I personally have been employed in Data Warehousing field for the past decade (12 years to be certain), and I never had any shortage for work. So, learning Data Warehousing is sure way to boost your career trajectory

What is Google BigQuery ?

Google BigQuery is the Managed cloud data warehouse from Google. (Managed is a fancy term for Serverless, no need to maintain servers or storage. Google takes care of all it. You simply pay for what you use). Google Claims BigQuery can handle petabytes of data in its cloud data warehouse. Below are some of the impressive features of BigQuery:

  • Serverless - Fully Managed by Google
  • Pay per Use - True SAAS Model
  • Auto-scaling of Storage and Compute
  • Multiple layers of Security
  • Seamless integration with the cloud ecosystem - Including AI Notebooks, GCS, Cloud SQL, Data flow, Data Prep, IAM etc. 
  • Streaming Ingestion
  • Innovative features like Time-Travel, BQ ML

How Is BigQuery different from other Data Warehouses ?

BigQuery's main differentiator is being a fully managed data warehouse with separation of storage and compute. You are paying for the storage and the amount of data that is scanned by your queries. Of course, There are other competitors in this space. Snowflake is another major player. 

Is the BigQuery Course easy to learn ? Should I need prior experience ?

BigQuery uses standard ANSI SQL, so if you are familiar with SQL / have already worked on any of the SQL Based Cloud Data Warehouses, You can learn and call yourself a "pro" within few weeks

Remember to ⭐Bookmark this guide, This guide will not only help you learn BigQuery but also serves as a refresher before your interviews !