MCSE BI Certification Boot Camps

Master business intelligence and reporting topics and prepare for your MCSE certification in just five or six days by enrolling in one of Countrywide Training’s MCSE Business Intelligence boot camp training courses. These bootcamps explore all of the exam objectives and prepare you to become a BI and reporting engineer after earning your certification. A certified instructor goes over how to query MS SQL Server 2012, SQL Server 2012 database administration, data warehouse implementation, implementing data models and reports, and designing business intelligence with SQL Server 2012.

As you prepare for your MCSE BI certification, you must prepare to pass a series of certification exams: 70-461, 70-462, 70-463, 70-466, and 70-467. To this end, we’ve included all books, courseware, labs, and practice exams. Onsite testing and exam vouchers are also included, and if you attend in Tampa, meals, lodging, and airfare are included in the price.

Prove That You Have the Skills Reeded to Design, Build, and Deploy Solutions

Students who do not pass may retake the Microsoft certification boot camp for free within 12 months (keep your books).

Exam Numbers

70-461, 70-462, 70-463, 70-466 and 70-467

Prerequisites

This boot camp requires the MCSA: SQL Server 2012 certification (or equivalent knowledge) along with a solid understanding of MS Windows and three or more years of SQL Server (2008 or 2012) experience.

Who Should Attend

This Microsoft Business Intelligence certification training camp prepares exam candidates for MCSE BI exams. The training is also suitable for database administrators, technical consultants, systems engineers, and systems analysts who want a deeper understanding of business intelligence and reporting.

Exam 70-461: Querying Microsoft SQL Server 2012 Outline
  • 1.0 Introduction to Microsoft SQL Server 2012
  • 2.0 Getting Started with SQL Azure
  • 3.0 Introduction to T-SQL Querying
  • 4.0 Writing SELECT Queries
  • 5.0 Querying Multiple Tables
  • 6.0 Sorting and Filtering Data
  • 7.0 Working with SQL Server 2012 Data Types
  • 8.0 Using Built-In Functions
  • 9.0 Grouping and Aggregating Data
  • 10.0 Using Subqueries
  • 11.0 Using Table Expressions
  • 12.0 Using Set Operators
  • 13.0 Using Window Ranking, Offset, and Aggregate Functions
  • 14.0 Pivoting and Grouping Sets
  • 15.0 Querying SQL Server Metadata
  • 16.0 Executing Stored Procedures
  • 17.0 Programming with T-SQL
  • 18.0 Implementing Error Handling
  • 19.0 Implementing Transactions
  • 20.0 Improving Query Performance
Exam 70-462: Administering Microsoft SQL Server 2012 Databases Outline
  • 1.0 Introduction to SQL Server 2012 and its Toolset
  • 2.0 Preparing Systems for SQL Server 2012
  • 3.0 Installing and Configuring SQL Server 2012
  • 4.0 Working with Databases
  • 5.0 SQL Server 2012 Recovery Models
  • 6.0 Backup of SQL Server 2012 Databases
  • 7.0 Restoring SQL Server 2012 Databases
  • 8.0 Importing and Exporting Data
  • 9.0 Authenticating and Authorizing Users
  • 10.0 Assigning Server and Database Roles
  • 11.0 Authorizing Users to Access Resources
  • 12.0 Auditing SQL Server Environments
  • 13.0 Automating SQL Server 2012 Management
  • 14.0 Configuring Security for SQL Server Agent
  • 15.0 Monitoring SQL Server 2012 with Alerts and Notifications
  • 16.0 Performing Ongoing Database Maintenance
  • 17.0 Tracing Access to SQL Server 2012
  • 18.0 Monitoring SQL Server 2012
  • 19.0 Managing Multiple Servers
  • 20.0 Troubleshooting Common SQL Server 2012 Administrative Issues
Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012 Outline
  • 1.0 Data Warehousing
  • 2.0 Data Warehouse Hardware
  • 3.0 Designing and Implementing a Data Warehouse
  • 4.0 Creating an ETL Solution with SSIS
  • 5.0 Implementing Control Flow in an SSIS Package
  • 6.0 Debugging and Troubleshooting SSIS Packages
  • 7.0 Implementing an Incremental ETL Process
  • 8.0 Incorporating Data from the Cloud into a Data Warehouse
  • 9.0 Enforcing Data Quality
  • 10.0 Using Master Data Services
  • 11.0 Extending SQL Server Integration Services
  • 12.0 Deploying and Configuring SSIS Packages
  • 13.0 Consuming Data in a Data Warehouse
Exam 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012 Outline
  • 1.0 Introduction to Business Intelligence and Data Modeling
  • 2.0 Implementing Reports with SQL Server Reporting Services
  • 3.0 Supporting Self Service Reporting
  • 4.0 Managing Report Execution and Delivery
  • 5.0 Creating Multidimensional Databases
  • 6.0 Working with Dimensions
  • 7.0 Working with Measures and Measure Groups
  • 8.0 Introduction to MDX
  • 9.0 Customizing Cube Functionality
  • 10.0 Implementing a Tabular Data Model with Microsoft PowerPivot
  • 11.0 Introduction to DAX
  • 12.0 Implementing an Analysis Services Tabular Data Model
  • 13.0 Creating Data Visualizations with Power View
  • 14.0 Performing Predictive Analysis with Data Mining
Exam 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012 Outline
  • 1.0 Planning a BI Solution
  • 2.0 Planning SQL Server Business Intelligence Infrastructure
  • 3.0 Designing a Data Warehouse
  • 4.0 Designing an ETL Solution
  • 5.0 Designing Analytical Data Models
  • 6.0 Planning a BI Delivery Solution
  • 7.0 Designing a Reporting Services Solution
  • 8.0 Designing a Microsoft Excel-Based Reporting Solution
  • 9.0 Planning a SharePoint Server BI Solution
  • 10.0 Monitoring and Optimizing a BI Solution
  • 11.0 Operating a BI Solution
Request Onsite