Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Google BigQuery:Hands-On SQL Training for Data Analysis
Rating: 3.6 out of 5(18 ratings)
101 students

Google BigQuery:Hands-On SQL Training for Data Analysis

Google BigQuery course to teach you concepts like Joins,Subquery Aggregate Functions,Analytical Functions etc
Created bySaad Qureshi
Last updated 8/2020
English

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

Course content

8 sections • 28 lectures • 3h 4m total length

  • Introduction1:05
  • Setting Up BiqQuery Standbox Account8:55
  • Signing Up for 12 Month Free Account3:54

    Enable billing to access Google BigQuery, create a dataset and table, insert values with SQL, and start the 300 USD free trial for hands-on data analysis.

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.

Report abuse