Microsoft SQL Server 2012: Database Warehouse Implementation

Microsoft SQL Server 2012: Database Warehouse Implementation

Learning Outcomes:

  • Successfully deploy and/or migrate SQL Server.
  • Create Server Security, Roles and configure database security within the Activity Lab with 90% accuracy.
  • Successfully perform database backup and restore.

Upon successful completion of this five day course, students will be able to implement data warehouse in Microsoft SQL Server 2012. They will:

  • Identify the Basic Features of Data Warehouses and Data Warehousing Concepts
  • Create Dimensions and Change Granularity of Dimensions
  • Create Fact Tables and ColumnStore Indexes
  • Implement Data Warehouses in SQL Server 2012
  • Work with Integration Services
  • Manage Control Flow
  • Work with Dynamic Variables
  • Implement Data Flow
  • Manage Data Flow Capabilities
  • Manage SSIS Packages Execution
  • Debug and Troubleshoot Packages
  • Deploy Packages
  • Secure Packages and Databases
  • Work with MDS and Windows Azure


Microsoft SQL Server 2012: Database Warehouse Implementation

 This course is designed for Extract Transform Load (ETL) and Data Warehouse developers who are already handling the creation and implementation of Business Intelligence (BI) solutions such as data cleansing, ETL, and implementing Data Warehouse. This course is also intended for database professionals who aspire to become a BI developer and want to gain hands on experience on creating BI solutions.  The primary responsibilities of the students may include the following:

 

  • Implement a data warehouse
  • Develop SQL Server Integration Services (SSIS) packages for data extraction, transformation, and loading (ETL)
  • Synchronize data, migrate data, and manipulate and transform ad hoc data
  • Enforce data integrity using Master Data Services
  • Cleanse data using Data Quality Services
  • Migrate application or one-time data
  • Schedule ETL jobs
  • Manage, configure, and deploy SQL Server Integration Services (SSIS) packages


Targeted Student:  This course is also for students who are seeking the Microsoft Certified Solutions Associate (MCSA) certification and who want to take the exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012 as a stand-alone, or as part of the requirement for the MCSA: SQL Server 2012; MCSE: Data Platform; MCSE: Business Intelligence certifications.

 

Prerequisites: To ensure your success in this course you should have working knowledge of relational databases. You should also be comfortable working with the Microsoft Windows Server 2012 Operating System, and be able to use the core functionalities of Windows Server 2012. Also, working knowledge of Transact SQL queries is essential.

Click here for Registration Form


Request More Information