SQL Bootcamp - Learn SQL in 2 Hours | Beginners | GCP | BigQuery | [Full Course]

Описание: Comprehensive SQL Crash Course designed specifically for data professional | Data Analyst. No Prior Knowledge Needed *****************

Timecodes
0:00 - Intro
0:53 - GCP BigQuery Interface
3:00 - Creating Dataset & Importing Data
9:26 - Using Select & Distinct
15:14 - Using Filters & Operations with Select
19:47 - Using Limit & Subqueries
26:22 - Aggregation, Grouping & Alias
33:40 - Like & Wildcards
38:08 - Having Clause
40:55 - Union All & Union Distinct
45:05 - Joins
52:14 - Case Statements
58:46 - Unnest & Struct with Arrays
1:04:12 - Update Statements
1:10:16 - Insert Statements
1:14:42 - Delete Statements
1:18:25 - Intro to Window or Analytic Function
1:23:17 - Moving Average with Window Function
1:28:36 - Lag Function
1:32:13 - Date & Extract Function
1:37:49 - Text Manipulation Functions
1:46:08 - Schedule Queries & Create Stored Procedures
1:57:54 - Standard Vs. Materialized Views


Data Used ********************
https://pivotalstats.com/wp-content/u...


GCP link ********************
https://console.cloud.google.com/


Complete List of Operators in BigQuery ********************
https://cloud.google.com/bigquery/doc...



Visit my blog for more content :
https://www.pivotalstats.com/


***************Affiliate Links***************

Best Youtube Analytics - TubeBuddy:
https://www.tubebuddy.com/pricing?a=p...

Best Web Hosting Service - Bluehost:
https://bluehost.sjv.io/k0OkNv





sql tutorial,sql tutorial for beginners,sql,sql for beginners,learn sql,mysql tutorial,sql course,sql basics,sql training,mysql tutorial for beginners,sql tutorial complete,sql beginner tutorial,sql full course,sql basics for beginners,sql beginners,sql database tutorial for beginners,advanced sql tutorial,sql tutorial advanced,sql server tutorial,learn sql for beginners,sql complete tutorial,sql tutorial for beginnners,sql crash course