Loading...

نبذة عن Data Warehouse (DWH)

مستودع البيانات (Data Warehouse) هو أحد علوم مجال Big Data ويهتم بآلية تخزين البيانات ذات الحجم الكبير حيث ان الامر يقدر بالتيرا بايت وفيه يتم تجميع البيانات من جميع وحدات تخزين المشروع المختلفة لكي يتم معالجتها لاحقا واستخراج المعلومات والتقارير منها

تفاصيل الكورس

يمكنك مذاكرة الدروس بعد التسجيل فى الكورس

دروس كورس Data Warehouse (DWH)

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

محاضر كورس Data Warehouse (DWH)

Ahmed Samir El Khadrawy

تقييمات الطلاب

4.1 / 5

( 2 )

  • 0%
  • 50%
  • 50%
  • 0%
  • 0%

بعض التقييمات
creator

Ali N.