Implementing a Data Warehouse with Microsoft SQL Server 2012

6 downloads 116 Views 261KB Size Report
Warehouse with Microsoft. SQL Server 2012. Course No: MS10777A. Five days • Instructor-led-Course. Level: 100 200 300 400. Microsoft. SQL Server. 2012.
DATASHEET

Implementing a Data Warehouse with Microsoft SQL Server 2012 Course No: MS10777A Five days • Instructor-led-Course Level: 100 200 300 400

Microsoft SQL Server 2012

OVERVIEW This five-day, instructor-led course provides students with the knowledge and skills necessary to create a data warehouse with SQL Server 2012, implement ETL with SQL Server Integration Services and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

MODULE 1: INTRODUCTION TO DATA WAREHOUSING  Overview of Data Warehousing  Considerations for a Data Warehouse Solution

AUDIENCE This course is intended for Database Professionals who need to fulfil a Business Intelligence Developer role.

MODULE 3: DESIGNING AND IMPLEMENTING A DATA WAREHOUSE  Logical Design for a Data Warehouse  Physical Design for a Data Warehouse

PREREQUISITES Before attending this course, students must have:  Two years’ experience working with relational databases, including: - Designing a normalised database - Creating tables and relationships - Querying with Transact-SQL  Knowledge of basic programming constructs such as looping and branching  Knowledge of key business priorities such as Revenue, Profitability and Financial Accounting MICROSOFT CERTIFIED PROFESSIONAL EXAMS This course helps you prepare for the following Microsoft Certified Professional exam(s): Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012. COURSE MATERIALS The student kit includes Microsoft Official Curriculum courseware with lab exercises for the student to keep. Online course companion material is also provided where appropriate. LAB WORK This course includes a large number of practical hands-on exercises designed to help you practice a range of valuable skills, from administering, designing, implementing and troubleshooting many of the key features and functions listed in the associated course modules opposite. Doing this in a safe and controlled environment contributes towards building confidence, further practical knowledge and experience.

MODULE 2: DATA WAREHOUSE HARDWARE  Considerations for Building a Data Warehouse  Data Warehouse Reference Architectures and Appliances

MODULE 4: CREATING AN ETL SOLUTION WITH SSIS  Introduction to ETL with SSIS  Exploring Source Data  Implementing Data Flow MODULE 5: IMPLEMENTING CONTROL FLOW IN AN SSIS PACKAGE  Introduction to Control Flow  Creating Dynamic Packages  Using Containers  Managing Consistency MODULE 6: DEBUGGING AND TROUBLESHOOTING SSIS PACKAGES  Debugging an SSIS Package  Logging SSIS Package Events  Handling Errors in an SSIS Package MODULE 7: IMPLEMENTING AN INCREMENTAL ETL PROCESS  Introduction to Incremental ETL  Extracting Modified Data  Loading Modified Data MODULE 8: INCORPORATING DATA FROM THE CLOUD INTO A DATA WAREHOUSE  Overview of Cloud Data Sources  SQL Server Database  The Windows Azure Marketplace MODULE 9: ENFORCING DATA QUALITY  Introduction to Data Quality  Using Data Quality Services to Cleanse Data  Using Data Quality Services to Match Data MODULE 10: USING MASTER DATA SERVICES  Introduction to Master Data Services  Implementing a Master Data Services Model  Using the Master Data Services Add-in for Excel MODULE 11: EXTENDING SQL SERVER INTEGRATION SERVICES  Using Custom Components in SSIS  Using Scripts in SSIS MODULE 12: DEPLOYING AND CONFIGURING SSIS PACKAGES  Overview of SSIS Deployment  Deploying SSIS Projects  Planning SSIS Package Execution MODULE 13: CONSUMING DATA IN A DATA WAREHOUSE  Introduction to Business Intelligence  Introduction to Reporting  Introduction to Data Analysis For course dates and pricing visit us online at www.nexgenn.com

BOOKINGS & ENQUIRIES: 0845 600 6061 WEB: WWW.NEXGENN.COM EMAIL: [email protected] Datasheet ©2012 Nexgenn Consulting Limited