Google BigQuery-Hands-On SQL Training for Data Analysis

Google BigQuery:Hands-On SQL Training for Data Analysis, available at $29.99, has an average rating of 3.55, with 28 lectures, based on 16 reviews, and has 82 subscribers.

You will learn about 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 This course is ideal for individuals who are Students/Professionals curious about learning Google BigQuery or Professionals who want to learn Google BigQuery for further enhancement of their knowledge and skill sets. It is particularly useful for Students/Professionals curious about learning Google BigQuery or Professionals who want to learn Google BigQuery for further enhancement of their knowledge and skill sets.

Enroll now: Google BigQuery:Hands-On SQL Training for Data Analysis

Summary

Title: Google BigQuery:Hands-On SQL Training for Data Analysis

Price: $29.99

Average Rating: 3.55

Number of Lectures: 28

Number of Published Lectures: 28

Number of Curriculum Items: 30

Number of Published Curriculum Objects: 30

Original Price: $199.99

Quality Status: approved

Status: Live

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

Who Should Attend

Students/Professionals curious about learning Google BigQuery

Professionals who want to learn Google BigQuery for further enhancement of their knowledge and skill sets.

Target Audiences

Students/Professionals curious about learning Google BigQuery

Professionals who want to learn Google BigQuery for further enhancement of their knowledge and skill sets.

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

Course Curriculum

Chapter 1: Google BigQuery Getting Started

Lecture 1: Introduction

Lecture 2: Setting Up BiqQuery Standbox Account

Lecture 3: Signing Up for 12 Month Free Account

Chapter 2: Google BigQuery: String & Date Time Functions

Lecture 1: Upper,Lower,Trim and Substring Function in SQL

Lecture 2: Concat,Replace and Split Function in SQL

Chapter 3: Google BigQuery: Operators in SQL

Lecture 1: Operators in SQL

Lecture 2: AND Operator

Lecture 3: OR Operator

Lecture 4: IN Operator

Lecture 5: Like Operator

Lecture 6: Between Operator

Chapter 4: Google BigQuery:Aggregate Functions

Lecture 1: Aggregate Functions

Lecture 2: Group by Statement Explanation

Lecture 3: Example of Aggregate Functions

Lecture 4: Aggregate by day, week and month in BigQuery

Chapter 5: Google BigQuery: Joins

Lecture 1: Inner Join

Lecture 2: Outer Join

Lecture 3: Example of Inner Join,Outer Join

Lecture 4: Self Join

Lecture 5: Cartesian Join

Chapter 6: Google BigQuery: SubQuery

Lecture 1: Subquery Explanation With Multiple Examples

Lecture 2: Correlated Subquery

Chapter 7: Google BigQuery:Analytical Functions

Lecture 1: Row Number

Lecture 2: Rank and Dense Rank Functions

Lecture 3: Rank and Dense Rank Example

Lecture 4: Cumulative Sum and Moving Average

Chapter 8: Google BigQuery:Advanced Concepts

Lecture 1: Case Statement

Lecture 2: IF() Function

Instructors

Saad Qureshi
Computer Scientist || Freelancer || Programmer

Rating Distribution

1 stars: 3 votes

2 stars: 0 votes

3 stars: 5 votes

4 stars: 4 votes

5 stars: 4 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!