Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Google BigQuery and PostgreSQL: BigQuery for Data Analysis
Introduction
Welcome to the Course (3:05)
Course Flow (6:42)
Installation and Getting Started
PostgreSQL and PGAdmin Installation (9:33)
Setting Up BigQuery on Google Cloud Platform (8:17)
BigQuery Interface (18:07)
Fundamental SQL Statements
CREATE (11:49)
CREATE in BigQuery (12:50)
Exercise 1: Create DB and Table (1:27)
INSERT (9:10)
INSERT in BigQuery (6:25)
Import Data from File (5:00)
Importing Data from File Using BigQuery Web User Interface (11:14)
File Upload in Google BigQuery Through Google Cloud sdk (11:07)
Importing Data from Google Drive (10:12)
Exercise 2: Inserting and Importing (0:56)
SELECT (3:47)
SELECT in BigQuery (3:53)
SELECT DISTINCT (6:06)
SELECT DISTINCT in BigQuery (2:56)
WHERE Function (4:04)
WHERE in BigQuery (5:46)
Logical Operators - AND, OR, NOT (6:11)
Logical Operators in BigQuery (7:30)
Exercise 3: SELECT and WHERE (1:18)
UPDATE (5:24)
UPDATE in BigQuery (3:05)
DELETE (4:12)
DELETE in BigQuery (3:14)
ALTER (17:22)
ALTER in BigQuery (3:21)
Exercise 4: Updating Table (1:00)
Restore and Backup
Restore and Backup (7:37)
Debugging Restoration (8:27)
Creating DB Using CSV Files (5:41)
Data Set Creation in BigQuery (11:11)
Exercise 5: Restore and Backup (0:51)
Selection Commands: Filtering
IN (4:26)
IN in BigQuery (2:54)
BETWEEN (5:42)
BETWEEN in BigQuery (4:07)
LIKE (8:52)
LIKE in BigQuery (7:41)
Exercise 6: IN, LIKE, and BETWEEN (0:46)
Selection Commands: Ordering
ORDER BY (7:41)
ORDER BY in BigQuery (4:41)
LIMIT (3:40)
LIMIT in BigQuery (5:51)
ORDER BY - Exercise (0:44)
Alias
AS (3:33)
AS in BigQuery (2:25)
Aggregate Commands
COUNT (5:14)
COUNT in BigQuery (4:46)
SUM (3:23)
SUM in BigQuery (2:00)
AVERAGE (2:52)
AVERAGE in BigQuery (3:10)
MIN MAX (4:16)
MIN MAX in BigQuery (2:54)
Exercise 8: Aggregate Functions (1:15)
Group By Commands
GROUP BY (11:52)
GROUP BY in BigQuery (5:37)
HAVING (5:05)
HAVING in BigQuery (4:45)
Exercise 9: Group By (1:06)
Conditional Statement
CASE WHEN (5:20)
CASE WHEN in BigQuery (6:14)
JOINS
Introduction to Joins (2:55)
Concepts of Joining and Combining Data (12:01)
Preparing the Data (2:03)
Creating Datasets for Joins in BigQuery (3:40)
Inner Join (8:02)
INNER JOIN in BigQuery (7:42)
Left Join (7:30)
LEFT JOIN in BigQuery (4:08)
Right Join (6:28)
RIGHT JOIN in BigQuery (5:05)
Full Outer Join (4:59)
FULL OUTER JOIN in BigQuery (5:09)
Cross Join (4:22)
CROSS JOIN in BigQuery (4:25)
Intersect and Intersect ALL (7:09)
Except (2:54)
EXCEPT in BigQuery (4:43)
Union (3:09)
UNION in BigQuery (4:41)
Exercise 10: Joins (1:08)
Subqueries
Subqueries (14:34)
Subqueries in BigQuery (5:53)
Exercise 11: Subqueries (1:11)
Views and Indexes
Views (7:22)
Views in Google BigQuery (3:20)
Index (6:39)
Indexes in BigQuery (1:33)
Exercise 12: Views (0:43)
String Functions
LENGTH (3:31)
LENGTH in BigQuery (3:12)
UPPER LOWER (2:12)
Changing Case in BigQuery (2:06)
REPLACE (4:14)
REPLACE in BigQuery (3:11)
TRIM, LTRIM, RTRIM (6:57)
TRIM, LTRIM, RTRIM in BigQuery (5:18)
CONCATENATION (2:58)
CONCATENATION in BigQuery (5:28)
SUBSTRING (6:02)
SUBSTRING in Google BigQuery (5:43)
LIST AGGREGATION (5:03)
LIST AGGREGATION in Google BigQuery (5:10)
Exercise 13: String Functions (2:30)
Mathematical Functions
CEIL and FLOOR (3:33)
CEIL and FLOOR in BigQuery (5:50)
RANDOM (5:09)
RANDOM in BigQuery (5:38)
SETSEED (4:13)
SETSEED in BigQuery (0:23)
ROUND (2:28)
POWER (2:27)
POWER in BigQuery (2:00)
Exercise 14: Mathematical Functions (1:34)
Date-Time Functions
CURRENT DATE and TIME (4:32)
CURRENT DATE and TIME in BigQuery (4:53)
AGE (3:52)
AGE in BigQuery (8:14)
EXTRACT (8:20)
EXTRACT in BigQuery (3:52)
Exercise 15: Date-Time Functions (1:15)
Pattern (STRING) Matching
PATTERN MATCHING BASICS (7:40)
ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS) (15:22)
PATTERN MATCHING in BigQuery (7:58)
Exercise 16: Pattern Matching (1:44)
Google Data Studio to Visualize BigQuery Data
Google Data Studio to Visualize BigQuery Data (3:43)
Welcome to the Course
This video introduces you to the course.
Complete and Continue