Implementing a Data Warehouse with SQL Server 2012
What you’ll learn
Illuminate how to work with variables
Confer the concepts involved in Implementing a Data Warehouse with SQL Server 2012
Elucidate the importance of Fact Table
Categorize the different elements of Control Flow
Classify the different types of Transforms available in SSIS
Confer how to deploy and manage packages
Exhibit how to debug and secure packages
Find out the uses of Dimensions
Define data warehouses
Requirements
Knowledge of TSQL, javascript and C++ will be an added advantage for any particpant who is taking up this course. awareness about RDMS would be an added advantage.
Description
Adding to its data management system Microsoft has come up with a new Server, Microsoft SQL Server 2012 which familiarizes us with the construction and usage of databases in SQL Server platform. This course is the successor of Microsoft SQL Server 2012, a step higher into the administration of the data sytem. It is an excellent platform for students to build and implement a data warehouse. The course intends to target all data professionals including data analysts and other aspiring professionals who wants to get ready for exam 70-463, also known as Implementing a Data Warehouse with SQL Server 2012. Towards the end of this course our participants will have a thorough knowledge on data warehouses and the uses of dimensions. Apart from that our learner will also understand the importance of Fact Table along with the various concepts that are involved in the implementation of Data Warehouse with SQL Server 2012. This course also looks into the different elements of Control Flow and allows the learner to comprehend how to work with variables. In this course you will learn about the different types of Transforms available in SSIS, apart from how to deploy and manage packages. Finally you will understand how to debug and secure packages.This course is that is the basis for all other SQL Server-related disciplines—Database Development, Database Administration, and Business Intelligence. The main idea of this course is to make our students cognize SQL Server 2012 databases administration. You will be comprehending a lot about the various issues and other decisions that are part of SQL Server installation and configuration. SQL Server 2012 is a prevailing platform that is widely used in the enterprise and cloud. There are many critical systems based on it. This Exam 70-463 is also a part of the series of certifications to master this platform.Apart from this as a student you will keen to look into the various operations involved including building and managing data warehouse and architecturing and implementing dimensions.You will also find it both challenging and interesting to work with various variables. There will also be a discussion on some of the important topics namely, instance, database and object security strategies. You will be also interested in implementing and automating ETL Solution. Some of the high availability technologies will also be discussed as part of the training by looking into deploying and managing packages along with debugging and securing themOur training is broken down to 90 lecture sessions that will cover all objectives. As add ons, we are also providing demos on other major concepts so that participants understand how the steps learned are implemented in real time.
Overview
Section 1: Introduction to Data Warehouses
Lecture 1 Introduction
Lecture 2 Data_Warehouses
Lecture 3 Data_Warehousing_Concepts
Lecture 4 Exploring_an_OLTP_Database_and_its_Data_Warehouse_Demo_01
Lecture 5 Introduction_to_ETL
Lecture 6 Conclusion
Section 2: Dimension Tables
Lecture 7 Dimension_Tables
Lecture 8 Use_and_Types_of_Dimensions
Lecture 9 Create_a_new_Dimension_Demo_01
Lecture 10 Attributes_and_Hierarchies
Lecture 11 Exploring_Attributes_and_Hierarchies_Demo_02
Lecture 12 Understanding_Granularity_Demo_03
Lecture 13 Historical_Data
Lecture 14 Understanding_SCD_Type_2_Demo_04
Lecture 15 Slowly_Changing_Dimensions
Lecture 16 Conclusion
Section 3: Fact Tables
Lecture 17 Fact_Table
Lecture 18 Facts_and_Measures
Lecture 19 Creating_and_Exploring_a_Fact_Table_Demo_01
Lecture 20 Fact_Table_Indexing
Lecture 21 Fact_Table_Lineage_Demo_02
Lecture 22 Using_an_Audit_Dimension_Demo_03
Lecture 23 Conclusion
Section 4: Concepts Involved in Implementing a Data Warehouse with SQL Server 2012
Lecture 24 Concepts_Involved_in_Implementing_a_Data_Warehouse_with_SQL_Server_2012
Lecture 25 Roles_of_SQL_Server_components
Lecture 26 SSIS_-_Introduction
Lecture 27 SSIS_Installation_and_Implementation_Requirements
Lecture 28 Conclusion
Lecture 29 Installing_SSIS_Demo_01
Section 5: SSIS Overview for ETL
Lecture 30 SSIS_Overview_for_ETL
Lecture 31 Understanding_the_Structure_of_SSIS
Lecture 32 Setting_up_a_SSIS_Catalog_Demo_01
Lecture 33 Creating_a_New_SSIS_Project_Demo_02
Lecture 34 Adding_a_Connection_Manager_Demo_03
Lecture 35 Advanced_SSIS_Projects
Lecture 36 Viewing_and_Changing_Connection_String_Parameters_Demo_04
Lecture 37 Conclusion
Section 6: Understanding SSIS Control Flow
Lecture 38 Understanding_SSIS_Control_Flow
Lecture 39 Understanding_the_Control_Flow_of_SSIS
Lecture 40 Working_with_Tasks_in_Control_Flow
Lecture 41 Adding_Tasks_to_a_Control_Flow_Demo_01
Lecture 42 Adding_a_Container_to_the_Control_Flow_Demo_02
Lecture 43 Understanding_Containers_and_Constraints
Lecture 44 Adding_Constraints_to_a_Control_Flow_Demo_03
Lecture 45 Using_Event_Handlers_and_Other_Properties
Lecture 46 Using_Event_Handlers_Demo_04
Lecture 47 Conclusion
Section 7: Working with Variables
Lecture 48 Working_with_Variables
Lecture 49 Understanding_variables_in_SSIS
Lecture 50 Creating_new_variables_Demo_01
Lecture 51 System_Variables_and_Expressions
Lecture 52 Adding_Expressions_with_User_Variables_Demo_02
Lecture 53 Creating_Expressions_with_System_Variables_Demo_03
Lecture 54 Parameters_in_Packages_and_Projects
Lecture 55 Parameterizing_expressions_Demo_04
Lecture 56 Creating_a_custom_package_template_Demo_05
Lecture 57 Using_Configurations_Demo_06
Lecture 58 Conclusion
Section 8: Introduction to ETL
Lecture 59 Introduction_to_ETL_using_the_Data_Flow_Task
Lecture 60 ETL_and_the_Data_Flow_Task.
Lecture 61 Data_Source_Components
Lecture 62 Creating_a_new_ETL_Process_using_Data_Flow_Demo_01
Lecture 63 Transforms_Types
Lecture 64 Using_Lookup_Transform_Demo_02
Lecture 65 Fuzzy_Lookup_Transform
Lecture 66 Using_Fuzzy_Lookup_Demo_03
Lecture 67 Text_Mining_Transforms
Lecture 68 Using_Text_Mining_Demo_04
Lecture 69 SCD_Transform
Lecture 70 Configure_SCD_Transform_Demo_05
Lecture 71 Scripting_in_SSIS_Packages
Lecture 72 Using_Data_Profiling_Demo_06
Lecture 73 Data_Quality_Services
Lecture 74 Setting_up_and_using_DQS_Demo_07
Lecture 75 Conclision
Section 9: Deploying and Managing Packages
Lecture 76 Deploying_and_Managing_Packages
Lecture 77 Executing_SSIS_Packages
Lecture 78 Deploy_and_Execute_Packages_Demo_01
Lecture 79 Create_and_Use_a_Deployment_Utility_Demo_02
Lecture 80 Logging_and_Storing_Packages
Lecture 81 Turn_On_Logging_Demo_03
Lecture 82 Conclusion
Section 10: Debugging and Securing Packages
Lecture 83 Debugging_and_Securing_Packages
Lecture 84 Handling_Errors_and_Notifying_Operators
Lecture 85 Debugging_SSIS
Lecture 86 Debugging_Control_Flow_Demo_01
Lecture 87 Debugging_Data_Flow_Demo_02
Lecture 88 Package_Security
Lecture 89 Securing_sensitive_data_in_a_package_Demo_03
Lecture 90 Conclusion
This exam looks at database professionals who are involved in installation, configuration, and maintenance tasks. ,SQL Server database administrators, business intelligence professionals and system engineers, database developers with two or more years of experience can take up this exam.
Course Information:
Udemy | English | 5h 6m | 1.53 GB
Created by: Compaq learning
You Can See More Courses in the Developer >> Greetings from CourseDown.com