SQL (Intermediate to Advanced)
33 videos • 24,047 views • by Jeffrey James
Udemy said the audio was bad, so I uploaded it to YouTube. Enjoy!
1
PostgreSQL - Setting Up the Database and Left vs Inner Joins
Jeffrey James
Download
2
Basics of SQL Joins using DVD Rental Database
Jeffrey James
Download
3
Intro To Date Parsing and Time Series Data in SQL
Jeffrey James
Download
4
SQL - Get Day of Week With extract() + CASE statement
Jeffrey James
Download
5
More Date and Time Analysis Using SQL
Jeffrey James
Download
6
SQL - Finding Top Grossing Genres Within Each Rating
Jeffrey James
Download
7
Handling Missing Dates in SQL
Jeffrey James
Download
8
Caution - Generate Series Illustrating Left vs Inner Joins and Dangers of Not Understanding Them :)
Jeffrey James
Download
9
Filtering your database using an external data source.
Jeffrey James
Download
10
Using postgres regexp_replace to clean text data
Jeffrey James
Download
11
Postgres Generate Series and Inner vs Left Joins
Jeffrey James
Download
12
Array Operations in Postgres - Grouping to An Array
Jeffrey James
Download
13
Finding Customers by Unique Genres Rented
Jeffrey James
Download
14
SQL For Actors with the Most Films
Jeffrey James
Download
15
Postgres - Top Movies by Genre, Window Functions and CTE's
Jeffrey James
Download
16
SQL - everything is a table, some more joining basics
Jeffrey James
Download
17
SQL - Find New Customers by Date of Acquisition
Jeffrey James
Download
18
Abstract Intro the ROW_NUMBER Window Function Using Random Data
Jeffrey James
Download
19
Simulate ROW_NUMBER() Without Window Functions
Jeffrey James
Download
20
Postgres - Use Row_Number to Find Customer First Orders
Jeffrey James
Download
21
First Customer Order With Subquery But No Common Table Expression
Jeffrey James
Download
22
Using a Common Table Expression To Find Customer 1st Order Date
Jeffrey James
Download
23
SQL - Break out Customer Orders by New vs Repeat
Jeffrey James
Download
24
SQL - Do Customers Spend More On 1st or 2nd Order?
Jeffrey James
Download
25
The SUM(CASE WHEN pattern in SQL to compute valued columns
Jeffrey James
Download
26
A Gentle Intro to the LAG() Window Function in SQL
Jeffrey James
Download
27
Use LAG() To find timing between the 1st and 2nd Customer Order
Jeffrey James
Download
28
Use Correlated Subqueries to Find First 7 and First 30 Days Revenues
Jeffrey James
Download
29
PostgresSQL Row Number (Hourly sales for each staff member)
Jeffrey James
Download
30
Compute Moving Averages Using Postgres
Jeffrey James
Download
31
SQL - Multiple Row_Number functions addressing different partitions
Jeffrey James
Download
32
Postgres split_part, plus CASE stmt tutorial
Jeffrey James
Download
33
SQL Row Number / Window Function Example - Top NY Baby Names by Year
Jeffrey James
Download