آموزش پیاده سازی انبار داده با SQL Server 2012

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

مقدمه ای بر انبارهای داده Introduction to Data Warehouses

• معرفی Introduction

• داده_انبارها Data_Warehouses

• مفاهیم_ذخیره_داده Data_Warehousing_Concepts

• Exploring_an_OLTP_Database_and_its_Data_Warehouse_Demo_01 Exploring_an_OLTP_Database_and_its_Data_Warehouse_Demo_01

• مقدمه_ETL Introduction_to_ETL

• امتحان Quiz

• نتیجه Conclusion

جداول ابعاد Dimension Tables

• ابعاد_جدول Dimension_Tables

• Use_and_Types_of_Dimensions Use_and_Types_of_Dimensions

• Create_a_new_Dimension_Demo_01 Create_a_new_Dimension_Demo_01

• صفات_و_سلسله مراتب Attributes_and_Hierarchies

• Exploring_Attributes_and_Hierarchies_Demo_02 Exploring_Attributes_and_Hierarchies_Demo_02

• Understanding_Granularity_Demo_03 Understanding_Granularity_Demo_03

• داده های تاریخی Historical_Data

• Understanding_SCD_Type_2_Demo_04 Understanding_SCD_Type_2_Demo_04

• به آرامی_تغییر_ابعاد Slowly_Changing_Dimensions

• امتحان Quiz

• نتیجه Conclusion

جداول واقعیت Fact Tables

• Fact_Table Fact_Table

• حقایق_و_اندازه ها Facts_and_Measures

• Creating_and_Exploring_a_Fact_Table_Demo_01 Creating_and_Exploring_a_Fact_Table_Demo_01

• Fact_Table_Indexing Fact_Table_Indexing

• Fact_Table_Lineage_Demo_02 Fact_Table_Lineage_Demo_02

• استفاده از_an_Audit_Dimension_Demo_03 Using_an_Audit_Dimension_Demo_03

• امتحان Quiz

• نتیجه Conclusion

مفاهیم مربوط به پیاده سازی انبار داده با SQL Server 2012 Concepts Involved in Implementing a Data Warehouse with SQL Server 2012

• Concepts_Involved_in_Implementing_a_Data_Warehouse_with_SQL_Server_2012 Concepts_Involved_in_Implementing_a_Data_Warehouse_with_SQL_Server_2012

• Roles_of_SQL_Server_components Roles_of_SQL_Server_components

• SSIS_-_مقدمه SSIS_-_Introduction

• SSIS_Installation_and_Implementation_Requirements SSIS_Installation_and_Implementation_Requirements

• امتحان Quiz

• نتیجه Conclusion

• Installing_SSIS_Demo_01 Installing_SSIS_Demo_01

نمای کلی SSIS برای ETL SSIS Overview for ETL

• SSIS_Overview_for_ETL SSIS_Overview_for_ETL

• درک_ساختار_SSIS Understanding_the_Structure_of_SSIS

• Setting_up_a_SSIS_Catalog_Demo_01 Setting_up_a_SSIS_Catalog_Demo_01

• Creating_a_New_SSIS_Project_Demo_02 Creating_a_New_SSIS_Project_Demo_02

• Adding_a_Connection_Manager_Demo_03 Adding_a_Connection_Manager_Demo_03

• Advanced_SSIS_Projects Advanced_SSIS_Projects

• Viewing_and_Changing_Connection_String_Parameters_Demo_04 Viewing_and_Changing_Connection_String_Parameters_Demo_04

• امتحان Quiz

• نتیجه Conclusion

درک جریان کنترل SSIS Understanding SSIS Control Flow

• Understanding_SSIS_Control_Flow Understanding_SSIS_Control_Flow

• درک_کنترل_جریان_SSIS Understanding_the_Control_Flow_of_SSIS

• Working_with_Tasks_in_Control_Flow Working_with_Tasks_in_Control_Flow

• Adding_Tasks_to_a_Control_Flow_Demo_01 Adding_Tasks_to_a_Control_Flow_Demo_01

• Adding_a_Container_to_the_Control_Flow_Demo_02 Adding_a_Container_to_the_Control_Flow_Demo_02

• درک_کانتینرها_و_محدودیت ها Understanding_Containers_and_Constraints

