Google BigQuery: Learn Professional SQL for Big Data
- 3.5
Brief Introduction
Learn SQL by leveraging the Google BigQuery Data Warehouse and gain highly sought after technical skills!Description
Gain powerful in-demand skills for analyzing big data through writing SQL to unlock insights to petabytes of data within seconds.
This course will provide you with
Highly marketable technical skills crucial for Data Analysts, Data Scientists, or Data Engineers
Knowledge of Google BigQuery, a popular modern cloud data warehouse
Transferable SQL skills to all relational databases including but not limited to Amazon Redshift, Snowflake, MySQL, PostgreSQL etc.
Understanding of how modern databases function and how companies leverage them
Step by step instructions on setting up a Google BigQuery sandbox environment to practice SQL
Detailed written notes with screenshots of Google BigQuery console, examples of queries, and other tips & tricks!
Plenty of practical assignments to perfect your skills
Level up your career at your current job or start a brand new career as a modern big data professional!
Requirements
- Requirements
- None
Knowledge
- SQL
- Data analysis using SQL
- How to set up a FREE Google BQ sandbox environment to practice
- SQL Language & Syntax
- How to JOIN your data in a variety of ways to unlock more insight
- Aggregations (SUM, AVG, MIN, MAX) using SQL
- Powerful Analytic & Window Functions
- Scheduling queries to automate workflows
- Downloading data into CSVs
- Creating your own tables and views
- Query history to keep track of your work