Udemy - Complete SQL for Data Analytics and Business Intelligence (1.2025)

01. Introduction to Data Analytics/1. Data Roles and Responsibilities.mp4

32.45 MB

02. Setting up Local Environment/1. Section Introduction.mp4

1.11 MB

02. Setting up Local Environment/2. Database Servers and Clients.mp4

128.18 MB

02. Setting up Local Environment/2. server_client.png

344.39 KB

02. Setting up Local Environment/3. Local Set up - Mac.mp4

101.21 MB

02. Setting up Local Environment/4. Local Set up - Windows.mp4

50.67 MB

02. Setting up Local Environment/5. Getting Familiar with pgAdmin.mp4

46.12 MB

02. Setting up Local Environment/6. 2024-12-02_14-38-07-ea5fafe8a3a58701a11f427500a28607.png

344.39 KB

02. Setting up Local Environment/6. Lecture Notes.html

851 B

03. Database Terminologies/1. Database and Schema.mp4

16.32 MB

03. Database Terminologies/2. Tables.mp4

16.88 MB

03. Database Terminologies/3. Multiple databases and schemas.mp4

40.19 MB

03. Database Terminologies/4. Creating a Database.mp4

55.89 MB

03. Database Terminologies/5.1 Database Schema.html

16.56 KB

03. Database Terminologies/6. Lecture Notes.html

1.4 KB

03. Database Terminologies/7. Interview Questions.html

741 B

04. Creating Table and Inserting Data into the Table/1. Section Introduction.mp4

16.81 MB

04. Creating Table and Inserting Data into the Table/10. Lecture Notes.html

4.54 KB

04. Creating Table and Inserting Data into the Table/11.3 Data Types.html

22.94 KB

04. Creating Table and Inserting Data into the Table/2. Numeric Data Types.mp4

35.6 MB

04. Creating Table and Inserting Data into the Table/3.2 SERIAL Data Type.html

16.15 KB

04. Creating Table and Inserting Data into the Table/4. Character Data Types.mp4

40.54 MB

04. Creating Table and Inserting Data into the Table/5. Date and Time Data Types.mp4

21.27 MB

04. Creating Table and Inserting Data into the Table/6. Boolean Data Type.mp4

6.53 MB

04. Creating Table and Inserting Data into the Table/7. Other Important Data Types.mp4

27.56 MB

04. Creating Table and Inserting Data into the Table/8. create_table.sql

199 B

04. Creating Table and Inserting Data into the Table/8. Creating a Table.mp4

30.24 MB

04. Creating Table and Inserting Data into the Table/9. insert_rows.sql

484 B

04. Creating Table and Inserting Data into the Table/9. Inserting Data into Table.mp4

107.74 MB

05. Reading Data From Table/1. Section Introduction.mp4

5.35 MB

05. Reading Data From Table/2. The SELECT statement.mp4

25.91 MB

05. Reading Data From Table/3. Common String Operators and Functions.mp4

122.49 MB

05. Reading Data From Table/3. string_functions.sql

450 B

05. Reading Data From Table/4. Using Comments in SQL.mp4

29.58 MB

05. Reading Data From Table/5. Lecture Notes.html

1.34 KB

05. Reading Data From Table/6.4 String Operators and Functions.html

19.74 KB

05. Reading Data From Table/7.5 Alias for column name.html

16.22 KB

06. Filtering Records/1. Section Introduction.mp4

5.69 MB

06. Filtering Records/10.1 Interview Question (Tesla).html

6.52 KB

06. Filtering Records/2. The WHERE Clause.mp4

44.03 MB

06. Filtering Records/3. Comparison operators in WHERE Clause.mp4

35.02 MB

06. Filtering Records/4. Using WHERE with a List of Values.mp4

25.83 MB

06. Filtering Records/5. Using WHERE within a specified range.mp4

32.72 MB

06. Filtering Records/6. Using WHERE with pattern matching.mp4

38.97 MB

06. Filtering Records/7. Compound WHERE Clause.mp4