• Adding_Constraints_to_a_Control_Flow_Demo_03 Adding_Constraints_to_a_Control_Flow_Demo_03

• استفاده از_Event_Handlers_and_Other_Properties Using_Event_Handlers_and_Other_Properties

• استفاده از_Event_Handlers_Demo_04 Using_Event_Handlers_Demo_04

• امتحان Quiz

• نتیجه Conclusion

کار با متغیرها Working with Variables

• Working_with_Variables Working_with_Variables

• درک_متغیرهای_در_SSIS Understanding_variables_in_SSIS

• Creating_new_variables_Demo_01 Creating_new_variables_Demo_01

• System_Variables_and_Expressions System_Variables_and_Expressions

• Adding_Expressions_with_User_Variables_Demo_02 Adding_Expressions_with_User_Variables_Demo_02

• Creating_Expressions_with_System_Variables_Demo_03 Creating_Expressions_with_System_Variables_Demo_03

• Parameters_in_Packages_and_Projects Parameters_in_Packages_and_Projects

• Parameterizing_expressions_Demo_04 Parameterizing_expressions_Demo_04

• Creating_a_custom_package_template_Demo_05 Creating_a_custom_package_template_Demo_05

• Using_Configurations_Demo_06 Using_Configurations_Demo_06

• امتحان Quiz

• نتیجه Conclusion

مقدمه ای بر ETL Introduction to ETL

• Introduction to_ETL_using_the_Data_Flow_Task Introduction_to_ETL_using_the_Data_Flow_Task

• ETL_and_the_Data_Flow_Task. ETL_and_the_Data_Flow_Task.

• Data_Source_Components Data_Source_Components

• Creating_a_new_ETL_Process_using_Data_Flow_Demo_01 Creating_a_new_ETL_Process_using_Data_Flow_Demo_01

• Transforms_Types Transforms_Types

• با استفاده از_Lookup_Transform_Demo_02 Using_Lookup_Transform_Demo_02

• Fuzzy_Lookup_Transform Fuzzy_Lookup_Transform

• استفاده از_Fuzzy_Lookup_Demo_03 Using_Fuzzy_Lookup_Demo_03

• Text_Mining_Transforms Text_Mining_Transforms

• استفاده از_Text_Mining_Demo_04 Using_Text_Mining_Demo_04

• SCD_Transform SCD_Transform

• Configure_SCD_Transform_Demo_05 Configure_SCD_Transform_Demo_05

• Scripting_in_SSIS_Packages Scripting_in_SSIS_Packages

• استفاده از_Data_Profiling_Demo_06 Using_Data_Profiling_Demo_06

• خدمات_کیفیت_داده Data_Quality_Services

• Setting_up_and_using_DQS_Demo_07 Setting_up_and_using_DQS_Demo_07

• امتحان Quiz

• نتیجه گیری Conclision

استقرار و مدیریت بسته ها Deploying and Managing Packages

• Deploying_and_Managing_Packages Deploying_and_Managing_Packages

• Executing_SSIS_Packages Executing_SSIS_Packages

• Deploy_and_Execute_Packages_Demo_01 Deploy_and_Execute_Packages_Demo_01

• Create_and_Use_a_Deployment_Utility_Demo_02 Create_and_Use_a_Deployment_Utility_Demo_02

• Logging_and_Storing_Packages Logging_and_Storing_Packages

• Turn_On_Logging_Demo_03 Turn_On_Logging_Demo_03

• امتحان Quiz

• نتیجه Conclusion

اشکال زدایی و ایمن سازی بسته ها Debugging and Securing Packages

• Debugging_and_Securing_Packages Debugging_and_Securing_Packages

• Handling_Errors_and_Notifying_Operators Handling_Errors_and_Notifying_Operators

• Debugging_SSIS Debugging_SSIS

• Debugging_Control_Flow_Demo_01 Debugging_Control_Flow_Demo_01

• Debugging_Data_Flow_Demo_02 Debugging_Data_Flow_Demo_02

• بسته_امنیت Package_Security

• Securing_sensitive_data_in_a_package_Demo_03 Securing_sensitive_data_in_a_package_Demo_03

• امتحان Quiz

• امتحان Quiz

• نتیجه Conclusion