Practical SQL For Data Analysis

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

Learn how to create and analyze data in SQL practically

1 - Introduction to SQL

1 - Introduction

2 - Data Modeling.html

2 - Data Modeling Reading.txt

3 - Data Normalization.html

3 - Data Normalization.txt

4 - Download and Install SQL Server

4 - Link to download SQL Server Developer.txt

4 - Link to download SQL Server Management Studio.txt

5 - Create a database and import tables

5 - adventurework.xls

6 - What is a database

7 - Database object Table

8 - Database object Index

9 - Database object View

10 - Database object Triggers

11 - Create primary key on the branch table

12 - Create primary keys on other tables

13 - Import returns table and set primary

2 - Data Manipulation Language

14 - Module introduction

15 - DML SELECT Command

16 - DML INSERT Command

17 - DML UPDATE Command

18 - DML DELETE Command

3 - Data Definition Language

19 - Module introduction

20 - DDL CREATE Command

21 - DDL ALTER Command

22 - DDL DROP Command

23 - DCL Commands

4 - Basic SQL Statement

24 - Module introduction

25 - How to work with the SELECT Statement

26 - SELECT Statement with WHERE Clause

27 - SELECT with WHERE and AND Clauses

28 - SELECT With WHERE and IN Clauses

29 - How to work with SELECT and DISTINCT

30 - Subquery in the WHERE Clause

5 - Aggregate Functions

31 - Module introduction

32 - Aggregate function Count

33 - Aggregate function SUM

34 - Aggregate function Average

35 - Aggregate function MIN

36 - Aggregate function MAX

37 - Math operators and calculations

6 - Joins in SQL

38 - Module introduction

39 - Implementing inner join

40 - Implementing left join

41 - Implementing right join

42 - Implementing full join

43 - Join multiple tables in SQL

7 - Data Cleaning Analysis and Reporting in SQL

44 - Module introduction

45 - Data transformation Sales OrderDate

46 - Data transformation Products table

47 - Data transformation Customers table

48 - Sales KPI RevenueExpensesProfitProfit Margin

49 - Sales KPI correction

50 - Monthly Revenue Trend Analysis

51 - Monthly Revenue Trend Analysis explanation

52 - Revenue by branch analysis

53 - Revenue by Product Category

54 - Revenue by top 5 products analysis

55 - Revenue by customer gender

56 - SQL Analysis Report

139,000 تومان

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

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

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

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