0 Course Layout

دروس الكورس

1. 1- 0 Course Layout
2. 2- 1 Data Warehouse Overview
3. 3- 2 DataWarehouse Terminology
4. 4- 3 DataWarehouse Introduction
5. 5- 6 Planing Data Warehouse Infrastructure
6. 6- 7 Planning for High Availability for Integration Service
7. 7- 8 Calculating Maximum Consumption Rate
8. 8- 10 Data Warehouse Design Overview
9. 9- 14 business intelligence Report Demo P1
10. 10- 14 business intelligence Report Demo P2
11. 11- 15 Designing Dimension Tables P2
12. 12- 16 Import and Export SSIS Packages
13. 13- 17 Explorer SSIS Packages usin Sql Server Data Tools
14. 14- 18 Demo for Datawarehouse Indexing and cloumn store index to inhance performance
15. 15- 18 Demo for Partitioning a Fact Table
16. 16- 19 Demo for Datawarehouse Comperssing Data to inhance performance
17. 17- 21 Introduction to ETL with SSIS
18. 18- 22 Explorer Data Source
19. 19- 23 Demo Implementing a Data Flow
20. 20- 24 Demo Implementing a Control Flow
21. 21- 19 Demo for Datawarehouse Indexing and cloumn store index to inhance performance P2
22. 22- 25 Debug in SSIS شرح
23. 23- 26 Debug and Error Handling in SSIS شرح
24. 24- 27 Log SSIS
25. 25- 28 Error Handle in SSIS
26. 26- 29 Extract Data Planing
27. 27- 30 Demonstration Using a Datetime Column
28. 28- 31 Change Data Capture In Details
29. 29- 32 Change Track In Data warehouse
30. 30- 33 Data Loading Palning Data warehouse
31. 31- 34 Load Data from CDC Output Tables to Data Warehouse
32. 32- 35 Using the Lookup Transformation P1
33. 33- 36 Using the Lookup Transformation P2
34. 34- 37 Using the MERGE Statement in data warehouse
35. 35- 40 Loading a Partitioned Table
36. 36- 41 Script Task
37. 37- 42 Deploying and Configuring SSIS Packages
38. 38- 43 Implementing a Slowly Changing Dimension
39. 39- 45 Data Quality Service Overview
40. 40- 46 Demonstration Creating a Knowledge Base
41. 41- 47 Demonstration Cleansing Data
42. 42- 48 Demonstration Matching Data Using Data Quality Service
43. 43- 49 Master Data Service Overview
44. 44- 50 Master Data Service Overview P2