SQL Business Intelligence with SQL 2-in-1

Focused View

4:46:32

8 View

1 - SQL Fundamentals for Business Intelligence

1 - SQL-Business-Intelligence-with-SQL.zip

1 - Test your knowledge.html

1 - The Course Overview.mp4

04:14

2 - Installation on Windows and Mac Via PostgresApp.mp4

03:17

2 - Test your knowledge.html

3 - Installing pgAdmin.mp4

02:16

3 - Test your knowledge.html

4 - Downloading and Restoring the DVD Rental Database.mp4

02:24

5 - SELECT, WHERE, GROUP BY, and COUNT Clauses.mp4

13:09

6 - Most Common JOINs.mp4

10:44

7 - More LEFT JOIN and SELF JOIN.mp4

09:45

8 - Everything Is a Table.mp4

07:02

9 - JOIN and Filtering Gotchas Common Errors to Avoid.mp4

07:28

10 - WHERE Versus HAVING for Filtering.mp4

08:18

11 - Subqueries.mp4

09:21

12 - Correlated Subqueries.mp4

06:00

13 - Common Table Expressions (CTEs).mp4

07:37

14 - Dealing with Dates and Times.mp4

07:28

15 - The CASE Statement.mp4

05:58

16 - Inserting External Data.mp4

11:54

2 - Advanced Applied SQL for Business Intelligence and Analytics

17 - The Course Overview.mp4

03:34

18 - Installation on Windows and Mac Via Postgres App.mp4

03:00

19 - Installing pgAdmin.mp4

02:43

20 - Downloading and Restoring the DVD Rental Database.mp4

02:52

21 - Finding First Orders.mp4

06:26

22 - The Window Function ROW NUMBER() and Using a CTE to Find First Orders.mp4

07:02

23 - Analyzing New Versus Repeat Buyer Behavior.mp4

10:36

24 - Customer Value Analysis LTV Case Study Part One.mp4

06:30

25 - Customer Value Analysis LTV Case Study Part Two.mp4

10:15

26 - The LAG Function.mp4

06:51

27 - Time between Customer Orders.mp4

08:04

28 - Analyzing Our Time Since Behavioral Data.mp4

10:04

29 - NTILE Window Function.mp4

08:54

30 - First Orders.mp4

08:18

31 - Does First Rating Rented from Predict Lifetime Value.mp4

07:05

32 - Top Five Highest Grossing Actors.mp4

13:17

33 - Films by Most Gross Revenue Per Actor.mp4

11:02

34 - Cross Shopping.mp4

07:51

35 - Computing LTV Summary Metrics Using Correlate Subqueries.mp4

10:30

36 - CPA and Profitability Analysis Project Part One.mp4

11:09

37 - CPA and Profitability Analysis Project Part Two.mp4

13:34

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Packt is a publishing company founded in 2003 headquartered in Birmingham, UK, with offices in Mumbai, India. Packt primarily publishes print and electronic books and videos relating to information technology, including programming, web design, data analysis and hardware.