Tutorialsplanet NET Udemy Learn Business Data Analysis with SQL and Tableau

Tutorialsplanet NET Udemy Learn Business Data Analysis with SQL and Tableau

Name	[Tutorialsplanet.NET] Udemy - Learn Business Data Analysis with SQL and Tableau	DOWNLOAD Copy Link
Total Size	1.8 GB
Total Files	221
Hash	09FBFCD31FF3CD410D68EB073B3E174DEBD5B46C

/1. Introduction/
1. Introduction to the Course.mp4	19.1 MB
1. Introduction to the Course.srt	2.5 KB
10. What is SQL.mp4	9.9 MB
10. What is SQL.srt	3.7 KB
11. SQL.html	0.2 KB
2. What you will learn from this course.mp4	3.6 MB
2. What you will learn from this course.srt	0.8 KB
3. What is Relational Database.mp4	5.5 MB
3. What is Relational Database.srt	1.6 KB
4. How tables are linked in a relational database.mp4	32.4 MB
4. How tables are linked in a relational database.srt	9.4 KB
5. Relational Database.html	0.2 KB
6. Types of Relationships between Tables.mp4	28.3 MB
6. Types of Relationships between Tables.srt	7.5 KB
7. Types of Relationships between Tables.html	0.2 KB
8. What is RDBMS.mp4	7.3 MB
8. What is RDBMS.srt	2.0 KB
9. Relational Databases Management System.html	0.2 KB
/2. Install and use Microsoft SQL Server/
1. Install MS SQL Server and Management Studio.mp4	28.5 MB
1. Install MS SQL Server and Management Studio.srt	3.3 KB
1.1 Install MS SQL Server and Management Studio.pdf	437.4 KB
2. Introduction to SQL Server Management Studio.mp4	19.4 MB
2. Introduction to SQL Server Management Studio.srt	3.7 KB
3. Download and Create Northwind Database.mp4	13.0 MB
3. Download and Create Northwind Database.srt	2.1 KB
3.1 instnwnd.sql	2.1 MB
4. Introduction to Northwind Database.mp4	26.8 MB
4. Introduction to Northwind Database.srt	7.5 KB
4.1 Northwind Database Diagram.pdf	440.5 KB
5. Course Rating.html	0.5 KB
/3. Learn SQL Queries/
1. Introduction to Select Query.mp4	44.8 MB
1. Introduction to Select Query.srt	8.0 KB
10. Inner Join.mp4	63.0 MB
10. Inner Join.srt	8.4 KB
11. Left Outer Join.mp4	31.1 MB
11. Left Outer Join.srt	4.1 KB
12. Right Outer Join.mp4	13.4 MB
12. Right Outer Join.srt	2.4 KB
12.1 Tables Joins SQL Code.pdf	225.6 KB
13. Full Outer Join.mp4	6.4 MB
13. Full Outer Join.srt	1.3 KB
14. Self Join.mp4	23.0 MB
14. Self Join.srt	3.7 KB
14.1 Table Joins SQL Code.pdf	231.1 KB
15. Table Joins.html	0.2 KB
16. Sub queries.mp4	32.4 MB
16. Sub queries.srt	6.4 KB
16.1 Sub Queries SQL Code.pdf	235.4 KB
17. Sub Queries.html	0.2 KB
18. Aggregation Functions.mp4	25.8 MB
18. Aggregation Functions.srt	5.7 KB
18.1 Aggregation Functions SQL Code.pdf	233.8 KB
19. Using Group By.mp4	27.2 MB
19. Using Group By.srt	4.7 KB
2. Select Query in SQL.html	0.2 KB
20. Using Having Condition.mp4	20.7 MB
20. Using Having Condition.srt	3.4 KB
21. Aggregation Functions.html	0.2 KB
22. String Functions.mp4	30.3 MB
22. String Functions.srt	5.3 KB
22.1 String Functions SQL Code.pdf	431.1 KB
23. String Functions.html	0.2 KB
24. Date Functions.mp4	64.7 MB
24. Date Functions.srt	10.9 KB
24.1 Date Functions SQL Code.pdf	318.9 KB
25. Date Functions.html	0.2 KB
26. Conversion Functions.mp4	12.6 MB
26. Conversion Functions.srt	3.1 KB
26.1 Conversion Functions SQL Code.pdf	224.3 KB
27. CAST and CONVERT Functions.html	0.2 KB
28. Course Rating.html	0.5 KB
3. Using AND and OR operators with Where condition.mp4	26.2 MB
3. Using AND and OR operators with Where condition.srt	2.9 KB
4. Sorting data using ORDER BY.mp4	43.6 MB
4. Sorting data using ORDER BY.srt	5.0 KB
5. Select query with conditions.html	0.2 KB
6. IN and NOT IN operators.mp4	15.5 MB
6. IN and NOT IN operators.srt	1.6 KB
6.1 IN Operator SQL code.pdf	37.8 KB
7. Wildcards.mp4	33.3 MB
7. Wildcards.srt	6.1 KB
7.1 Select Query SQL Code.pdf	227.0 KB
8. Wildcards.html	0.2 KB
9. Tables Joins in SQL.mp4	5.3 MB
9. Tables Joins in SQL.srt	1.7 KB
/4. Products and Inventory Data Analysis with SQL/
1. Task 1 Find top 10 purchased products by name.mp4	12.5 MB
1. Task 1 Find top 10 purchased products by name.srt	3.3 KB
10. Task 5 Use Case Statement to classify products based on stock level.mp4	10.4 MB
10. Task 5 Use Case Statement to classify products based on stock level.srt	3.1 KB
11. Task 5 Code Solution.mp4	16.1 MB
11. Task 5 Code Solution.srt	3.0 KB
11.1 Task 11 code solution.pdf	227.2 KB
2. Task 1 Code Solution.mp4	19.5 MB
2. Task 1 Code Solution.srt	3.1 KB
3. Task 2 Find the product that has the second highest unit price.mp4	1.2 MB
3. Task 2 Find the product that has the second highest unit price.srt	0.6 KB
4. Task 2 Code Solution.mp4	20.6 MB
4. Task 2 Code Solution.srt	5.2 KB
4.1 Task 10 code solution.pdf	283.3 KB
5. Task 3 Use DENS_RANK() to rank products sold in each city in the USA.mp4	18.8 MB
5. Task 3 Use DENS_RANK() to rank products sold in each city in the USA.srt	4.0 KB
6. Task 3 Code Solution.mp4	19.0 MB
6. Task 3 Code Solution.srt	4.1 KB
6.1 Task 3 code solution.sql	0.4 KB
7. Task 4 Find the products that were shipped late to customers.mp4	4.5 MB
7. Task 4 Find the products that were shipped late to customers.srt	1.6 KB
8. Task 4 Code Solution.mp4	37.6 MB
8. Task 4 Code Solution.srt	6.7 KB
8.1 SQL Code Solution 4.pdf	231.1 KB
9. Case Statement.mp4	4.3 MB
9. Case Statement.srt	1.5 KB
/5. Sales and Customers Data Analysis with SQL/
1. Task 1 Find the top 10 valuable customers for our business in 2018.mp4	7.1 MB
1. Task 1 Find the top 10 valuable customers for our business in 2018.srt	2.3 KB
10. Task 5 code solution.mp4	34.5 MB
10. Task 5 code solution.srt	5.2 KB
10.1 Task 14 code solution part 1.pdf	39.8 KB
10.2 Task 14 code solution part 2.pdf	39.8 KB
11. Task 6 Find customers that didn't place orders in the last 20 months.mp4	2.0 MB
11. Task 6 Find customers that didn't place orders in the last 20 months.srt	0.9 KB
12. Task 6 Code Solution.mp4	14.3 MB
12. Task 6 Code Solution.srt	2.1 KB
12.1 SQL Code Solution 9.pdf	51.7 KB
13. Task 7 Find number of orders per customer.mp4	1.4 MB
13. Task 7 Find number of orders per customer.srt	0.5 KB
14. Task 7 Code Solution.mp4	18.3 MB
14. Task 7 Code Solution.srt	3.8 KB
14.1 Task 12 code solution.pdf	203.8 KB
15. Task 8 Find the customer with the third highest sale volume.mp4	2.4 MB
15. Task 8 Find the customer with the third highest sale volume.srt	1.0 KB
16. Task 8 code solution part - 1.mp4	28.2 MB
16. Task 8 code solution part - 1.srt	4.4 KB
16.1 Task 13 code solution part 1.pdf	39.6 KB
17. Task 8 code solution part - 2.mp4	18.3 MB
17. Task 8 code solution part - 2.srt	3.2 KB
17.1 Task 13 code solution part 2.pdf	38.6 KB
18. Task 9 Find duration in days between every two orders for each customer.mp4	1.1 MB
18. Task 9 Find duration in days between every two orders for each customer.srt	0.6 KB
19. Task 9 code solution.mp4	17.2 MB
19. Task 9 code solution.srt	3.1 KB
19.1 Task 15 code solution.pdf	47.6 KB
2. Task 1 Code Solution.mp4	15.9 MB
2. Task 1 Code Solution.srt	2.5 KB
2.1 SQL Code Solution 5.pdf	230.6 KB
20. Task 10 Sales data analysis over time period part 1.mp4	53.5 MB
20. Task 10 Sales data analysis over time period part 1.srt	6.9 KB
20.1 Sales data analysis over time period SQL code.pdf	40.3 KB
20.2 Create Customer Sale View SQL code.pdf	40.8 KB
21. Task 10 Sales data analysis over time period part 2.mp4	34.0 MB
21. Task 10 Sales data analysis over time period part 2.srt	3.7 KB
22. Course Rating.html	0.5 KB
3. Task 2 Find products generated total sale greater than $30000 and units sold.mp4	6.3 MB
3. Task 2 Find products generated total sale greater than $30000 and units sold.srt	2.9 KB
4. Task 2 Code Solution.mp4	32.8 MB
4. Task 2 Code Solution.srt	6.1 KB
4.1 SQL Code Solution 2.pdf	259.6 KB
5. Task 3 Classify customers into 3 levels based on total sale.mp4	3.8 MB
5. Task 3 Classify customers into 3 levels based on total sale.srt	0.8 KB
6. Task 3 Code Solution.mp4	30.1 MB
6. Task 3 Code Solution.srt	5.0 KB
6.1 SQL Code Solution 6.pdf	232.3 KB
7. Task 4 Find customers that generated total sale amount greater than average.mp4	5.5 MB
7. Task 4 Find customers that generated total sale amount greater than average.srt	2.1 KB
8. Task 4 Code Solution.mp4	27.6 MB
8. Task 4 Code Solution.srt	4.4 KB
8.1 SQL Code Solution 7.pdf	230.1 KB
9. Task 5 Find the sale volume per customer for each year.mp4	2.0 MB
9. Task 5 Find the sale volume per customer for each year.srt	0.8 KB
/6. Employees and Staff Data Analysis with SQL/
1. Task 1 Find employees that achieved highest sales volumes and their bonus.mp4	3.3 MB
1. Task 1 Find employees that achieved highest sales volumes and their bonus.srt	1.0 KB
2. Task 1 code solution.mp4	21.0 MB
2. Task 1 code solution.srt	3.3 KB
2.1 SQL Code Solution 8.pdf	232.3 KB
3. Task 2 Find the number of employees in position or title for each city.mp4	516.6 KB
3. Task 2 Find the number of employees in position or title for each city.srt	0.3 KB
4. Task 2 Code Solution.mp4	14.5 MB
4. Task 2 Code Solution.srt	1.9 KB
4.1 Number of Employees in each Position SQL code.pdf	38.3 KB
5. Task 3 List the company's employees and work duration in years.mp4	760.0 KB
5. Task 3 List the company's employees and work duration in years.srt	0.3 KB
6. Task 3 Code Solution.mp4	11.0 MB
6. Task 3 Code Solution.srt	1.6 KB
6.1 Work Years in the Company SQL code.pdf	38.0 KB
7. Task 4 Find the employees older than 70 years old.mp4	773.1 KB
7. Task 4 Find the employees older than 70 years old.srt	0.3 KB
8. Task 4 Code Solution.mp4	12.0 MB
8. Task 4 Code Solution.srt	1.7 KB
8.1 Employees over 70 SQL code.pdf	38.8 KB
/7. Data Analysis with Tableau/
1. Introduction to Data Visualization.mp4	27.1 MB
1. Introduction to Data Visualization.srt	4.4 KB
10. Task 5 Products sold per category and year.mp4	19.2 MB
10. Task 5 Products sold per category and year.srt	3.8 KB
11. Task 6 Add a date filter.mp4	6.9 MB
11. Task 6 Add a date filter.srt	1.0 KB
12. Task 7 Customers classification part 1.mp4	20.3 MB
12. Task 7 Customers classification part 1.srt	3.3 KB
13. Task 7 Customers classification part 2.mp4	39.1 MB
13. Task 7 Customers classification part 2.srt	8.6 KB
14. Task 8 Create a dashboard in Tableau.mp4	37.3 MB
14. Task 8 Create a dashboard in Tableau.srt	6.4 KB
14.1 Tableau Data Analysis.xlsx	17.0 KB
15. Task 9 Create a Story in Tableau.mp4	14.5 MB
15. Task 9 Create a Story in Tableau.srt	2.9 KB
2. Install Tableau Public.mp4	19.4 MB
2. Install Tableau Public.srt	2.9 KB
3. Extract data from SQL Server.mp4	74.1 MB
3. Extract data from SQL Server.srt	9.6 KB
3.1 Tableau Data Analysis_1.xlsx	203.6 KB
3.2 Tableau Select Query.pdf	230.0 KB
4. Navigate Tableau.mp4	34.9 MB
4. Navigate Tableau.srt	7.3 KB
5. Task 1 Create a map shows sale volume in each country.mp4	77.8 MB
5. Task 1 Create a map shows sale volume in each country.srt	15.0 KB
6. Task 2 Create a bar chart shows sale volume per country.mp4	41.2 MB
6. Task 2 Create a bar chart shows sale volume per country.srt	7.6 KB
7. Task 3 Add date and filter to the bar chart.mp4	53.5 MB
7. Task 3 Add date and filter to the bar chart.srt	9.6 KB
8. Task 4 Create line charts show sale volume and date.mp4	37.3 MB
8. Task 4 Create line charts show sale volume and date.srt	7.4 KB
9. Save and download Tableau files.mp4	9.6 MB
9. Save and download Tableau files.srt	1.7 KB
/
[Tutorialsplanet.NET].url	0.1 KB
Total files 221