MSBI and SSIS: Fundamentals to Advanced Data Integration

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

Unlock the full potential of your data with our comprehensive MSBI and SSIS course!

1. Learn MSBI and SSIS

1. Introduction to SSIS

2. How to Open SSIS and SSMS

3. Connection Manager

4. Data Flow Task

5. Basic Sql Task

6. Advance Execute Sql Task

7. Multicast

8. Conditional Spilt

9. Conditional Spilt Continue

10. Data Conversion

11. Derived Column

12. Lookup Transformation

13. Sort

14. Merge

15. Merge Join Indept

16. Merge Join Indept Continue

17. Row count and Scripts Component

2. SSIS - SQL Server Integration Services

1. Introduction to SSIS

2. More Details On SSIS

3. Use of Aggregate Data Transformation Support

4. How To Use Count And Countdistinct

5. Going to Learn Database to Database Transformantion

6. How to Input a Data from Database to Text

7. Going to Learn Groupby Function

8. Using Maxmin and Sum Function

9. Audit

10. How to use Copy Column

11. How to use Data Conversion

12. How to use Derived Column

13. How to use Lowerto Upper

14. How to use Upper to Lower

15. Excel to Database Transfer

16. Oledb to Excel Transfer

17. Conditional Split

18. Merge

19. Merge Join

20. Merge Using Sort

21. Multicast

22. Sort

23. Sort- Remove Duplicate

24. Union All

25. How to use Data Viewer Using Column

26. How to use Data Viewer Using Grid

27. How to use Data Viewer Using Histogram

28. How to use Dataviewer Using Scatter

29. How to use Fuzzy Grouping

30. How to use Fuzzy Lookup

31. How to use Lookup Transformation

32. How to use Percentage Sampling

33. How to use Pivot Data Transformation

34. How to use Rowsampling

35. How to use Term Extraction

36. How to use Term Lookup

37. How to use Unpivot

38. How to use Create Delete Tableusing Execute SQLTask

39. How to use Execute SQLTask

40. Praticals on Execute SQL Task

41. How to use File System Task

42. How to use Foreachloop

43. More Details on Foreachloop

44. How to use For Loop Container

139,000 تومان

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

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

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

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