Learn Business Data Analysis with SQL and Tableau

This course teaches you SQL from scratch till writing complex queries. The course starts with you from basic to advanced level. You will learn using the most important functions, such as: aggregation and date functions at your queries.

• Introduction 18:21

  • 1: Introduction to the Course Preview 02:15
  • 2: Course Contents Preview 00:47
  • 3: What is a Relational Database Preview 01:23
  • 4: How tables are linked a Relational Database Preview 06:41
  • 5: Why Relational Database Preview 01:00
  • 6: Types of Relationships between Tables Preview 05:15
  • 7: What are types of relationship between tables 01:00

• Install and Use Microsoft SQL Server 2:36:37

  • 8: Install MS SQL Server and Management Studio 05:41
  • 9: Install MS Server and Management Studio Instructions 01:00
  • 10: Introduction to SQL Server Management Studio (SSMS) 02:14
  • 11: Download and Create Northwind Database 01:47
  • 12: Create and populate Northwind Database SQL Code 2:16:00
  • 13: Introduction to Northwind Database 05:55
  • 14: Northwind Database Entity Relationship Diagram (ERD) 03:00
  • 15: Course Rating 01:00

• Introduction to SQL Queries 1:10:20

  • 16: Introduction to SQL Queries 05:07
  • 17: Select Statement 01:00
  • 18: Sorting obtained data using ORDER BY 03:48
  • 19: Using AND and OR operators with WHERE condition 02:06
  • 20: SELECT query with conditions 02:00
  • 21: IN and NOT IN operators 01:22
  • 22: Wildcards 04:31
  • 23: Wildcards 02:00
  • 24: Tables Joins in SQL 01:26
  • 25: Inner Join 06:14
  • 26: Left Join 03:30
  • 27: Right Join 01:43
  • 28: Full Outer Join 00:56
  • 29: Self Join 03:02
  • 30: Table Joins 01:00
  • 31: SQL Sub Queries 04:38
  • 32: Sub Queries 01:00
  • 33: Aggregation Functions 04:02
  • 34: Using Group By 03:19
  • 35: Using HAVING Condition 02:41
  • 36: Aggregation Functions 01:00
  • 37: String Functions 03:15
  • 38: DATE Functions 06:25
  • 39: Conversion Functions 02:15
  • 40: Conversion Functions 01:00
  • 41: Course Rating 01:00

• Products and Inventory Data Analysis with SQL 31:41

  • 42: Task 1: Find the top ten purchased products by name 02:29
  • 43: Task 1 code solution 02:01
  • 44: Task 1 SQL code 01:00
  • 45: Task 2: Find the product that has the second highest unit price 01:53
  • 46: Task 2 code solution 04:01
  • 47: Task 2 SQL code 01:00
  • 48: Task 3: Use DENS_RANK() to rank products sold in each city in the USA 02:56
  • 49: Task 3 Code Solution 02:53
  • 50: Task 3 SQL code 01:00
  • 51: Task 4: Find the products that were shipped late to customers 01:15
  • 52: Task 4 Code Solution 04:19
  • 53: Task 4 SQL code 01:00
  • 54: Case Statement 01:07
  • 55: Task 5: Use Case Statement to classify products based on stock level 02:03
  • 56: Task 5 code solution 01:44
  • 57: Task 5 SQL code 01:00