27.85 MB

06. Filtering Records/8. 2024-11-05_14-37-46-5a167c0f7681a228041f564c25cd2542.png

100.67 KB

06. Filtering Records/8. filtering_records.sql

883 B

06. Filtering Records/8. Lecture Notes.html

1.19 KB

06. Filtering Records/9.6 Comparison Operators and Pattern Matching.html

24.93 KB

07. Updating and Deleting Records/1. Section Introduction.mp4

5.54 MB

07. Updating and Deleting Records/2. update_records.sql

374 B

07. Updating and Deleting Records/2. Updating Records in a Table.mp4

47.45 MB

07. Updating and Deleting Records/3. delete_records.sql

207 B

07. Updating and Deleting Records/3. Deleting Records from a Table.mp4

36.81 MB

07. Updating and Deleting Records/4. Dropping a Table from Database.mp4

19.81 MB

07. Updating and Deleting Records/5. Lecture Notes.html

1.27 KB

07. Updating and Deleting Records/6.7 Update and Delete Operations.html

20.27 KB

08. Table Relationships and Constraints/1. Section Introduction.mp4

98.66 MB

08. Table Relationships and Constraints/10. Lecture Notes.html

9.38 KB

08. Table Relationships and Constraints/11.8 Table Relationships and Column Constraints.html

23.01 KB

08. Table Relationships and Constraints/2. One-to-Many and Many-to-One Relationships.mp4

50.55 MB

08. Table Relationships and Constraints/3. One-to-One and Many-to-Many Relationships.mp4

44.98 MB

08. Table Relationships and Constraints/4. Primary Keys.mp4

128.47 MB

08. Table Relationships and Constraints/5. Foreign Keys.mp4

102.82 MB

08. Table Relationships and Constraints/6. Foreign Key Constraint on Delete.mp4

104.42 MB

08. Table Relationships and Constraints/7. Foreign Key Constraint on Insert.mp4

28.53 MB

08. Table Relationships and Constraints/8. Other Column Constraints.mp4

120.29 MB

08. Table Relationships and Constraints/9. Getting Table Schema Information.mp4

77.95 MB

09. Joining Tables (SQL Joins)/1. Section Introduction.mp4

11.4 MB

09. Joining Tables (SQL Joins)/10. Exercise 2.mp4

47.13 MB

09. Joining Tables (SQL Joins)/11. Exercise 3.mp4

93.11 MB

09. Joining Tables (SQL Joins)/12. Exercise 4.mp4

74.04 MB

09. Joining Tables (SQL Joins)/13. Join with Filter.mp4

57.2 MB

09. Joining Tables (SQL Joins)/14. Lecture Notes.html

4.24 KB

09. Joining Tables (SQL Joins)/15.9 Joining Tables.html

22.55 KB

09. Joining Tables (SQL Joins)/16.2 Interview Question (TikTok).html

7.71 KB

09. Joining Tables (SQL Joins)/2. Preparing Dataset.mp4

115.36 MB

09. Joining Tables (SQL Joins)/2. shopeasy_dataset.sql

2.83 KB

09. Joining Tables (SQL Joins)/3. Why do we need Joins.mp4

20.44 MB

09. Joining Tables (SQL Joins)/4. Inner Join.mp4

91.66 MB

09. Joining Tables (SQL Joins)/4. inner_join.png

577.86 KB

09. Joining Tables (SQL Joins)/4. inner_join.sql

532 B

09. Joining Tables (SQL Joins)/5. Left Outer Join.mp4

109.81 MB

09. Joining Tables (SQL Joins)/5. left_join.png

626.17 KB

09. Joining Tables (SQL Joins)/5. left_join.sql

565 B

09. Joining Tables (SQL Joins)/6. Right Outer Join.mp4

69.1 MB

09. Joining Tables (SQL Joins)/6. right_join.png

641.39 KB

09. Joining Tables (SQL Joins)/6. right_join.sql

717 B

09. Joining Tables (SQL Joins)/7. Full Outer Join.mp4

