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://www.pivotalstats.com/datasets
GCP link ********************
https://console.cloud.google.com/
Complete List of Operators in BigQuery ********************
https://cloud.google.com/bigquery/doc...
More Info on Views ********************
https://www.datacamp.com/tutorial/vie...
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
Watch video SQL Bootcamp - Learn SQL in 2 Hours | Beginners | GCP | BigQuery | [Full Course] online without registration, duration hours minute second in high quality. This video was added by user Pivotalstats 23 March 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3,64 once and liked it 12 people.