28:52

23.2 INNER JOIN Example DIY (FEC Data)

12:30

23.1 INNER JOIN Sight-reading Practice (FEC Data)

24:28

22.1 INNER JOIN (FEC Election Data)

23:04

21.1 SQL INNER JOIN (DIY)

26:07

20.2 Joins Syntax + Example

07:47

20.1 Joins, Joins, Joins (SQL INNER JOIN)

12:29

19.3 UNIONS (DIY)

05:00

19.2 Unions Part Deux (Tips & Tricks with Unions)

11:17

19.1 SQL Unions Introduction

27:51

18.1 Multi Subquery & CTE practice

10:59

17.2 Multiple SubQueries

07:31

16.2 Complex WHERE filters: Using AND, OR, & IN

24:21

17.1 Multiple CTEs

11:55

16.1 CTE & SubQuery Practice Get Your Reps IN final

07:32

15.2 We all live in a yellow SubQuery

15:09

15.1 CTE Easy as 1,2,3

23:39

14.3 Conditional Logic Practice (DIY)

14:04

14.2 Get off my CASE (learning CASE conditional logic in SQL)

14:49

14.1 IF/THEN WHAT? Introducing Conditional Logic in SQL

22:09

13.1 Data Manipulation DIY

04:26

12.3 Building your String Tool belt

27:22

12.2 Cleaning Data Example

09:07

12.1 Dirty Data

05:53

11.3 Building your Mathy Toolbelt

17:59

11.2 Mathy Examples

05:55

11.1 Math-matize me Cap'n

24:05

10.2 COUNT DISTINCT(DIY)

14:35

10.1 COUNT DISTINCT

14:53

9.3 GROUP BY DIY - Examples + Solutions

13:22

9.2 Think like an Analyst (GROUP BY)

16:51

9.1 Practice, practice, practice (GROUP BY)

18:32

8.2 Date functions in BigQuery

12:57

8.1 Introducing Level of Data & GROUPBY

12:46

7.3 DIY WHERE Practice

11:04

7.2 WHERE Demo

05:34

7.1 Where o where are we going

07:39

6.2 ORDER BY DIY

01:46

tips on analytic roles to apply for when switching careers

10:00

6.1 ORDER BY

09:28

5.2 DISTINCT Example

12:46

5.1 Welcome Mr. Distinct-uished

06:01

4.3 Your First Query

04:45

4.2 BigQuery Filepaths

14:03

4.1 My First Query

10:33

3.3 Booting up BigQuery

05:15

3.2 Writing Effective Notes in BigQuery 📝

10:50

3.1 BigQuery Formatting Basics 📝

08:51

2.3 Data Table - Learn about BigQuery Table Schemas

09:55

2.2 Data Tables - What's your Data Type

07:15

2.1 Data Table - What is a Data Type

10:07

1.3 Coding + BQ Overview

04:50

1.2 Expect from Data Career

10:22

1.1 What is C2C

05:31

Quick Tips for Staying Organized in Coding Journey

09:00

How to get started with Google BigQuery (SQL)

15:39

$10,000 Coding Bootcamp Review

12:21

How to Approach a Data Project - a Framework

02:20

A Gentle Introduction to Cross Joints 🎥

01:03

How to do a multinested Subquery #dataanalytics #coding #beginnercoder #womenintech #sql #bigquery

16:15

CTE vs SubQuery