Sql For Data Analysis udemy 2023

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

1 - Introduction

1 - Introduction

1 - Introduction.txt

2 - Connect to SQL Server

2 - Connect-SQL-Server

3 - Basic SQL Syntax

4 - Order of Query Execution

2 - Limiting the Rows

5 - OFFSET and Fetch

5 - Offset and fetch.txt

6 - Top With Percentage.txt

6 - Top with Percentage

3 - Filtering Data

7 - Distinct

8 - Where Clause with Equal and Not Equal

9 - Where Clause with Operator

10 - Where Clause with not like Operator

11 - Where Clause with like Operator

12 - Where Clause with and Or

13 - Where Clause with Null

14 - Where Clause with Exist and Not Exist

4 - Joining Table

15 - Join.txt

15 - Left Join

16 - Right Join

17 - Inner Join

18 - Cross Join

19 - Full Outer Join

20 - Advance or Intelligent Join

5 - Grouping Data

21 - Grouping Data.txt

21 - Group by

22 - Group By With Aggregate

23 - Cube

24 - Roll UP

25 - Group By with Where and Having Clause

26 - Group by with Grouping Set

6 - Sub Query

27 - Sub Query

27 - Sub Query.txt

28 - Nested Sub Query

29 - Subquery with Exist and Not Exist

30 - Sub Query with Any and All

31 - CORelated Sub Query

32 - Sub Query in Expression

33 - Sub Query in From Clause

7 - Set Operator

34 - Set Operator.txt

34 - Union and Union All

35 - Intersection

36 - Except

8 - Common Table Expression

37 - Common Table Expression

38 - Recursive Common Table Expression

39 - Multiple CTE in SQL Server

9 - Pivot Table

40 - Pivot.txt

40 - Pivot Table

10 - Expression

41 - Case Statement.html

11 - Function in SQL

42 - String Function

43 - Date and Time Function

44 - User Defined Function

45 - Inline Table Value Function

46 - Multi Statement Table Value Function

12 - Window or Analytics Function

47 - Rank Function

48 - First and Last

49 - Lead and Lag

50 - CUM Distributive Function

51 - NTILE Function

45,900 تومان

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

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

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

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