67.34 MB

09. Joining Tables (SQL Joins)/7. full_join.png

683.1 KB

09. Joining Tables (SQL Joins)/7. full_outer.sql

399 B

09. Joining Tables (SQL Joins)/8. Exercise 1.mp4

107.9 MB

09. Joining Tables (SQL Joins)/9. Table and Column Alias.mp4

25.98 MB

10. Grouping and Aggregating Records/1. Section Introduction.mp4

34.42 MB

10. Grouping and Aggregating Records/10.10 Grouping and Aggregating Records.html

19.28 KB

10. Grouping and Aggregating Records/11.3 Interview Question (LinkedIn).html

5.45 KB

10. Grouping and Aggregating Records/12.4 Interview Question (New York Times).html

6.03 KB

10. Grouping and Aggregating Records/2. Aggregate Functions.mp4

114.06 MB

10. Grouping and Aggregating Records/2. aggregate_functions.sql

726 B

10. Grouping and Aggregating Records/3. Why do we group records.mp4

66.1 MB

10. Grouping and Aggregating Records/4. Visualizing GROUP BY Operation.mp4

107.07 MB

10. Grouping and Aggregating Records/5. Combining Grouping and Aggregation.mp4

121.59 MB

10. Grouping and Aggregating Records/6. Exercise Using Aggregation with Grouping.mp4

79.87 MB

10. Grouping and Aggregating Records/7. Filtering Groups.mp4

79.6 MB

10. Grouping and Aggregating Records/7. having_clause.sql

163 B

10. Grouping and Aggregating Records/8. Using WHERE and HAVING Together.mp4

124.49 MB

10. Grouping and Aggregating Records/8. where_having.sql

268 B

10. Grouping and Aggregating Records/9. 2024-11-10_17-59-04-8600b09d5bdaa0bd281190ac1a380b0a.png

347.46 KB

10. Grouping and Aggregating Records/9. Lecture Notes.html

3.31 KB

11. Sorting Records/1. Section Introduction.mp4

7.33 MB

11. Sorting Records/2. Sorting Records.mp4

52.54 MB

11. Sorting Records/2. sorting_records.sql

283 B

11. Sorting Records/3. limit_offset.sql

713 B

11. Sorting Records/3. Limiting and Skipping Records.mp4

73.36 MB

11. Sorting Records/4. Lecture Notes.html

1.47 KB

11. Sorting Records/5.11 Sorting, Limiting and Skipping Records.html

21.04 KB

11. Sorting Records/6.5 Interview Question (CVS Health) Part 1.html

6.13 KB

11. Sorting Records/7.6 Interview Question (CVS Health) Part 2.html

6.44 KB

12. Subqueries/1. Section Introduction.mp4

8.11 MB

12. Subqueries/10.12 Subqueries.html

18.58 KB

12. Subqueries/11.7 Interview Question (Facebook).html

5.98 KB

12. Subqueries/12.8 Interview Question (FAANG).html

6.75 KB

12. Subqueries/2. subquery_ex1.sql

178 B

12. Subqueries/2. What is a Subquery.mp4

33.33 MB

12. Subqueries/3. Where is a Subquery Used.mp4

34.73 MB

12. Subqueries/4. select_subquery.sql

428 B

12. Subqueries/4. Subquery in SELECT Clause.mp4

106.75 MB

12. Subqueries/5. from_subquery.sql

633 B

12. Subqueries/5. Subquery in FROM Clause.mp4

101.78 MB

12. Subqueries/6. join_subqueries.sql

350 B

12. Subqueries/6. Subquery in JOIN Clause.mp4

143.78 MB

12. Subqueries/7. Subquery in WHERE Clause.mp4

118.58 MB

12. Subqueries/7. where_subquery.sql

1005 B

12. Subqueries/8. Correlated Subquery.mp4

150.13 MB

12. Subqueries/8. correlated_subquery.sql

447 B

12. Subqueries/9. Lecture Notes.html

2.89 KB