• Sales and Customers Data Analysis with SQL 1:00:18

  • 58: Task 1: Find the top 10 valuable customers for the business in 2018 00:41
  • 59: Task 1 code solution 02:03
  • 60: Task 1 SQL code 01:00
  • 61: Task 2: Find products generated total sale greater than $30000 01:53
  • 62: Task 2 code solution 04:24
  • 63: Task 2 SQL code 01:00
  • 64: Task 3: Classify customers into 3 levels based on total sale 00:46
  • 65: Task 3 code solution 03:26
  • 66: Task 3 SQL code 01:00
  • 67: Task 4: Find customers that generated total sale amount greater than average 01:29
  • 68: Task 4 code solution 02:55
  • 69: Task 4 SQL code 01:00
  • 70: Task 5: Find the sale volume per customer for each year 00:25
  • 71: Task 5 code solution 04:17
  • 72: Task 5 SQL code part 1 01:00
  • 73: Task 5 SQL code part 2 01:00
  • 74: Task 6: Find customers that didn't place orders in the last 20 months 00:47
  • 75: Task code solution 01:39
  • 76: Task 6 SQL code 01:00
  • 77: Task 7: Find number of orders per customer 00:25
  • 78: Task 7 code solution 03:06
  • 79: Task 7 SQL code 01:00
  • 80: Task 8: Find the customer with the third highest sale volume 00:41
  • 81: Task 8 code solution part 1 03:36
  • 82: Task 8 code solution part 2 02:25
  • 83: Task 8 SQL code part 1 01:00
  • 84: Task 8 SQL code part 2 01:00
  • 85: Task 9: Find duration in days between every two orders for each customer 00:27
  • 86: Task 9 code solution 02:18
  • 87: Task 9 SQL code 01:00
  • 88: Task 10: Sales data analysis in time series part 1 05:25
  • 89: Task 10: Sales data analysis in time series part 2 03:10
  • 90: Task 10-a Create Customer Sale View SQL code 01:00
  • 91: Task 10-b Sales data analysis over time period SQL code 01:00
  • 92: Course Rating 01:00

• Employees and Staff Data Analysis with SQL 12:13

  • 93: Task 1: Find employees that achieved highest sales volumes and their bonus 00:46
  • 94: Task 1 code solution 02:28
  • 95: Task 1 SQL code 01:00
  • 96: Task 2: Find the number of employees in position or title for each city 00:12
  • 97: Task 2 code solution 01:37
  • 98: Task 2 SQL code 01:00
  • 99: Task 3: List the company's employees and work duration in years 00:15
  • 100: Task 3 code solution 01:14
  • 101: Task 3 SQL code 01:00
  • 102: Task 4: Find the employees older than 70 years old 00:16
  • 103: Task 4 code solution 01:25
  • 104: Task 4 SQL code 01:00

• Data Analysis with Tableau 1:02:49

  • 105: Introduction to Data Visualization 03:26
  • 106: Install Tableau Public 02:23
  • 107: Extract data from SQL Server 06:50
  • 108: Navigate in Tableau 04:50
  • 109: Task 1: Create a map shows sale volume in each country 09:51
  • 110: Task 2: Create a bar chart shows sale volume per country 05:33
  • 111: Task 3: Add date and filter to the bar chart 06:29
  • 112: Task 4: Create line charts show sale volume and date 05:20
  • 113: Save and download Tableau files 01:09
  • 114: Task 5: Products sold per category and year 02:24
  • 115: Task 6: Add a date filter 00:43
  • 116: Task 7: Customers classification part 1 02:34
  • 117: Task 7: Customers classification part 2 05:40
  • 118: Task 8: Create a dashboard in Tableau 03:51
  • 119: Task 9: Create a Story in Tableau 01:46

As most of the business data stored in relational databases, learning SQL is essential for anyone wants to be a data analyst or scientist. SQL is the main tool used to manipulate data in relational databases, so mastering SQL is necessary to perform deep data analyses. This course teaches you SQL from scratch till writing complex queries. The course starts with you from basic to advanced level. You will learn using the most important functions, such as: aggregation and date functions at your queries. Furthermore, you will learn joining multiple tables at your queries to retrieve the data you need for your analyses. Before that, you learn how to install and use Microsoft SQL Server and Northwind database. In the next section, you will learn about data visualization and using Tableau to create insightful diagrams and charts. You will learn installing Tableau and be comfortable with creating varied diagrams, dashboards and stories and use them for business data analyses.

This course for those who need to learn to create complex SQL queries and professional data diagrams and charts for data analysis

Have basic knowledge of using operating systems

Data Analyst, Business Analyst, Data Scientist

Currently there are no Q&As for this course. Be the first to ask a question.

Reed courses certificate of completion

Digital certificate - Included