Google Bigquery:hands-on SQL Training

via

Skillshare

Course Features

Duration

2.3 hours

Delivery Method

Online

Available on

Lifetime Access

Accessibility

Mobile, Desktop

Language

English

Subtitles

English

Level

Beginner

Teaching Type

Self Paced

Video Content

2.3 hours

Course Description

What is Google BigQuery?

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

Course Overview

International Faculty

Post Course Interactions

Hands-On Training,Instructor-Moderated Discussions

Case Studies, Captstone Projects

Skills You Will Gain

What You Will Learn

Aggregate Functions

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

Case Statement and IF Function

Joins in SQL

Operator in SQL

SubQuery in SQL

Course Content

Expand all sections

Module 1: Introduction

Module 2: Setting Up BiqQuery Standbox Account

Module 3: Signing Up for Month Free Account

Module 4: Upper,Lower,Trim and Substring Function in SQL

Course Instructors

Saad Qureshi

Online Instructor

Background:Computer Scientist with overall 5 years of industry and several years of freelancing experience. Other than this,I am passionate about teaching and guiding students learning programming la...