13. Case Study 1 Extracting Insights from E-commerce Dataset/1. order_exec.png

183.55 KB

13. Case Study 1 Extracting Insights from E-commerce Dataset/1. Quick Recap!.mp4

40.18 MB

13. Case Study 1 Extracting Insights from E-commerce Dataset/1. sql_topics.png

282.89 KB

13. Case Study 1 Extracting Insights from E-commerce Dataset/10. Exercise 4 Calculate the Customer Lifetime Value (CLV).mp4

44.56 MB

13. Case Study 1 Extracting Insights from E-commerce Dataset/11. 4_customer_lifetime_value.sql

663 B

13. Case Study 1 Extracting Insights from E-commerce Dataset/11. Solution - Exercise 4.mp4

78.49 MB

13. Case Study 1 Extracting Insights from E-commerce Dataset/12. Exercise 5 Identify customers who have not made a purchase in a while.mp4

40.94 MB

13. Case Study 1 Extracting Insights from E-commerce Dataset/13. 5_customers_not_purchased.sql

685 B

13. Case Study 1 Extracting Insights from E-commerce Dataset/13. Solution - Exercise 5.mp4

70.25 MB

13. Case Study 1 Extracting Insights from E-commerce Dataset/14. Exercise 6 Show the most recent review for each product.mp4

67.13 MB

13. Case Study 1 Extracting Insights from E-commerce Dataset/15. 6_reviews_in_real_time.sql

1.07 KB

13. Case Study 1 Extracting Insights from E-commerce Dataset/15. Solution - Exercise 6.mp4

117.34 MB

13. Case Study 1 Extracting Insights from E-commerce Dataset/16. Exercise 7 Identify the top rated products.mp4

33.41 MB

13. Case Study 1 Extracting Insights from E-commerce Dataset/17. 7_top_rated_products.sql

663 B

13. Case Study 1 Extracting Insights from E-commerce Dataset/17. Solution - Exercise 7.mp4

49.97 MB

13. Case Study 1 Extracting Insights from E-commerce Dataset/18. Exercise 8 Calculate discount based on order value.mp4

26.33 MB

13. Case Study 1 Extracting Insights from E-commerce Dataset/19. 8_discount_order_value.sql

926 B

13. Case Study 1 Extracting Insights from E-commerce Dataset/19. Solution - Exercise 8.mp4

37.82 MB

13. Case Study 1 Extracting Insights from E-commerce Dataset/2. Section Introduction.mp4

28.9 MB

13. Case Study 1 Extracting Insights from E-commerce Dataset/3. analytical_dataset.sql

4.59 KB

13. Case Study 1 Extracting Insights from E-commerce Dataset/3. Analytics Data Setup.mp4

47.42 MB

13. Case Study 1 Extracting Insights from E-commerce Dataset/4. Exercise 1 Calculate the total revenue.mp4

26.15 MB

13. Case Study 1 Extracting Insights from E-commerce Dataset/5. 1_total_revenue.sql

389 B

13. Case Study 1 Extracting Insights from E-commerce Dataset/5. Solution - Exercise 1.mp4

27.97 MB

13. Case Study 1 Extracting Insights from E-commerce Dataset/6. Exercise 2 Identify the top selling products.mp4

51.06 MB

13. Case Study 1 Extracting Insights from E-commerce Dataset/7. 2_top_selling_products.sql

454 B

13. Case Study 1 Extracting Insights from E-commerce Dataset/7. Solution - Exercise 2.mp4

78.85 MB

13. Case Study 1 Extracting Insights from E-commerce Dataset/8. Exercise 3 Calculate the Average Order Value (AOV).mp4

87.96 MB

13. Case Study 1 Extracting Insights from E-commerce Dataset/9. 3_average_order_value.sql

1.72 KB

13. Case Study 1 Extracting Insights from E-commerce Dataset/9. Solution - Exercise 3.mp4

36.26 MB

14. Type Casting/1. Section Introduction.mp4

18.98 MB

14. Type Casting/2. Explicit Type Casting.mp4

