MCSE: SQL Server 2012 Data and BI Platform Training & Certification Courses
 800 Ratings

Expert Chat

Microsoft #1 Training Partner

Get Trained by Industry Expert

#1 Offshore IT Training Company

Overview

The Microsoft Certified Solutions Expert (MCSE) certification in SQL Server 2012 Data and BI platform from Koenig Solutions enables you to demonstrate your core expertise in building on-premise or cloud data solutions for enterprises.

This course provides a combination of both MCSE : Data Platform and MCSE: BI platform certifications. This progressive training program enables professionals to excel both in database administrator and BI developer roles.

Course Content / Exam(s)

Schedule for MCSE: SQL Server 2012 Data and BI Platform

Course # Course Name Exam # Duration (days)
10774 Querying Microsoft SQL Server 2012 Databases

Course Content

Course 10774: Querying Microsoft SQL Server 2012 Databases

  • Introduction to T-SQL Querying
  • Writing SELECT Queries
  • Querying Multiple Tables
  • Sorting and Filtering Data
  • Working with SQL Server 2012 Data Types
  • Using Built-In Functions
  • Grouping and Aggregating Data
  • Write queries which use scalar and multi-result subqueries
  • Introduction to Microsoft SQL Server 2012
  • Getting Started with SQL Azure
  • Using Table Expressions
  • Using Set Operators
  • Using Window Ranking, Offset and Aggregate Functions
  • Pivoting and Grouping Sets
  • Querying SQL Server Metadata
  • Executing Stored Procedures
  • Programming with T-SQL
  • Implementing Transactions
  • Improving Query Performance
70-4615
10775 Administering Microsoft SQL Server 2012 Databases

Course Content

Course 10775: Administering Microsoft SQL Server 2012 Databases

  • Introduction to SQL Server 2012 and its Toolset
  • Preparing Systems for SQL Server 2012
  • Installing and Configuring SQL Server 2012
  • Working with Databases
  • Under standing SQL Server 2012 Recovery Models
  • Backup of SQL Server 2012 Databases
  • Res toring SQL Server 2012 Databases
  • Importing and Exporting Data
  • Authenticating and Authorizing Users
  • Assigning Server and Database Roles
  • Authorizing Users to Access Resources
  • Auditing SQL Server Environments
  • Automating SQL Server 2012 Management
  • Configuring Security for SQL Server Agent
  • Monitoring SQL Server 2012 with Alerts and Notifications
  • Performing Ongoing Database Maintenance
  • Tracing Access to SQL Server 2012
  • Monitoring SQL Server 2012
  • Managing Multiple Servers
  • Troubleshooting Common SQL Server 2012 Administrative Issues
70-4625
10777 Implementing a Data Warehouse with Microsoft SQL Server 2012

Course Content

Course 10777: Implementing a Data Warehouse with Microsoft SQL Server 2012

  • Introduction to Data Warehousing
  • Data Warehouse Hardware
  • Designing and Implementing a Data Warehouse
  • Creating an ETL Solution with SSIS
  • Implementing Control Flow in an SSIS Package
  • Debugging and Troubleshooting SSIS Packages
  • Implementing an Incremental ETL Process
  • Incorporating Data from the Cloud into a Data Warehouse
  • Enforcing Data Quality
  • Using Master Data Services
  • Extending SQL Server Integration Services
  • Deploying and Configuring SSIS Packages
  • Consuming Data in a Data Warehouse
70-4635
10776 Developing Microsoft SQL Server 2012 Databases

Course Content

