Prove that you have the skills and techniques needed to design, build, and deploy solutions that deliver more data to more people across the organization.
The Academy’s MCSE SQL Server 2012 Business Intelligence Boot Camp is a combination of the following official Microsoft courses:
Querying Microsoft SQL Server 2012: 10774 (exam 70-461)
Administering Microsoft SQL Server 2012 Databases: 10775 (exam 70-462)
Implementing a Data Warehouse with Microsoft SQL Server 2012: 10777 (exam 70-463)
Implementing Data Models and Reports with Microsoft SQL Server 2012: 10778 (exam 70-466)
Designing Business Intelligence Solutions with Microsoft SQL Server 2012: 20467 (exam 70-467)
This MCSE certification requires you to show continued ability to perform in your chosen solution area by completing a recertification exam every three years.
This 14-day boot camp 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. This course also 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. Data warehousing is a solution organizations use to centralize business data for reporting and analysis. This 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. Business intelligence (BI) is becoming increasingly important for companies of many different sizes and types because of the competitive edge it can help to give them. The combined capabilities of Microsoft SQL Server 2012 and Microsoft SharePoint 2010 make it easier than ever for companies to develop a BI solution that meets their specific needs, provides reduced total cost of ownership (TCO), and achieves a faster time to solution. This course teaches students how to empower information workers through self-service analytics and reporting. Students will learn how to implement multidimensional analysis solutions, create PowerPivot and tabular data models, deliver rich data visualizations with PowerView and SQL Server Reporting Services, and discover business insights by using data mining. This course teaches students how to design and implement a BI infrastructure. The course discusses design, installation. The course discusses design, installation, and maintenance of a BI platform.
After completing this course, students will be able to:
•Query: multiple tables, SQL Server metadata
•Use: built-in functions, subqueries, set operators, table expressions, window ranking, offset and aggregate functions
•Execute stored procedures
•Implement error handling and transactions
•Sort and filter data
•Program with T-SQL
•Improve query performance
•Plan and install SQL Server.
•Describes the system databases, the physical structure of databases and the most common configuration options related to them.
•Explain the concept of the transaction log and SQL Server recovery models and implement different backup strategies available with SQL Server.
•Create SQL Server Backups.
•Restore SQL Server databases.
•Use the import/export wizards and explain how they relate to SSIS.
•Work with: SQL Server security models, logins and users; fixed server roles, user-defined server roles, fixed database roles and user-defined database roles; permissions and the assignment of permissions; SQL Server Audit, SQL Server Agent, jobs and job history.
•Implement SQL Server agent security, proxy accounts and credentials.
•Configure database mail, alerts and notifications.
•Create database maintenance plans.
•Work with SQL Profiler and SQL Trace stored procedures.
•Introduce DMVs and the configuration of data collection.
•Work with Central Management Servers and Multi-Server queries, Virtualization of SQL Server and Data-Tier Applications.
•Troubleshoot SQL Server databases.
•Describe data warehouse concepts and architecture considerations.
•Select an appropriate hardware platform for a data warehouse.
•Design and implement a data warehouse.
•Implement: Data Flow in an SSIS Package, Control Flow in an SSIS Package, an SSIS solution that supports incremental data warehouse loads and changing data, data cleansing by using Microsoft Data Quality Services, Master Data Services to enforce data integrity
•Debug and Troubleshoot SSIS packages.
•Integrate cloud data into a data warehouse ecosystem infrastructure.
•Extend SSIS with custom scripts and components.
•Deploy and Configure SSIS packages.
•Describe how information workers can consume data from the data warehouse.
•Describe the components, architecture, and nature of a BI solution.
•Create: reports with Reporting Services, reusable report items that simplify self-service reporting.
•Manage report execution and delivery.
•Create a multidimensional database with Analysis Services.
•Implement: dimensions in a cube, measures and measure groups in a cube, a Tabular Data Model in PowerPivot, a Tabular Database.
•Use: MDX Syntax, DAX to query a tabular model, PowerView to create interactive data visualizations, Data Mining for Predictive Analysis
•Plan: the components of a BI solution, a BI infrastructure, analytical data models, a BI delivery solution, SharePoint Server BI solution, for BI operations.
•Design: a data warehouse, an ETL solution, Reporting Services solution, Excel reporting solution
•Monitor and optimize a BI solution.