- Introduction
- Data Warehouses
- Data_Warehousing_Concepts
- Exploring_an_OLTP_Database_and_its_Data_Warehouse_Demo_01
- Introduction_to_ETL
- Quiz
- Conclusion
Online
₹ 449 3,099
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
Fees information
₹ 449 ₹3,099
certificate availability
Yes
certificate providing authority
Udemy
The syllabus
Introduction to Data Warehouses
Dimension Tables
- Dimension_Tables
- Use_and_Types_of_Dimensions
- Create_a_new_Dimension_Demo_01
- Attributes_and_Hierarchies
- Exploring_Attributes_and_Hierarchies_Demo_02
- Understanding_Granularity_Demo_03
- Historical_Data
- Understanding_SCD_Type_2_Demo_04
- Slowly_Changing_Dimensions
- Quiz
- Conclusion
Fact Tables
- Fact_Table
- Facts_and_Measures
- Creating_and_Exploring_a_Fact_Table_Demo_01
- Fact_Table_Indexing
- Fact_Table_Lineage_Demo_02
- Using_an_Audit_Dimension_Demo_03
- Quiz
- Conclusion
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
- SSIS_-_Introduction
- SSIS_Installation_and_Implementation_Requirements
- Quiz
- Conclusion
- Installing_SSIS_Demo_01
SSIS Overview for ETL
- SSIS_Overview_for_ETL
- Understanding_the_Structure_of_SSIS
- Setting_up_a_SSIS_Catalog_Demo_01
- Creating_a_New_SSIS_Project_Demo_02
- Adding_a_Connection_Manager_Demo_03
- Advanced_SSIS_Projects
- Viewing_and_Changing_Connection_String_Parameters_Demo_04
- Quiz
- Conclusion
Understanding SSIS Control Flow
- Understanding_SSIS_Control_Flow
- Understanding_the_Control_Flow_of_SSIS
- Working_with_Tasks_in_Control_Flow
- Adding_Tasks_to_a_Control_Flow_Demo_01
- Adding_a_Container_to_the_Control_Flow_Demo_02
- Understanding_Containers_and_Constraints
- Adding_Constraints_to_a_Control_Flow_Demo_03
- Using_Event_Handlers_and_Other_Properties
- Using_Event_Handlers_Demo_04
- Quiz
- Conclusion
Working with Variables
- Working_with_Variables
- Understanding_variables_in_SSIS
- Creating_new_variables_Demo_01
- System_Variables_and_Expressions
- Adding_Expressions_with_User_Variables_Demo_02
- Creating_Expressions_with_System_Variables_Demo_03
- Parameters_in_Packages_and_Projects
- Parameterizing_expressions_Demo_04
- Creating_a_custom_package_template_Demo_05
- Using_Configurations_Demo_06
- Quiz
- Conclusion
Introduction to ETL
- Introduction_to_ETL_using_the_Data_Flow_Task
- ETL_and_the_Data_Flow_Task.
- Data_Source_Components
- Creating_a_new_ETL_Process_using_Data_Flow_Demo_01
- Transforms_Types
- Using_Lookup_Transform_Demo_02
- Fuzzy_Lookup_Transform
- Using_Fuzzy_Lookup_Demo_03
- Text_Mining_Transforms
- Using_Text_Mining_Demo_04
- SCD_Transform
- Configure_SCD_Transform_Demo_05
- Scripting_in_SSIS_Packages
- Using_Data_Profiling_Demo_06
- Data_Quality_Services
- Setting_up_and_using_DQS_Demo_07
- Quiz
- Conclision
Deploying and Managing Packages
- Deploying_and_Managing_Packages
- Executing_SSIS_Packages
- Deploy_and_Execute_Packages_Demo_01
- Create_and_Use_a_Deployment_Utility_Demo_02
- Logging_and_Storing_Packages
- Turn_On_Logging_Demo_03
- Quiz
- Conclusion
Debugging and Securing
- Debugging_and_Securing_Packages
- Handling_Errors_and_Notifying_Operators
- Debugging_SSIS
- Debugging_Control_Flow_Demo_01
- Debugging_Data_Flow_DePackage_Security
- Securing_sensitive_data_in_a_package_Demo_03
- Quiz
- Conclusion