Google BigQuery & PostgreSQL : Big Query for Data Analysis
Created by Abhishek And Pukhraj, Last Updated 01-Oct-2020, Language:English
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
Preview00:03:13 -
Course Flow
Preview00:06:41 -
Course Resources
-
-
Installation and getting started
3 Lectures 00:35:51-
PostgreSQL and PGAdmin Installation
Preview00:09:30 -
Setting up BigQuery on Google Cloud Platform
00:08:15 -
BigQuery Interface
Preview00:18:06
-
-
Fundamental SQL statements
26 Lectures 02:38:47-
CREATE
Preview00: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
Preview00: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
Preview00: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
Preview00: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
Preview00: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 intro
00:06:39 -
Index in BigQuery
00:01:32 -
Exercise 12: Views
00:00:47
-
-
String Functions
15 Lectures 01:03:11-
LENGTH
Preview00: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.