SQL for Data Analytics and Business Analytics

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

Mastering SQL Server: A Comprehensive Guide to Database Management and Optimization

1 - Introduction

1 - Course Introduction

2 - Introduction of SQL Server

3 - SQL Server Interface

4 - Server and Database

5 - SQL Table Record Field

5 - SQL-Data.xlsx

2 - SQL Table

6 - Create Table

7 - Create Table without Create Statement

8 - Delete Table

9 - Alter Table

3 - Data Insert Import and Export

10 - Insert Data with Graphical User Interface

11 - Insert Data into Table

12 - Bulk Insert Data into Table

13 - Import Data into Table

14 - Export Data from Table

4 - Delete and Truncate

15 - Delete Data on Condition

16 - Delete Entire Data from Table

5 - Update Data

17 - Update Entire Field Data in Table

18 - Update Data on Condition

6 - Select Statement to View Data Where Clause

19 - View Data

20 - View Distinct Data

21 - View Filtered Data

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

22 - View Filtered Data with AND Operator

23 - View Filtered Data with OR Operator

24 - View Filtered Data with IN Operator

25 - View Filtered Data with BETWEEN Operator

26 - View Filtered Data with LIKE Operator

27 - View Top and Bottom Records with TOP Clause

8 - SQL Order By

28 - Sort Data in Ascending or Descending Orders

29 - Sort Data In Ascending Orders

30 - Sort Data in Descending Orders

9 - Group By and Having

31 - Extract Distinct Data

32 - Aggregate Data with Group By

33 - Apply Condition with Having Clause

10 - SQL Sub Query

34 - Extract Data of Max Value

35 - Extract Data of Min Value

36 - Extract Data more than Average Value

11 - SQL Joins

37 - Introduction of Join

38 - Inner Join

39 - Left Join

40 - Right Join

41 - Full Join

42 - Cross Join

43 - Self Join

12 - SQL Union

44 - Union

45 - Union ALL

46 - Intersect

47 - Except

13 - SQL Case Statement

48 - Create a Conditional Field

14 - Common Table Expression CTE

49 - Extract Product Name of 3rd Largest Sales

139,000 تومان

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

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

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

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