SQL for Data Analyst, Business Analyst and BI Developer

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

Unlock the Power of SQL Server for Data Management, Data Analysis, Business Analyst and BI Developer with Live Practical

1 - Introduction

1 - Introduction of SQL Server

2 - SQL Server Installation

3 - SQL Server Interface

4 - Server and Database

5 - Table Record Field

2 - Database

6 - Create Database

7 - Delete Database

8 - Activate Database

9 - Full Database Backup

3 - Table

10 - Create Table

11 - Delete Table

12 - Alter Table

4 - Data Insert Import and Export

13 - Insert Data with Graphical User Interface

14 - Insert Data into Table

15 - Bulk Insert Data into Table

16 - Import Data into Table

17 - Export Data from Table

5 - Delete and Truncate

18 - Delete Data on Condition

19 - Delete Entire Data from Table

6 - Update Data

20 - Update Entire Field Data in Table

21 - Update Data on Condition

22 - Update Single Column Data from Another Table

23 - Update Multiple Columns Data from Another Table

7 - Select Statement to View Data Where Clause

24 - View Data

25 - View Distinct Data

26 - View Filtered Data

8 - Filter Data with Where Clause And Or IN Between LIKE Operators

27 - View Filtered Data with AND Operator

28 - View Filtered Data with OR Operator

29 - View Filtered Data with IN Operator

30 - View Filtered Data with BETWEEN Operator

31 - View Filtered Data with LIKE Operator

9 - Order By

32 - Sort Data in Ascending or Descending Orders

33 - Sort Data In Ascending Orders

34 - Sort Data in Descending Orders

35 - Sort Data on Two Fields

10 - Like Operator with Wild Card

36 - Filter Data with Pattern Match

37 - Filter Data with Single Character Match

11 - Group By and Having

38 - Extract Distinct Data

39 - Aggregate Data with Group By

40 - Apply Condition with Having Clause

12 - Sub Query

41 - Extract Data of Max Value

42 - Extract Data of Min Value

43 - Extract Data more than Average Value

44 - Extract 3rd Largest Value

45 - Extract 3rd Smallest Value

13 - Joins in SQL

46 - Join Introduction

47 - Inner Join

48 - Left Join

49 - Right Join

50 - Full Join

51 - Cross Join

52 - Self Join

14 - SQL Append

53 - Union

54 - Union ALL

55 - Intersect

56 - Except

15 - Case Statement

57 - Use Case Statement to Add Virtual Column

16 - CTECommon Table Expression

58 - RowNumber Function

59 - Rank Function

60 - DenseRank Function

61 - Extract Product Name of 3rd Largest Sales

62 - Remove Duplicate Data from Table

63 - Two Smallest Sales Based on Category

64 - Two Largest Sales Based on Category

189,000 تومان

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

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

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

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