Google BigQuery:Hands-On SQL Training for Data Analysis
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + .srt | Duration: 28 lectures (3h 4m) | Size: 1.15 GB

Google BigQuery course to teach you concepts like Joins,Subquery Aggregate Functions,Analytical Functions etc What you'll learn:
Operators in SQL
Aggregate Functions Max,Min,Average and Sum,Group By and more
Inner Join,Right,Left Outer Join and Cross Join
Rank,Dense Rank,Row Number,CSUM and MAVG etc
Case Statement and If Function

Requirements
No Experience of SQL and database are required
Windows, Mac, and Linux users are all welcome

Description
What is Google BigQuery?

Google BigQuery is an enterprise cloud data warehouse that solves this problem by enabling super-fast SQL queries using the processing power of Google's infrastructure.It is a server less Software as a Service (SaaS) that has built-in machine learning capabilities.

What are we learning in the Course?

Operator in SQL

Aggregate Functions

Joins in SQL

SubQuery in SQL

Analytical Functions:Row Number,Rank,Dense_Rank,Cumulative Sum and Cumulative Average

Case Statement and IF Function

Who this course is for
Students/Professionals curious about learning Google BigQuery
Professionals who want to learn Google BigQuery for further enhancement of their knowledge and skill sets.