Description
Microsoft Certified Solutions Expert (MCSE): Business Intelligence training program is ideal for IT Professionals.
9420 Research Blvd. Echelon III Suite 200| 512-346-8110|www.pec.stedwards.edu
Microsoft Certified Solutions
Expert (MCSE): Business Intelligence
The St. Edward’s University Professional Education Microsoft Certified Solutions Expert (MCSE): Business
Intelligence training program is ideal for IT Professionals interested in demonstrating the skills and
techniques needed to create BI solution including implementing multi-dimensional data models,
implementing and maintaining OLAP cubes, and creating information displays used in business decision
making.
Possible Job Roles:
? Database Administrator
? Data storage manager
? Database analyst
? BI Architects
? Business systems analyst
? Application systems analyst
? Database architect
? Solutions architect
Program Details:
In addition to obtaining a Certificate of Achievement from The St. Edward’s University Professional
Education, this program will help prepare you for the Microsoft Certified Solutions Expert (MCSE):
Business Intelligence certification exams.
Certificate Program Include:
? 5 Courses (Microsoft Certified Trainers)
? Microsoft Official Courseware
? 5 Exam Vouchers
? 5 Practice Exams
? Free Class Retakes (one year after class, with original courseware)
Competencies Covered:
Upon Completion of the St. Edward’s University Professional Education Microsoft Certified Solutions Expert
(MCSE): Business Intelligence training programs students will be able to:
? Plan Business Intelligence (BI) Infrastructure
? Design BI Infrastructure
? Design a Reporting Solution
? Design BI Data Models
? Design an ETL Solution
? Build an Analysis Services Database
? Manage, Maintain, and Troubleshoot an SSAS Database
? Build a Tabular Data Model
? Build a Report with SQL Server Reporting Services (SSRS)
Recommended Training Path:
Course 10774 Querying Microsoft SQL Server 2012
Exam: 70-461
Overview: This 5-day course provides students with the technical skills required to write basic Transact-
SQL queries for Microsoft SQL Server 2012. This course is the foundation for all SQL Server-
related disciplines; namely, Database Administration, Database Development and Business
Intelligence.
Prerequisite: Students should have a working knowledge of relational databases.
Course
Outline:
Module 1: Introduction to Microsoft SQL Server
2012
Module 2: Getting Started with SQL Azure
Module 3: Introduction to T-SQL Querying
Module 4: Writing SELECT Queries
Module 5: Querying Multiple Tables
Module 6: Sorting and Filtering Data
Module 7: Working with SQL Server 2012 Data
Types
Module 8: Using Built-In Functions
Module 9: Grouping and Aggregating Data
Module 10: Using Subqueries
Module 11: Using Table Expressions
Module 13: Using Window Ranking, Offset and
Aggregate Functions
Module 14: Pivoting and Grouping Sets
Module 15: Querying SQL Server Metadata
Module 16: Executing Stored Procedures
Module 17: Programming with T-SQL
Module 18: Implementing Error Handling
Module 19: Implementing Transactions
Module 20: Improving Query Performance
Note:
Microsoft has not yet released a course to correspond for exam Microsoft exam: 70-467. The course will
be including in the Microsoft Certified Solutions Expert (MCSE): Business Intelligence training program
upon release
9420 Research Blvd. Echelon III Suite 200| 512-346-8110|www.pec.stedwards.edu
Course 10775 Administering Microsoft SQL Server 2012 Databases
Exam: 70-462
Overview: This five-day instructor-led course provides students with the knowledge and skills to maintain
a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use
SQL Server 2012 product features and tools related to maintaining a database.
Prerequisite: Course:10774 Querying Microsoft SQL Server 2012
Course
Outline:
Module 1: Introduction to SQL Server 2012
and its Toolset
Module 2: Preparing Systems for SQL Server
2012
Module 3: Installing and Configuring SQL
Server 2012
Module 4: Working with Databases
Module 5: Understanding SQL Server 2012
Recovery Models
Module 6: Backup of SQL Server 2012
Databases
Module 7: Restoring SQL Server 2012
Databases
Module 8: Importing and Exporting Data
Module 9: Authenticating and Authorizing Users Module
10: Assigning Server and Database Roles Module 11:
Authorizing Users to Access Resources
Module 12: Auditing SQL Server Environments
Module 13: Automating SQL Server 2012 Management
Module 14: Configuring Security for SQL Server Agent
Module 15: Monitoring SQL Server 2012 with Alerts and
Notifications
Module 16: Performing Ongoing Database Maintenance
Module 17: Tracing Access to SQL Server 2012
Module 18: Monitoring SQL Server 2012
Module 19: Managing Multiple Servers
Module 20: Troubleshooting Common SQL Server 2012
Administrative Issues
Course: 10777 Implementing a Data Warehouse with Microsoft SQL Server 2012
Exam: 70-463
Overview: This five-day instructor-led course focuses on teaching individuals how 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.
Prerequisite: Experience with SQL Server and exposure creating reports.
Course
Outline:
Module 1: Introduction to Data Warehousing
Module 2: Data Warehouse Hardware
Module 3: Designing and Implementing a
Data Warehouse
Module 4: Creating an ETL Solution with
SSIS
Module 5: Implementing Control Flow in an
SSIS Package
Module 6: Debugging and Troubleshooting
SSIS Packages
Module 7: Implementing an Incremental ETL Process
Module 8: Incorporating Data from the Cloud into a Data
Warehouse
Module 9: Enforcing Data Quality
Module 10: Using Master Data Services
Module 11: Extending SQL Server Integration Services
Module 12: Deploying and Configuring SSIS Packages
Module 13: Consuming Data in a Data Warehouse
Course 10778 Implementing Data Models and Reports with Microsoft SQL Server 2012
Exam: 70-466
Overview: This 5-day course describes how to empower information workers through self-service
analytics and reporting. Students will learn how to implement PowerPivot and tabular data
models, create and deliver rich data visualizations with Power View and SQL Server Reporting
Services, and discover business insights by using data mining.
Prerequisite: Course:10774 Querying Microsoft SQL Server 2012
Course
Outline:
Module 1: Introduction to Business
Intelligence and Data Modeling
Module 2: Implementing Reports with
Reporting Services
Module 3: Supporting Self-Service
Reporting
Module 4: Managing a Reporting
Infrastructure
Module 5: Creating Multidimensional
Databases
Module 6: Working with Cubes and
Dimensions
Module 7: Working with Measures and Measure
Groups
Module 8: Introduction to MDX
Module 9: Customizing Cube Functionality
Module 10: Implementing a Tabular Data Model by
Using Microsoft PowerPivot
Module 11: Introduction to Data Analysis Expression
(DAX)
Module 12: Implementing an Analysis Services Tabular
Data Model
Module 13: Creating Data Visualizations With Power
View
Module 14: Performing Predictive Analysis with Data
Mining
doc_735168369.pdf
Microsoft Certified Solutions Expert (MCSE): Business Intelligence training program is ideal for IT Professionals.
9420 Research Blvd. Echelon III Suite 200| 512-346-8110|www.pec.stedwards.edu
Microsoft Certified Solutions
Expert (MCSE): Business Intelligence
The St. Edward’s University Professional Education Microsoft Certified Solutions Expert (MCSE): Business
Intelligence training program is ideal for IT Professionals interested in demonstrating the skills and
techniques needed to create BI solution including implementing multi-dimensional data models,
implementing and maintaining OLAP cubes, and creating information displays used in business decision
making.
Possible Job Roles:
? Database Administrator
? Data storage manager
? Database analyst
? BI Architects
? Business systems analyst
? Application systems analyst
? Database architect
? Solutions architect
Program Details:
In addition to obtaining a Certificate of Achievement from The St. Edward’s University Professional
Education, this program will help prepare you for the Microsoft Certified Solutions Expert (MCSE):
Business Intelligence certification exams.
Certificate Program Include:
? 5 Courses (Microsoft Certified Trainers)
? Microsoft Official Courseware
? 5 Exam Vouchers
? 5 Practice Exams
? Free Class Retakes (one year after class, with original courseware)
Competencies Covered:
Upon Completion of the St. Edward’s University Professional Education Microsoft Certified Solutions Expert
(MCSE): Business Intelligence training programs students will be able to:
? Plan Business Intelligence (BI) Infrastructure
? Design BI Infrastructure
? Design a Reporting Solution
? Design BI Data Models
? Design an ETL Solution
? Build an Analysis Services Database
? Manage, Maintain, and Troubleshoot an SSAS Database
? Build a Tabular Data Model
? Build a Report with SQL Server Reporting Services (SSRS)
Recommended Training Path:
Course 10774 Querying Microsoft SQL Server 2012
Exam: 70-461
Overview: This 5-day course provides students with the technical skills required to write basic Transact-
SQL queries for Microsoft SQL Server 2012. This course is the foundation for all SQL Server-
related disciplines; namely, Database Administration, Database Development and Business
Intelligence.
Prerequisite: Students should have a working knowledge of relational databases.
Course
Outline:
Module 1: Introduction to Microsoft SQL Server
2012
Module 2: Getting Started with SQL Azure
Module 3: Introduction to T-SQL Querying
Module 4: Writing SELECT Queries
Module 5: Querying Multiple Tables
Module 6: Sorting and Filtering Data
Module 7: Working with SQL Server 2012 Data
Types
Module 8: Using Built-In Functions
Module 9: Grouping and Aggregating Data
Module 10: Using Subqueries
Module 11: Using Table Expressions
Module 13: Using Window Ranking, Offset and
Aggregate Functions
Module 14: Pivoting and Grouping Sets
Module 15: Querying SQL Server Metadata
Module 16: Executing Stored Procedures
Module 17: Programming with T-SQL
Module 18: Implementing Error Handling
Module 19: Implementing Transactions
Module 20: Improving Query Performance
Note:
Microsoft has not yet released a course to correspond for exam Microsoft exam: 70-467. The course will
be including in the Microsoft Certified Solutions Expert (MCSE): Business Intelligence training program
upon release
9420 Research Blvd. Echelon III Suite 200| 512-346-8110|www.pec.stedwards.edu
Course 10775 Administering Microsoft SQL Server 2012 Databases
Exam: 70-462
Overview: This five-day instructor-led course provides students with the knowledge and skills to maintain
a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use
SQL Server 2012 product features and tools related to maintaining a database.
Prerequisite: Course:10774 Querying Microsoft SQL Server 2012
Course
Outline:
Module 1: Introduction to SQL Server 2012
and its Toolset
Module 2: Preparing Systems for SQL Server
2012
Module 3: Installing and Configuring SQL
Server 2012
Module 4: Working with Databases
Module 5: Understanding SQL Server 2012
Recovery Models
Module 6: Backup of SQL Server 2012
Databases
Module 7: Restoring SQL Server 2012
Databases
Module 8: Importing and Exporting Data
Module 9: Authenticating and Authorizing Users Module
10: Assigning Server and Database Roles Module 11:
Authorizing Users to Access Resources
Module 12: Auditing SQL Server Environments
Module 13: Automating SQL Server 2012 Management
Module 14: Configuring Security for SQL Server Agent
Module 15: Monitoring SQL Server 2012 with Alerts and
Notifications
Module 16: Performing Ongoing Database Maintenance
Module 17: Tracing Access to SQL Server 2012
Module 18: Monitoring SQL Server 2012
Module 19: Managing Multiple Servers
Module 20: Troubleshooting Common SQL Server 2012
Administrative Issues
Course: 10777 Implementing a Data Warehouse with Microsoft SQL Server 2012
Exam: 70-463
Overview: This five-day instructor-led course focuses on teaching individuals how 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.
Prerequisite: Experience with SQL Server and exposure creating reports.
Course
Outline:
Module 1: Introduction to Data Warehousing
Module 2: Data Warehouse Hardware
Module 3: Designing and Implementing a
Data Warehouse
Module 4: Creating an ETL Solution with
SSIS
Module 5: Implementing Control Flow in an
SSIS Package
Module 6: Debugging and Troubleshooting
SSIS Packages
Module 7: Implementing an Incremental ETL Process
Module 8: Incorporating Data from the Cloud into a Data
Warehouse
Module 9: Enforcing Data Quality
Module 10: Using Master Data Services
Module 11: Extending SQL Server Integration Services
Module 12: Deploying and Configuring SSIS Packages
Module 13: Consuming Data in a Data Warehouse
Course 10778 Implementing Data Models and Reports with Microsoft SQL Server 2012
Exam: 70-466
Overview: This 5-day course describes how to empower information workers through self-service
analytics and reporting. Students will learn how to implement PowerPivot and tabular data
models, create and deliver rich data visualizations with Power View and SQL Server Reporting
Services, and discover business insights by using data mining.
Prerequisite: Course:10774 Querying Microsoft SQL Server 2012
Course
Outline:
Module 1: Introduction to Business
Intelligence and Data Modeling
Module 2: Implementing Reports with
Reporting Services
Module 3: Supporting Self-Service
Reporting
Module 4: Managing a Reporting
Infrastructure
Module 5: Creating Multidimensional
Databases
Module 6: Working with Cubes and
Dimensions
Module 7: Working with Measures and Measure
Groups
Module 8: Introduction to MDX
Module 9: Customizing Cube Functionality
Module 10: Implementing a Tabular Data Model by
Using Microsoft PowerPivot
Module 11: Introduction to Data Analysis Expression
(DAX)
Module 12: Implementing an Analysis Services Tabular
Data Model
Module 13: Creating Data Visualizations With Power
View
Module 14: Performing Predictive Analysis with Data
Mining
doc_735168369.pdf