48.1 MB

14. Type Casting/2. explicit_type_casting.sql

310 B

14. Type Casting/3. Implicit Type Casting.mp4

29.63 MB

14. Type Casting/3. implicit_type_casting.sql

262 B

14. Type Casting/4. Lecture Notes.html

1.14 KB

15. Working with Date and Time Data Types/1. Section Introduction.mp4

11.96 MB

15. Working with Date and Time Data Types/10.9 Interview Question (Microsoft).html

6.88 KB

15. Working with Date and Time Data Types/2. Current Date and Time.mp4

34.22 MB

15. Working with Date and Time Data Types/2. current_date_time.sql

592 B

15. Working with Date and Time Data Types/3. Time Zone Conversions.mp4

80.58 MB

15. Working with Date and Time Data Types/3. time_zone-conversions.sql

239 B

15. Working with Date and Time Data Types/4. date_trunc.sql

1.02 KB

15. Working with Date and Time Data Types/4. Truncating Date and Timestamp.mp4

41.89 MB

15. Working with Date and Time Data Types/5. date_trunc_ex.sql

270 B

15. Working with Date and Time Data Types/5. Example Truncating Date and Timestamp.mp4

100.14 MB

15. Working with Date and Time Data Types/6. date_part.sql

1000 B

15. Working with Date and Time Data Types/6. extract.sql

1.17 KB

15. Working with Date and Time Data Types/6. Extracting Parts of Date and Timestamp.mp4

47.66 MB

15. Working with Date and Time Data Types/7. Formatting Date and Timestamp.mp4

35.77 MB

15. Working with Date and Time Data Types/7. to_char.sql

1.19 KB

15. Working with Date and Time Data Types/8. Date Math.mp4

42.93 MB

15. Working with Date and Time Data Types/8. date_math.sql

1.29 KB

15. Working with Date and Time Data Types/9. Lecture Notes.html

5.45 KB

16. Working with Array Data Type/1. Section Introduction.mp4

26.83 MB

16. Working with Array Data Type/10. array_flat.sql

103 B

16. Working with Array Data Type/10. Flattening of Arrays.mp4

25.25 MB

16. Working with Array Data Type/11. 2024-11-19_12-03-27-ef3be7da1bf82e66c276e569f9e49097.png

274.29 KB

16. Working with Array Data Type/11. Lecture Notes.html

3.44 KB

16. Working with Array Data Type/2. array_datatype.png

274.29 KB

16. Working with Array Data Type/2. What is an Array.mp4

32.56 MB

16. Working with Array Data Type/3. add_column.sql

104 B

16. Working with Array Data Type/3. Adding Columns of Array Data Type.mp4

32.34 MB

16. Working with Array Data Type/4. insert_data.sql

180 B

16. Working with Array Data Type/4. Inserting Data into Array Columns.mp4

34.74 MB

16. Working with Array Data Type/5. filter_records.sql

295 B

16. Working with Array Data Type/5. Filtering Records Based on Array Values.mp4

55.5 MB

16. Working with Array Data Type/6. Array Indexing.mp4

33.55 MB

16. Working with Array Data Type/6. array_index.sql

96 B

16. Working with Array Data Type/7. Array Functions.mp4

56.83 MB

16. Working with Array Data Type/7. array_functions.sql

363 B

16. Working with Array Data Type/8. Array Aggregation.mp4

117.39 MB

16. Working with Array Data Type/8. array_agg.sql

140 B

16. Working with Array Data Type/9. array_agg_exercise.sql

282 B

16. Working with Array Data Type/9. Exercise Array Aggregation.mp4

61.29 MB

17. Working with JSON Data Type/1. Section Introduction.mp4

27.81 MB

17. Working with JSON Data Type/2. What is JSON.mp4

91.08 MB

17. Working with JSON Data Type/3. add_column.sql

107 B

17. Working with JSON Data Type/3. Adding Columns of JSON Data Type.mp4

32.92 MB

17. Working with JSON Data Type/4. insert_data.sql

866 B

