Google BigQuery & PostgreSQL : Big Query for Data Analysis

Become BigQuery expert by mastering Google BigQuery for data analysis. Cover all SQL qureies in PostgeSQL & Big Query

Created by Abhishek And Pukhraj, Last Updated 01-Oct-2020, Language:English

What Will I Get ?

Knowledge of all the essential SQL commands in BigQuery and PostgreSQL
Become proficient in SQL tools like GROUP BY, JOINS and Subqueries
Become competent in using sorting and filtering commands in SQL

Requirements

Just a PC with any web browser

Description

6 Reasons why you should choose this PostgreSQL and BigQuery course

Carefully designed curriculum teaching you everything in SQL that you will need for Data analysis in businesses
Comprehensive - covers basic and advanced SQL statements in both PostgreSQL and BigQuery
Business related examples and case studies
Ample practice exercises because SQL requires practice
Downloadable resources
Your queries will be responded by the Instructor himself

A Verifiable Certificate of Completion is presented to all students who undertake this SQL course.

Why should you choose this course?

This is a complete tutorial on SQL which can be completed within a weekend. SQL is the most sought after skill for Data analysis roles in all the companies. So whether you want to start a career as a data scientist or just grow you data analysis skills, this course will cover everything you need to know to do that.

What makes us qualified to teach you?

The course is taught by Abhishek and Pukhraj. Instructors of the course have been teaching Data Science and Machine Learning for over a decade.

Our Promise

Teaching our students is our job and we are committed to it. If you have any questions about the course content, practice sheet or anything related to any topic, you can always post a question in the course or send us a direct message.

Who this course is for:

Working Professionals beginning their Data journey
Anyone curious to master SQL from beginner to Advanced in short span of time

Course Content

Introduction

3 Lectures 00:09:54
- Welcome to the Course
  
  Preview
  
  00:03:13
- Course Flow
  
  Preview
  
  00:06:41
- Course Resources
Installation and getting started

3 Lectures 00:35:51
- PostgreSQL and PGAdmin Installation
  
  Preview
  
  00:09:30
- Setting up BigQuery on Google Cloud Platform
  
  00:08:15
- BigQuery Interface
  
  Preview
  
  00:18:06
Fundamental SQL statements

26 Lectures 02:38:47
- CREATE
  
  Preview
  
  00:11:46
- CREATE in BigQuery
  
  00:12:48
- Exercise 1: Create DB and Table
  
  00:01:24
- INSERT
  
  00:09:07
- INSERT in BigQuery
  
  00:06:23
- Import data from File
  
  00:04:59
- Importing data from File using BigQuery Web User Interface
  
  00:11:12
- File Upload in Google Big Query through Google cloud sdk
  
  00:11:07
- Importing data from Google Drive
  
  00:10:11
- Exercise 2: Inserting and Importing
  
  00:00:57
- SELECT
  
  Preview
  
  00:03:45
- SELECT in BigQuery
  
  00:03:53
- SELECT DISTINCT
  
  00:06:05
- SELECT DISTINCT in BigQuery
  
  00:02:54
- WHERE
  
  00:04:02
- WHERE in BigQuery
  
  00:05:44
- Logical Operators - AND, OR, NOT
  
  00:06:10
- Logical Operators in BigQuery
  
  00:07:28
- Exercise 3: SELECT & WHERE
  
  00:01:16
- UPDATE
  
  00:05:25
- UPDATE in BigQuery
  
  00:03:04
- DELETE
  
  00:04:11
- DELETE in BigQuery
  
  00:03:13
- ALTER
  
  00:17:21
- ALTER in BigQuery
  
  00:03:19
- Exercise 4: Updating Table
  
  00:01:03
Restore and Back-up

3 Lectures 00:19:39
- Restore and Back-up
  
  00:07:38
- Data Set creation in BigQuery
  
  00:11:10
- Exercise 5: Restore and Back-up
  
  00:00:51
Selection commands: Filtering

7 Lectures 00:34:25
- IN
  
  Preview
  
  00:04:24
- IN in BigQuery
  
  00:02:52
- BETWEEN
  
  00:05:40
- BETWEEN in BigQuery
  
  00:04:06
- LIKE
  
  00:08:52
- LIKE in BigQuery
  
  00:07:40
- Exercise 6: In, Like & Between
  
  00:00:51
Selection commands: Ordering

5 Lectures 00:22:37
- ORDER BY
  
  00:07:42
- ORDER BY in BigQuery
  
  00:04:41
- LIMIT
  
  00:03:38
- LIMIT in BigQuery
  
  00:05:49
- Exercise 7: Sorting
  
  00:00:47
Alias

2 Lectures 00:05:57
- AS
  
  00:03:33
- AS in BigQuery
  
  00:02:24
Aggregate Commands

9 Lectures 00:29:53
- COUNT
  
  Preview
  
  00:05:13
- COUNT in BigQuery
  
  00:04:47
- SUM
  
  00:03:24
- SUM in BigQuery
  
  00:01:58
