English | MP4 | AVC 1920×1080 | AAC 48KHz 2ch | 2h 49m | 706 MB
Extend your knowledge of SQL, databases, and BI by mastering complex topics such as materialized views, common table expressions, and advanced data grouping
This example-driven course provides thoughtful and interactive commentary throughout. We understand the common mistakes and misconceptions you might make and help you navigate tricky SQL concepts.
Window Functions are used in detail throughout the course to solve problems dealing with finding the first order or the Nth instance of an event, computing the timing between events, and new and repeat purchase behaviors among customers. You’ll run through the workflow from SQL to a localhost connection in Tableau and also analysis, all of which you’ll need in your professional life. Concepts such as CASE statements, common table expressions, and subqueries will be explained via case studies. You’ll generate web analytics acquisition source data using Python and then create tables to store your information.
By the end of the course, you will have gone through all the examples and coded them out, and you’ll be ready to confidently tackle non-trivial problems. Supercharge your data productivity today with this course and get 100x your time investment back in the next year or two!
This course will teach you to master real-world SQL, write complex queries, and answer very specific questions. In short, it will help you think in SQL.
What You Will Learn
- Put SQL to work for Business Intelligence
- Develop your SQL skills to advance your career
- Master advanced topics such as materialized views, common table expressions, advanced data grouping, and more!
- Bring data into Excel, Tableau or other business software for further analysis and visualization
- Uncover key insights about your customers, suppliers, and business performance
- Use your database to make crucial business decisions and grow the bottom line
- Avoid common mistakes that cost you credibility and time.
Table of Contents
Installing Postgres and Our Initial Dataset
1 The Course Overview
2 Installation on Windows and Mac Via Postgres App
3 Installing pgAdmin
4 Downloading and Restoring the DVD Rental Database
SQL in the Real World and Customer Value Analysis
5 Finding First Orders
6 The Window Function ROW_NUMBER() and Using a CTE to Find First Orders
7 Analyzing New Versus Repeat Buyer Behavior
8 Customer Value Analysis_LTV Case Study Part One
9 Customer Value Analysis_LTV Case Study Part Two
Time between Events and Mastering Window Functions
10 The LAG Function
11 Time between Customer Orders
12 Analyzing Our Time Since Behavioral Data
13 NTILE Window Function
Freeform Analysis of the DVD Rental Database
14 First Orders
15 Top Five Highest Grossing Actors
16 Films by Most Gross Revenue Per Actor
17 Does First Rating Rented from Predict Lifetime Value
Additional Advanced Analysis of the Database#
18 Cross Shopping
19 Computing LTV Summary Metrics Using Correlate Subqueries
20 CPA and Profitability Analysis Project – Part One
21 CPA and Profitability Analysis Project – Part Two
Resolve the captcha to access the links!