17. Working with JSON Data Type/4. Inserting Data into JSON Columns.mp4

45.24 MB

17. Working with JSON Data Type/5. access.sql

737 B

17. Working with JSON Data Type/5. Accessing JSON Fields.mp4

141.82 MB

17. Working with JSON Data Type/6. filter.sql

1.88 KB

17. Working with JSON Data Type/6. Filtering Records Based on JSON Fields.mp4

156.83 MB

17. Working with JSON Data Type/7. Constructing JSON Objects.mp4

64.25 MB

17. Working with JSON Data Type/7. constructing_json.sql

547 B

17. Working with JSON Data Type/8. aggregation.sql

471 B

17. Working with JSON Data Type/8. JSON Aggregation.mp4

59.78 MB

17. Working with JSON Data Type/9. Lecture Notes.html

5.7 KB

18. Window Functions/1. Section Introduction.mp4

7.4 MB

18. Window Functions/1. window_functions.png

276.03 KB

18. Window Functions/10.11 Interview Question (Amazon).html

7.26 KB

18. Window Functions/2. Data Setup.mp4

9.99 MB

18. Window Functions/2. data_setup.sql

614 B

18. Window Functions/3. rank.sql

248 B

18. Window Functions/3. The RANK() Window Function.mp4

256.38 MB

18. Window Functions/4. dense_rank.sql

236 B

18. Window Functions/4. The DENSE_RANK() Window Function.mp4

81.8 MB

18. Window Functions/5. row_number.sql

169 B

18. Window Functions/5. The ROW_NUMBER() Window Function.mp4

71.42 MB

18. Window Functions/6. lag_lead.sql

665 B

18. Window Functions/6. The LAG() and LEAD() Window Function.mp4

134.52 MB

18. Window Functions/7. LAG() Function - A Practical Use Case.mp4

48.13 MB

18. Window Functions/7. lag_ex.png

206.74 KB

18. Window Functions/8. 2024-11-21_13-44-00-0eb1e38674b8bf9602a76bf0eac228b2.png

626.36 KB

18. Window Functions/8. 2024-11-21_13-44-00-f4657878fbc6ca7ce6d115a864555b14.png

276.03 KB

18. Window Functions/8. Lecture Notes.html

3.73 KB

18. Window Functions/9.10 Interview Question (Uber).html

5.67 KB

19. Common Table Expressions (CTEs)/1. Section Introduction.mp4

38.16 MB

19. Common Table Expressions (CTEs)/2. Common Table Expressions (CTEs) In Detail.mp4

170.37 MB

19. Common Table Expressions (CTEs)/2. cte_example.sql

884 B

19. Common Table Expressions (CTEs)/3. Lecture Notes.html

1.27 KB

19. Common Table Expressions (CTEs)/4.12 Interview Question (LinkedIn).html

7.67 KB

20. SQL for Cleaning Data for Analysis and Reporting/1. analysis_process.png

210.61 KB

20. SQL for Cleaning Data for Analysis and Reporting/1. Section Introduction.mp4

128.45 MB

20. SQL for Cleaning Data for Analysis and Reporting/2. Data Setup.mp4

19.76 MB

20. SQL for Cleaning Data for Analysis and Reporting/2. data_setup.sql

1.71 KB

20. SQL for Cleaning Data for Analysis and Reporting/3. Handling Missing Values.mp4

138.83 MB

20. SQL for Cleaning Data for Analysis and Reporting/3. missing_values.sql

462 B

20. SQL for Cleaning Data for Analysis and Reporting/4. Handling Duplicates.mp4

147.09 MB

20. SQL for Cleaning Data for Analysis and Reporting/4. removing_duplicates.sql

1.09 KB

20. SQL for Cleaning Data for Analysis and Reporting/5. Handling Outliers.mp4

67.63 MB

20. SQL for Cleaning Data for Analysis and Reporting/5. handling_outliers.sql

413 B

20. SQL for Cleaning Data for Analysis and Reporting/6. categorical_column.sql

527 B