- AVERAGE
  
  00:02:53
- AVERAGE in BigQuery
  
  00:03:09
- MIN MAX
  
  00:04:17
- MIN MAX in BigQuery
  
  00:02:53
- Exercise 8: Aggregate functions
  
  00:01:19
Group By Commands

5 Lectures 00:28:29
- GROUP BY
  
  00:11:52
- GROUP BY in BigQuery
  
  00:05:36
- HAVING
  
  00:05:04
- HAVING in BigQuery
  
  00:04:44
- Exercise 9: Group By
  
  00:01:13
Conditional Statement

2 Lectures 00:11:30
- CASE WHEN
  
  00:05:18
- CASE WHEN in BigQuery
  
  00:06:12
Joins

17 Lectures 01:20:42
- Introduction ot Joins
  
  Preview
  
  00:02:25
- Creating Datasets for Joins in BigQuery
  
  00:03:39
- Inner Join
  
  00:08:05
- INNER JOIN in BigQuery
  
  00:07:40
- Left Join
  
  00:07:32
- LEFT JOIN in BigQuery
  
  00:04:06
- Right Join
  
  00:06:27
- RIGHT JOIN in BigQuery
  
  00:05:02
- Full Outer Join
  
  00:04:59
- FULL OUTER JOIN in BigQuery
  
  00:05:06
- Cross Join
  
  00:04:21
- CROSS JOIN in BigQuery
  
  00:04:23
- Except
  
  00:03:00
- EXCEPT in BigQuery
  
  00:04:45
- Union
  
  00:03:13
- UNION in BigQuery
  
  00:04:41
- Exercise 10: Joins
  
  00:01:18
Subqueries

3 Lectures 00:21:47
- Subqueries
  
  00:14:35
- Subqueries in BigQuery
  
  00:05:51
- Exercise 11: Subqueries
  
  00:01:21
Views and Indexes

5 Lectures 00:19:38
- Views
  
  00:07:21
- Views in BigQuery
  
  00:03:19
- Index
  
  00:06:39
- Index in BigQuery
  
  00:01:32
- Exercise 12: Views
  
  00:00:47
String Functions

15 Lectures 01:03:11
- LENGTH
  
  Preview
  
  00:03:31
- LENGTH in BigQuery
  
  00:03:10
- UPPER LOWER
  
  00:02:10
- Changing Case in BigQuery
  
  00:02:05
- REPLACE
  
  00:04:13
- REPLACE in BigQuery
  
  00:03:10
- TRIM, LTRIM, RTRIM
  
  00:06:56
- TRIM, LTRIM, RTRIM in BigQuery
  
  00:05:16
- CONCATENATION
  
  00:02:56
- CONCATENATION in BigQuery
  
  00:05:26
- SUBSTRING
  
  00:06:01
- SUBSTRING In BigQuery
  
  00:05:41
- LIST AGGREGATION
  
  00:05:01
- LIST AGGREGATION In BigQuery
  
  00:05:08
- Exercise 13: String Functions
  
  00:02:27
Mathematical Functions

10 Lectures 00:32:59
- CEIL & FLOOR
  
  00:03:34
- CEIL & FLOOR in BigQuery
  
  00:05:47
- RANDOM
  
  00:05:06
- RANDOM in BigQuery
  
  00:05:37
- SETSEED
  
  00:04:11
- SETSEED in BigQuery
  
  00:00:22
- ROUND
  
  00:02:27
- POWER
  
  00:02:25
- POWER in BigQuery
  
  00:01:57
- Exercise 14: Mathematical Functions
  
  00:01:33
Date-Time Functions

7 Lectures 00:34:54
- CURRENT DATE & TIME
  
  00:04:31
- CURRENT DATE & TIME in BigQuery
  
  00:04:51
- AGE
  
  00:03:50
- AGE in BigQuery
  
  00:08:13
- EXTRACT
  
  00:08:17
- EXTRACT in BigQuery
  
  00:03:49
- Exercise 15: Date-time functions
  
  00:01:23
Pattern (String) Matching

4 Lectures 00:32:43
- Pattern Matching Basics
  
  00:07:44
- Advance Pattern Matching (REGULAR EXPRESSIONS)
  
  00:15:21
- Pattern Matching in BigQuery
  
  00:07:56
- Exercise 16: Pattern Matching
  
  00:01:42

Abhishek And Pukhraj

Start-Tech Academy is a technology-based Analytics Education Company and aims at Bringing Together the analytics companies and interested Learners.
Our top quality training content along with internships and project opportunities helps students in launching their Analytics journey.

Founded by Abhishek Bansal and Pukhraj Parikh.

Working as a Project manager in an Analytics consulting firm, Pukhraj has multiple years of experience working on analytics tools and software. He is competent in MS office suites, Cloud computing, SQL, Tableau, SAS, Google analytics and Python.

Abhishek worked as an Acquisition Process owner in a leading telecom company before moving on to learning and teaching technologies like Machine Learning and Artificial Intelligence.