Implementing a Data Warehouse with SQL Server 2012
4.1 (147 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,127 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Implementing a Data Warehouse with SQL Server 2012 to your Wishlist.

Add to Wishlist

Implementing a Data Warehouse with SQL Server 2012

Implementing a Data Warehouse with SQL Server 2012 (Exam 70-463)
4.1 (147 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,127 students enrolled
Created by Compaq learning
Last updated 11/2016
English
Current price: $10 Original price: $85 Discount: 88% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 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.

Who is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
90 Lectures
05:06:03
+
Introduction to Data Warehouses
6 Lectures 30:02


Data_Warehousing_Concepts
12:28

Exploring_an_OLTP_Database_and_its_Data_Warehouse_Demo_01
02:27

Introduction_to_ETL
02:16

Quiz
3 questions

Conclusion
00:52
+
Dimension Tables
10 Lectures 39:11
Dimension_Tables
00:29

Use_and_Types_of_Dimensions
04:34

Create_a_new_Dimension_Demo_01
02:28

Attributes_and_Hierarchies
09:48

Exploring_Attributes_and_Hierarchies_Demo_02
02:49

Understanding_Granularity_Demo_03
01:56

Historical_Data
03:12

Understanding_SCD_Type_2_Demo_04
02:57

Slowly_Changing_Dimensions
10:06

Quiz
3 questions

Conclusion
00:52
+
Fact Tables
7 Lectures 23:40
Fact_Table
00:46

Facts_and_Measures
05:56

Creating_and_Exploring_a_Fact_Table_Demo_01
03:40

Fact_Table_Indexing
07:36

Fact_Table_Lineage_Demo_02
01:49

Using_an_Audit_Dimension_Demo_03
02:13

Quiz
3 questions

Conclusion
01:40
+
Concepts Involved in Implementing a Data Warehouse with SQL Server 2012
6 Lectures 19:14
Concepts_Involved_in_Implementing_a_Data_Warehouse_with_SQL_Server_2012
00:39

Roles_of_SQL_Server_components
02:38

SSIS_-_Introduction
06:53

SSIS_Installation_and_Implementation_Requirements
04:36

Installing_SSIS_Demo_01
03:24

Quiz
3 questions

Conclusion
01:04
+
SSIS Overview for ETL
8 Lectures 26:40
SSIS_Overview_for_ETL
00:51

Understanding_the_Structure_of_SSIS
11:54

Setting_up_a_SSIS_Catalog_Demo_01
01:04

Creating_a_New_SSIS_Project_Demo_02
01:04

Adding_a_Connection_Manager_Demo_03
01:47

Advanced_SSIS_Projects
06:38

Viewing_and_Changing_Connection_String_Parameters_Demo_04
01:47

Quiz
3 questions

Conclusion
01:35
+
Understanding SSIS Control Flow
10 Lectures 41:03
Understanding_SSIS_Control_Flow
00:47

Understanding_the_Control_Flow_of_SSIS
05:02

Working_with_Tasks_in_Control_Flow
04:18

Adding_Tasks_to_a_Control_Flow_Demo_01
04:06

Adding_a_Container_to_the_Control_Flow_Demo_02
02:01

Understanding_Containers_and_Constraints
09:53

Adding_Constraints_to_a_Control_Flow_Demo_03
00:42

Using_Event_Handlers_and_Other_Properties
09:33

Using_Event_Handlers_Demo_04
03:07

Quiz
3 questions

Conclusion
01:34
+
Working with Variables
11 Lectures 33:26
Working_with_Variables
00:35

Understanding_variables_in_SSIS
06:54

Creating_new_variables_Demo_01
02:38

System_Variables_and_Expressions
04:29

Adding_Expressions_with_User_Variables_Demo_02
04:43

Creating_Expressions_with_System_Variables_Demo_03
01:09

Parameters_in_Packages_and_Projects
04:53

Parameterizing_expressions_Demo_04
01:51

Creating_a_custom_package_template_Demo_05
01:22

Using_Configurations_Demo_06
03:33

Quiz
3 questions

Conclusion
01:19
+
Introduction to ETL
17 Lectures 52:57
Introduction_to_ETL_using_the_Data_Flow_Task
00:45

ETL_and_the_Data_Flow_Task.
06:03

Data_Source_Components
06:28

Creating_a_new_ETL_Process_using_Data_Flow_Demo_01
03:26

Transforms_Types
01:54

Using_Lookup_Transform_Demo_02
03:13

Fuzzy_Lookup_Transform
02:17

Using_Fuzzy_Lookup_Demo_03
03:02

Text_Mining_Transforms
01:04

Using_Text_Mining_Demo_04
01:36

SCD_Transform
01:22

Configure_SCD_Transform_Demo_05
03:05

Scripting_in_SSIS_Packages
02:22

Using_Data_Profiling_Demo_06
03:20

Data_Quality_Services
01:17

Setting_up_and_using_DQS_Demo_07
10:42

Quiz
3 questions

Conclision
01:01
+
Deploying and Managing Packages
7 Lectures 19:15
Deploying_and_Managing_Packages
00:32

Executing_SSIS_Packages
05:30

Deploy_and_Execute_Packages_Demo_01
03:33

Create_and_Use_a_Deployment_Utility_Demo_02
02:30

Logging_and_Storing_Packages
03:02

Turn_On_Logging_Demo_03
03:13

Quiz
3 questions

Conclusion
00:55
+
Debugging and Securing Packages
8 Lectures 20:35
Debugging_and_Securing_Packages
00:36

Handling_Errors_and_Notifying_Operators
03:02

Debugging_SSIS
03:45

Debugging_Control_Flow_Demo_01
02:40

Debugging_Data_Flow_Demo_02
01:45

Package_Security
04:40

Securing_sensitive_data_in_a_package_Demo_03
03:16

Quiz
3 questions

Conclusion
00:51
About the Instructor
Compaq learning
4.2 Average rating
321 Reviews
2,646 Students
6 Courses
One stop to learn and succeed

With a clear motto to upgrade the skills of students from high school goers to professionals, Compaq learning started its tutoring journey in 2013. But within two years, an effort by three IT professionals that started as a blog went on to become one of the largest course developing company in the e learning industry.

We kick started our stint in the e-learning world by mentoring high school students. The passion for teaching and mentoring students gave us the confidence and courage to plunge into the e learning industry and provide various guidance for high school students to IT professionals. Until now we have trained around 15,000 students in various subjects ranging from simple mathematics to android app development. We have a group of fine instructional designers, graphic designers and SMEs who ensure that our products are original and valuable.