20. SQL for Cleaning Data for Analysis and Reporting/6. Standardizing Values in Categorical Columns.mp4

46.55 MB

20. SQL for Cleaning Data for Analysis and Reporting/7. Standardizing Text Data.mp4

42.31 MB

20. SQL for Cleaning Data for Analysis and Reporting/7. text_data.sql

168 B

20. SQL for Cleaning Data for Analysis and Reporting/8. Consistent Format for Numeric Data.mp4

59.54 MB

20. SQL for Cleaning Data for Analysis and Reporting/8. number_format.sql

97 B

20. SQL for Cleaning Data for Analysis and Reporting/9. 2024-11-23_19-58-44-059632582b9adcf9ba495eeec822bced.png

210.61 KB

20. SQL for Cleaning Data for Analysis and Reporting/9. Lecture Notes.html

9.92 KB

21. Case Study 2 Time Series Analysis with Retail Sales Dataset/1. Section Introduction.mp4

31.47 MB

21. Case Study 2 Time Series Analysis with Retail Sales Dataset/10.13 Interview Question (Wayfair).html

7.78 KB

21. Case Study 2 Time Series Analysis with Retail Sales Dataset/2. data_setup.sql

502 B

21. Case Study 2 Time Series Analysis with Retail Sales Dataset/2. Importing Data From CSV to PostgreSQL Database.mp4

122.97 MB

21. Case Study 2 Time Series Analysis with Retail Sales Dataset/2. us_retail_sales.csv

1.28 MB

21. Case Study 2 Time Series Analysis with Retail Sales Dataset/3. eda.sql

1.36 KB

21. Case Study 2 Time Series Analysis with Retail Sales Dataset/3. Exploratory Data Analysis (EDA).mp4

145.61 MB

21. Case Study 2 Time Series Analysis with Retail Sales Dataset/4. Identifying Sales Trends.mp4

138.21 MB

21. Case Study 2 Time Series Analysis with Retail Sales Dataset/4. trends.sql

416 B

21. Case Study 2 Time Series Analysis with Retail Sales Dataset/5. Date Dimension Table and Fact Table.mp4

151.37 MB

21. Case Study 2 Time Series Analysis with Retail Sales Dataset/5. date_dim.sql

650 B

21. Case Study 2 Time Series Analysis with Retail Sales Dataset/6. A Generic and Reusable Date Dimension Table.mp4

165.01 MB

21. Case Study 2 Time Series Analysis with Retail Sales Dataset/6. date_dim_table.sql

1.45 KB

21. Case Study 2 Time Series Analysis with Retail Sales Dataset/7. Top Business Categories By Sales.mp4

133.14 MB

21. Case Study 2 Time Series Analysis with Retail Sales Dataset/7. top_businesses.sql

548 B

21. Case Study 2 Time Series Analysis with Retail Sales Dataset/8. Year-over-Year (YoY) Sales Analysis.mp4

131.39 MB

21. Case Study 2 Time Series Analysis with Retail Sales Dataset/8. yoy_sales_growth.sql

682 B

21. Case Study 2 Time Series Analysis with Retail Sales Dataset/9. key_concepts.sql

2.82 KB

21. Case Study 2 Time Series Analysis with Retail Sales Dataset/9. Quick Recap of the Key Concepts.mp4

55.38 MB

22. Some More Interview Questions From Top Companies/1.14 Interview Question (JP Morgan).html

6.23 KB

22. Some More Interview Questions From Top Companies/2.15 Interview Question (CVS Health).html

8.6 KB

22. Some More Interview Questions From Top Companies/3.16 Interview Question (UnitedHealth Group).html

6.42 KB

22. Some More Interview Questions From Top Companies/4.17 Interview Question (Facebook).html

7.14 KB

22. Some More Interview Questions From Top Companies/5.18 Interview Question (Amazon).html

6.03 KB

23. Next Steps Roadmap and Career Guidance/1. Data Analyst Data Scientist Roadmap.mp4

91.17 MB

资源详情

免责声明