Hands-On Data Analysis using SQL & Tableau with Real Project

سرفصل های دوره

Learn and practice SQL and Tableau and how to use these to analyze and visualize data by working on real projects

1 - Introduction and Thank you

1 - Introduction

2 - Download SQL Server Management studio and Adventureworks database

2 - Download SQL Server Management studio and Adventureworks database

3 - What is SQL and a Relational Database

3 - SQL Relational Database and Entity Relationship Diagram

3 - erd.zip

4 - Beginner SQL

4 - Select From Where And Or

5 - Select From Where And Or Questions and Answers

6 - Upper and Lower

7 - IN and NOT IN operators

8 - Distinct Like and Order By

5 - Intermediate SQL

9 - Inner Join

10 - Left and Right Join

11 - Joins 2 Questions and Answers

12 - Union and Union All

6 - Aggregate Functions

13 - Sum Round and Group by

14 - Having and Practice Question

15 - Count

16 - Max and Min

17 - Average

18 - Questions on Aggregate Functions

7 - Sub Query and Common Table Expression CTE

19 - Sub Queries

20 - Common Table Expression CTE

8 - Case Statement and Flags

21 - Case When

22 - Flags

9 - Date Functions

23 - Data-Types.docx

23 - Year Month Day and Get Date

24 - DateDiff

25 - DateAdd

26 - Date table

27 - Cast and Convert

28 - Joining tables on more than one condition

29 - Date Functions Questions and Answers

10 - String Functions

30 - Concat

31 - Substring

11 - Google Sheets and Pivot Tables

32 - Google Sheets Pivot Tables

12 - Adventureworks Analysis Project

33 - Countries sales by Age Group

34 - Products sales by Age Group

35 - Sales in USA and Australia compared

36 - Products First Reorder Date

37 - Products with high stock levels

38 - Sales on Promotion

39 - Change in value between a customers first and last purchase

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training