Completed
⌨️ Transform columns with SELECT
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Intuitive SQL for Data Analytics - Tutorial
Automatically move to the next video in the Classroom when playback concludes
- 1 ⌨️ Introduction
- 2 ⌨️ Syllabus & resources
- 3 ⌨️ Meet SQL!
- 4 ⌨️ Types of SQL statements
- 5 ⌨️ Why BigQuery
- 6 ⌨️ How to setup Google Cloud
- 7 ⌨️ How to avoid Google Cloud charges
- 8 ⌨️ Introduction to our data
- 9 ⌨️ How data is organized in BigQuery
- 10 ⌨️ Loading our data in BigQuery
- 11 ⌨️ The BigQuery Interface
- 12 ⌨️ Running our first query
- 13 ⌨️ How SQL organizes data
- 14 ⌨️ The SQL statement
- 15 ⌨️ The three orders of SQL operations
- 16 ⌨️ The logical order of SQL operations
- 17 ⌨️ Introduction to basics
- 18 ⌨️ SELECT and FROM
- 19 ⌨️ Transform columns with SELECT
- 20 ⌨️ The order of arithmetic operations
- 21 ⌨️ The WHERE filter
- 22 ⌨️ Boolean algebra
- 23 ⌨️ DISTINCT
- 24 ⌨️ Create BigQuery tables from queries
- 25 ⌨️ UNION 1
- 26 ⌨️ UNION 2
- 27 ⌨️ UNION 3
- 28 ⌨️ UNION 4
- 29 ⌨️ ORDER BY
- 30 ⌨️ LIMIT
- 31 ⌨️ CASE
- 32 ⌨️ Simple aggregations
- 33 ⌨️ Subqueries 1
- 34 ⌨️ Subqueries 2
- 35 ⌨️ Subqueries 3
- 36 ⌨️ Nested queries
- 37 ⌨️ Common table expressions 1
- 38 ⌨️ Common table expressions 2
- 39 ⌨️ Common table expressions 3
- 40 ⌨️ Joins
- 41 ⌨️ GROUP BY And Aggregations
- 42 ⌨️ Window Functions
- 43 ⌨️ Putting It All Together
- 44 ⌨️ Let's Solve A Hard SQL Challenge!
- 45 ⌨️ PostgreSQL Exercises - Introduction
- 46 ⌨️ PostgreSQL Exercises - Basic
- 47 ⌨️ PostgreSQL Exercises - Joins and Subqueries
- 48 ⌨️ PostgreSQL Exercises - Aggregations Pt. 1
- 49 ⌨️ PostgreSQL Exercises - Aggregations Pt. 2
- 50 ⌨️ PostgreSQL Exercises - Conclusion
