Implementing a Data Warehouse with SQL Server 2012

Implementing a Data Warehouse with SQL Server 2012 , available at $64.99, has an average rating of 4.62, with 90 lectures, 10 quizzes, based on 2262 reviews, and has 9577 subscribers.

You will learn about 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 This course is ideal for individuals who are This exam looks at database professionals who are involved in installation, configuration, and maintenance tasks. or SQL Server database administrators, business intelligence professionals and system engineers, database developers with two or more years of experience can take up this exam. It is particularly useful for This exam looks at database professionals who are involved in installation, configuration, and maintenance tasks. or SQL Server database administrators, business intelligence professionals and system engineers, database developers with two or more years of experience can take up this exam. .

Enroll now: Implementing a Data Warehouse with SQL Server 2012

Summary

Title: Implementing a Data Warehouse with SQL Server 2012

Price: $64.99

Average Rating: 4.62

Number of Lectures: 90

Number of Quizzes: 10

Number of Published Lectures: 90

Number of Published Quizzes: 10

Number of Curriculum Items: 100

Number of Published Curriculum Objects: 100

Original Price: $74.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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.

Target Audiences

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.

Adding to its data management system Microsoft has come up with a new Server, Microsoft SQL Server 2012which 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 them

Our 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.

Course Curriculum

Chapter 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

Chapter 2: Dimension Tables

Lecture 1: Dimension_Tables

Lecture 2: Use_and_Types_of_Dimensions

Lecture 3: Create_a_new_Dimension_Demo_01

Lecture 4: Attributes_and_Hierarchies

Lecture 5: Exploring_Attributes_and_Hierarchies_Demo_02

Lecture 6: Understanding_Granularity_Demo_03

Lecture 7: Historical_Data

Lecture 8: Understanding_SCD_Type_2_Demo_04

Lecture 9: Slowly_Changing_Dimensions

Lecture 10: Conclusion

Chapter 3: Fact Tables

Lecture 1: Fact_Table

Lecture 2: Facts_and_Measures

Lecture 3: Creating_and_Exploring_a_Fact_Table_Demo_01

Lecture 4: Fact_Table_Indexing

Lecture 5: Fact_Table_Lineage_Demo_02

Lecture 6: Using_an_Audit_Dimension_Demo_03

Lecture 7: Conclusion

Chapter 4: Concepts Involved in Implementing a Data Warehouse with SQL Server 2012

Lecture 1: Concepts_Involved_in_Implementing_a_Data_Warehouse_with_SQL_Server_2012

Lecture 2: Roles_of_SQL_Server_components

Lecture 3: SSIS_-_Introduction

Lecture 4: SSIS_Installation_and_Implementation_Requirements

Lecture 5: Conclusion

Lecture 6: Installing_SSIS_Demo_01

Chapter 5: SSIS Overview for ETL

Lecture 1: SSIS_Overview_for_ETL

Lecture 2: Understanding_the_Structure_of_SSIS

Lecture 3: Setting_up_a_SSIS_Catalog_Demo_01

Lecture 4: Creating_a_New_SSIS_Project_Demo_02

Lecture 5: Adding_a_Connection_Manager_Demo_03

Lecture 6: Advanced_SSIS_Projects

Lecture 7: Viewing_and_Changing_Connection_String_Parameters_Demo_04

Lecture 8: Conclusion

Chapter 6: Understanding SSIS Control Flow

Lecture 1: Understanding_SSIS_Control_Flow

Lecture 2: Understanding_the_Control_Flow_of_SSIS

Lecture 3: Working_with_Tasks_in_Control_Flow

Lecture 4: Adding_Tasks_to_a_Control_Flow_Demo_01

Lecture 5: Adding_a_Container_to_the_Control_Flow_Demo_02

Lecture 6: Understanding_Containers_and_Constraints

Lecture 7: Adding_Constraints_to_a_Control_Flow_Demo_03

Lecture 8: Using_Event_Handlers_and_Other_Properties

Lecture 9: Using_Event_Handlers_Demo_04

Lecture 10: Conclusion

Chapter 7: Working with Variables

Lecture 1: Working_with_Variables

Lecture 2: Understanding_variables_in_SSIS

Lecture 3: Creating_new_variables_Demo_01

Lecture 4: System_Variables_and_Expressions

Lecture 5: Adding_Expressions_with_User_Variables_Demo_02

Lecture 6: Creating_Expressions_with_System_Variables_Demo_03

Lecture 7: Parameters_in_Packages_and_Projects

Lecture 8: Parameterizing_expressions_Demo_04

Lecture 9: Creating_a_custom_package_template_Demo_05

Lecture 10: Using_Configurations_Demo_06

Lecture 11: Conclusion

Chapter 8: Introduction to ETL

Lecture 1: Introduction_to_ETL_using_the_Data_Flow_Task

Lecture 2: ETL_and_the_Data_Flow_Task.

Lecture 3: Data_Source_Components

Lecture 4: Creating_a_new_ETL_Process_using_Data_Flow_Demo_01

Lecture 5: Transforms_Types

Lecture 6: Using_Lookup_Transform_Demo_02

Lecture 7: Fuzzy_Lookup_Transform

Lecture 8: Using_Fuzzy_Lookup_Demo_03

Lecture 9: Text_Mining_Transforms

Lecture 10: Using_Text_Mining_Demo_04

Lecture 11: SCD_Transform

Lecture 12: Configure_SCD_Transform_Demo_05

Lecture 13: Scripting_in_SSIS_Packages

Lecture 14: Using_Data_Profiling_Demo_06

Lecture 15: Data_Quality_Services

Lecture 16: Setting_up_and_using_DQS_Demo_07

Lecture 17: Conclision

Chapter 9: Deploying and Managing Packages

Lecture 1: Deploying_and_Managing_Packages

Lecture 2: Executing_SSIS_Packages

Lecture 3: Deploy_and_Execute_Packages_Demo_01

Lecture 4: Create_and_Use_a_Deployment_Utility_Demo_02

Lecture 5: Logging_and_Storing_Packages

Lecture 6: Turn_On_Logging_Demo_03

Lecture 7: Conclusion

Instructors

Compaq learning
One stop to learn and succeed

Rating Distribution

1 stars: 30 votes
2 stars: 51 votes
3 stars: 327 votes
4 stars: 902 votes
5 stars: 952 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu