Advanced Applied SQL for Business Intelligence and Analytics

Installing Postgres and Our Initial Dataset 4 lectures 12:11 The Course Overview This video gives an overview of the entire course. Installation on Windows and Mac Via Postgres App The aim of the video is to install Postgres on Mac and Windows operating systems. • For Windows, install Postgres via official site • For Mac, install Postgres via official site • Explain some basic psql commands Installing pgAdmin The aim of this video is to install pgAdmin, our SQL query interface and learn its general usage. • Know why to not use pgAdmin 4 • Download pgAdmin • Test our connection to localhost Downloading and Restoring the DVD Rental Database The aim of this video is to import our first dataset, the DVD rental database. • Download PostgreSQL sample database • Unzip to get the .tar file • Restore the DB using pgAdmin Installing Postgres and Our Initial Dataset 4 lectures 12:11 The Course Overview This video gives an overview of the entire course. Installation on Windows and Mac Via Postgres App The aim of the video is to install Postgres on Mac and Windows operating systems. • For Windows, install Postgres via official site • For Mac, install Postgres via official site • Explain some basic psql commands Installing pgAdmin The aim of this video is to install pgAdmin, our SQL query interface and learn its general usage. • Know why to not use pgAdmin 4 • Download pgAdmin • Test our connection to localhost Downloading and Restoring the DVD Rental Database The aim of this video is to import our first dataset, the DVD rental database. • Download PostgreSQL sample database • Unzip to get the .tar file • Restore the DB using pgAdmin The Course Overview This video gives an overview of the entire course. The Course Overview This video gives an overview of the entire course. The Course Overview This video gives an overview of the entire course. The Course Overview This video gives an overview of the entire course. This video gives an overview of the entire course. This video gives an overview of the entire course. Installation on Windows and Mac Via Postgres App The aim of the video is to install Postgres on Mac and Windows operating systems. • For Windows, install Postgres via official site • For Mac, install Postgres via official site • Explain some basic psql commands Installation on Windows and Mac Via Postgres App The aim of the video is to install Postgres on Mac and Windows operating systems. • For Windows, install Postgres via official site • For Mac, install Postgres via official site • Explain some basic psql commands Installation on Windows and Mac Via Postgres App The aim of the video is to install Postgres on Mac and Windows operating systems. • For Windows, install Postgres via official site • For Mac, install Postgres via official site • Explain some basic psql commands Installation on Windows and Mac Via Postgres App The aim of the video is to install Postgres on Mac and Windows operating systems. • For Windows, install Postgres via official site • For Mac, install Postgres via official site • Explain some basic psql commands The aim of the video is to install Postgres on Mac and Windows operating systems. • For Windows, install Postgres via official site • For Mac, install Postgres via official site • Explain some basic psql commands The aim of the video is to install Postgres on Mac and Windows operating systems. • For Windows, install Postgres via official site • For Mac, install Postgres via official site • Explain some basic psql commands Installing pgAdmin The aim of this video is to install pgAdmin, our SQL query interface and learn its general usage. • Know why to not use pgAdmin 4 • Download pgAdmin • Test our connection to localhost Installing pgAdmin The aim of this video is to install pgAdmin, our SQL query interface and learn its general usage. • Know why to not use pgAdmin 4 • Download pgAdmin • Test our connection to localhost Installing pgAdmin The aim of this video is to install pgAdmin, our SQL query interface and learn its general usage. • Know why to not use pgAdmin 4 • Download pgAdmin • Test our connection to localhost Installing pgAdmin The aim of this video is to install pgAdmin, our SQL query interface and learn its general usage. • Know why to not use pgAdmin 4 • Download pgAdmin • Test our connection to localhost The aim of this video is to install pgAdmin, our SQL query interface and learn its general usage. • Know why to not use pgAdmin 4 • Download pgAdmin • Test our connection to localhost The aim of this video is to install pgAdmin, our SQL query interface and learn its general usage. • Know why to not use pgAdmin 4 • Download pgAdmin • Test our connection to localhost Downloading and Restoring the DVD Rental Database The aim of this video is to import our first dataset, the DVD rental database. • Download PostgreSQL sample database • Unzip to get the .tar file • Restore the DB using pgAdmin Downloading and Restoring the DVD Rental Database The aim of this video is to import our first dataset, the DVD rental database. • Download PostgreSQL sample database • Unzip to get the .tar file • Restore the DB using pgAdmin Downloading and Restoring the DVD Rental Database The aim of this video is to import our first dataset, the DVD rental database. • Download PostgreSQL sample database • Unzip to get the .tar file • Restore the DB using pgAdmin Downloading and Restoring the DVD Rental Database The aim of this video is to import our first dataset, the DVD rental database. • Download PostgreSQL sample database • Unzip to get the .tar file • Restore the DB using pgAdmin The aim of this video is to import our first dataset, the DVD rental database. • Download PostgreSQL sample database • Unzip to get the .tar file • Restore the DB using pgAdmin The aim of this video is to import our first dataset, the DVD rental database. • Download PostgreSQL sample database • Unzip to get the .tar file • Restore the DB using pgAdmin SQL in the Real World and Customer Value Analysis 5 lectures 40:51 Finding First Orders The goal of this video is to find first orders done by revisiting the Self JOIN. • Review Self JOIN The Window Function ROW_NUMBER() and Using a CTE to Find First Orders The aim of the video is to delve more into first orders using the window function and the CTEs. • Find out what the window function “row_number()” is • Use the window function “row_number()” to compute first orders Analyzing New Versus Repeat Buyer Behavior The aim of this video is to analyze new and repeated purchases per customer. • Review and use the CASE statement • Combine our CTE for first orders with a CASE statement • Create a dimension around order number per customer Customer Value Analysis/LTV Case Study Part One The goal of this video is to work on the given case study based on customer value analysis/LTV. • Review the case study carefully • Plan out on how to work out the data required Customer Value Analysis/LTV Case Study Part Two The goal of this video is to work on the given case study based on customer value analysis/LTV. • Continue the case study worked on in the previous video • Plan out on how to work out the data required SQL in the Real World and Customer Value Analysis. 5 lectures 40:51 Finding First Orders The goal of this video is to find first orders done by revisiting the Self JOIN. • Review Self JOIN The Window Function ROW_NUMBER() and Using a CTE to Find First Orders The aim of the video is to delve more into first orders using the window function and the CTEs. • Find out what the window function “row_number()” is • Use the window function “row_number()” to compute first orders Analyzing New Versus Repeat Buyer Behavior The aim of this video is to analyze new and repeated purchases per customer. • Review and use the CASE statement • Combine our CTE for first orders with a CASE statement • Create a dimension around order number per customer Customer Value Analysis/LTV Case Study Part One The goal of this video is to work on the given case study based on customer value analysis/LTV. • Review the case study carefully • Plan out on how to work out the data required Customer Value Analysis/LTV Case Study Part Two The goal of this video is to work on the given case study based on customer value analysis/LTV. • Continue the case study worked on in the previous video • Plan out on how to work out the data required Finding First Orders The goal of this video is to find first orders done by revisiting the Self JOIN. • Review Self JOIN Finding First Orders The goal of this video is to find first orders done by revisiting the Self JOIN. • Review Self JOIN Finding First Orders The goal of this video is to find first orders done by revisiting the Self JOIN. • Review Self JOIN Finding First Orders The goal of this video is to find first orders done by revisiting the Self JOIN. • Review Self JOIN The goal of this video is to find first orders done by revisiting the Self JOIN. • Review Self JOIN The goal of this video is to find first orders done by revisiting the Self JOIN. • Review Self JOIN The Window Function ROW_NUMBER() and Using a CTE to Find First Orders The aim of the video is to delve more into first orders using the window function and the CTEs. • Find out what the window function “row_number()” is • Use the window function “row_number()” to compute first orders The Window Function ROW_NUMBER() and Using a CTE to Find First Orders The aim of the video is to delve more into first orders using the window function and the CTEs. • Find out what the window function “row_number()” is • Use the window function “row_number()” to compute first orders The Window Function ROW_NUMBER() and Using a CTE to Find First Orders The aim of the video is to delve more into first orders using the window function and the CTEs. • Find out what the window function “row_number()” is • Use the window function “row_number()” to compute first orders The Window Function ROW_NUMBER() and Using a CTE to Find First Orders The aim of the video is to delve more into first orders using the window function and the CTEs. • Find out what the window function “row_number()” is • Use the window function “row_number()” to compute first orders The aim of the video is to delve more into first orders using the window function and the CTEs. • Find out what the window function “row_number()” is • Use the window function “row_number()” to compute first orders The aim of the video is to delve more into first orders using the window function and the CTEs. • Find out what the window function “row_number()” is • Use the window function “row_number()” to compute first orders Analyzing New Versus Repeat Buyer Behavior The aim of this video is to analyze new and repeated purchases per customer. • Review and use the CASE statement • Combine our CTE for first orders with a CASE statement • Create a dimension around order number per customer Analyzing New Versus Repeat Buyer Behavior The aim of this video is to analyze new and repeated purchases per customer. • Review and use the CASE statement • Combine our CTE for first orders with a CASE statement • Create a dimension around order number per customer Analyzing New Versus Repeat Buyer Behavior The aim of this video is to analyze new and repeated purchases per customer. • Review and use the CASE statement • Combine our CTE for first orders with a CASE statement • Create a dimension around order number per customer Analyzing New Versus Repeat Buyer Behavior The aim of this video is to analyze new and repeated purchases per customer. • Review and use the CASE statement • Combine our CTE for first orders with a CASE statement • Create a dimension around order number per customer The aim of this video is to analyze new and repeated purchases per customer. • Review and use the CASE statement • Combine our CTE for first orders with a CASE statement • Create a dimension around order number per customer The aim of this video is to analyze new and repeated purchases per customer. • Review and use the CASE statement • Combine our CTE for first orders with a CASE statement • Create a dimension around order number per customer Customer Value Analysis/LTV Case Study Part One The goal of this video is to work on the given case study based on customer value analysis/LTV. • Review the case study carefully • Plan out on how to work out the data required Customer Value Analysis/LTV Case Study Part One The goal of this video is to work on the given case study based on customer value analysis/LTV ze each customer time in between orders • Use level of detailed calculations to find their minimums across a few dimensions • Bring in their order number to find the time difference between their first and second Analyzing Our Time...