Course 10776: Developing Microsoft SQL Server 2012 Databases

  • Introduction to SQL Server 2012 and its Toolset
  • Working with Data Types
  • Designing and Implementing Tables
  • Ensuring Data Integrity through Constraints
  • Planning for SQL Server 2012 Indexing
  • Implementing Table Structures in SQL Server 2012
  • Reading SQL Server 2012 Execution Plans
  • Improving Performance through Nonclus tered Indexes
  • Designing and Implementing Views
  • Designing and Implementing Stored Procedures
  • Merging Data and Passing Tables
  • Designing and Implementing User-Defined Functions
  • Creating Highly Concurrent SQL Server 2012 Applications
  • Handling Errors in T-SQL Code
  • Responding to Data Manipulation via Triggers
  • Implementing Managed Code in SQL Server 2012
  • Storing XML Data in SQL Server 2012
  • Querying XML Data in SQL Server
  • Working with SQL Server 2012 Spatial Data
  • Working with Full-Text Indexes and Queries
70-4645
20465 Designing Database Solutions for Microsoft SQL Server 2012

Course Content

Course 20465: Designing Database Solutions for Microsoft SQL Server 2012

  • Designing a Database Server Infrastructure
  • Designing a Logical Database Schema
  • Designing a Physical Database Implementation
  • Incorporating Data Files into Databases
  • Tuning Database Performance
  • Designing Database Security
  • Policy Based Management
  • Monitoring Server Health
  • Designing a Database Backup Solution
  • Automating Multi-Server Maintenance
  • Managing SQL Server with PowerShell
  • Replicating Data
  • Planning High Availability
70-4655
10778 Implementing Data Models and Reports with Microsoft SQL Server 2012

Course Content

Course 10778: Implementing Data Models and Reports with Microsoft SQL Server 2012

  • Introduction to Business Intelligence and Data Modeling
  • Implementing Reports with SQL Server Reporting Services
  • Supporting Self Service Reporting
  • Managing Report Execution and Delivery
  • Creating Multidimens ional Databases
  • Working with Dimensions
  • Working with Measures and Measure Groups
  • Introduction to MDX
  • Customizing Cube Functionality
  • Implementing a Tabular Data Model with Microsoft PowerPivot
  • Introduction to DAX
  • Implementing an Analys is Services Tabular Data Model
  • Creating Data Visualizations with Power View
  • Performing Predictive Analys is with Data Mining
70-4665
20467 Designing Business Intelligence Solutions with Microsoft SQL Server 2012

Course Content

Course 20467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012

  • Planning a BI Solution
  • Planning SQL Server Business Intelligence Infrastructure
  • Designing a Data Warehouse
  • Designing an ETL Solution
  • Designing Analytical Data Models
  • Planning a BI Delivery Solution
  • Designing a Reporting Services Solution
  • Designing a Microsoft Excel-Based Reporting Solution
  • Planning a SharePoint Server BI Solution
  • Monitoring and Optimizing a BI Solution
  • Operating a BI Solution
70-4675
Rest Day 1

Course Content

Course : Rest Day 1

    1
    Rest Day 2

    Course Content

    Course : Rest Day 2

      1
      Rest Day 3

      Course Content

      Course : Rest Day 3

        1
        Rest Day 4

        Course Content

        Course : Rest Day 4

          1
          Rest Day 5

          Course Content

          Course : Rest Day 5

            1
            Rest Day 6

            Course Content

            Course : Rest Day 6

              1
              Total 41

              Course Prerequisites

              Before attending this course, students must have:

              • Working knowledge of relational databases.
              • Basic knowledge of the Microsoft Windows operating system and its core functionality.

              MCSE: SQL Server 2012 Data and BI Platform Benefits

              Upon Completion of this Course, you will accomplish following:

              This MCSE combo course will cover the following modules and areas of learning:

              Students enrolled for this course will learn how to maintain, troubleshoot and manage SSAS databases in their organizations. Therefore, this MCSE training is highly recommended for database professionals who need to design and deploy database solutions with Business Intelligence in their organizations.

              During this course the students will also earn the MCSA certification.

              Give an edge to your career with Koenig Customized Courses certification training courses. Students can join the classes for MCSE: SQL Server 2012 Data and BI Platform at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.

              Enquire Now

               


               
              Loading...

              Processing data, please wait...