0
  • An empty cart

    You have no item in your shopping cart

0
  • An empty cart

    You have no item in your shopping cart

Enter your keyword

MCSE SQL SERVER 2012: BUSINESS INTELLIGENCE

MCSE SQL Server 2012: Business Intelligence

Course code

MCSE-12BI

COURSE OVERVIEW

MCSE: Business Intelligence training validates the skills that you needed to design, build and deploy solutions that deliver more data to more people across the organisation.

Exams covered in this Course are:

  • Exam 70-461 – Querying Microsoft SQL Server 2012
  • Exam 70-462 – Administering Microsoft SQL Server 2012 Databases
  • Exam 70-463 – Implementing a Data Warehouse with Microsoft SQL Server 2012
  • Exam 70-466 – Implementing Data Models and Reports with Microsoft SQL Server 2012
  • Exam 70-467 – Designing Business Intelligence Solutions with Microsoft SQL Server 2012

What is included

  • You will get trained to create and control cost-effective, safe and agile server infrastructure.
  • The Desktop Infrastructure that is updated and included in this course educates you the ways to implement flexible, sustainable, reliable and free of friction access to any type of company and corporate resources and services among different platforms and devices.
  • Licensed software for practice at home
  • VAT

Course Start Dates

Start Date Time DaysDuration Location
27/02/2017 10.00-5.00pm Mon to Fri 3 Weeks Bethnal Green
27/03/2017 10.00-5.00pm Mon to Fri 3 Weeks Wembley
24/04/201710.00-5.00pm Mon to Fri 3 Weeks Oxford Street
29/05/201710.00-5.00pm Mon to Fri 3 Weeks Bethnal Green
26/06/2017 10.00-5.00pm Mon to Fri 3 Weeks Wembley
24/07/2017 10.00-5.00pm Mon to Fri 3 Weeks Oxford Street
28/08/2017 10.00-5.00pm Mon to Fri 3 Weeks Bethnal Green
25/09/201710.00-5.00pm Mon to Fri 3 Weeks Wembley
23/10/2017 10.00-5.00pm Mon to Fri 3 Weeks Oxford Street
27/11/2017 10.00-5.00pm Mon to Fri 3 Weeks Bethnal Green
29/01/2017 10.00-5.00pm Mon to Fri 3 Weeks Oxford Street

You can choose your dates while you enroll this course

Target Audience

  • Programmers
  • Forms Developer
  • Functional Implementer
  • Portal Developer
  • Technical Consultant
  • Reports Developer
  • End Users
  • Application Developers

Course Mode

Instructor led lab based training. Small classes 3-4 delegates. This course is divided into theory and practical sessions, students are expected to perform lab tutorials along with theory sessions and our labs are equipped with all the necessary equipments to gain hands on practical experience.

Course Duration

Full-time 2 weeks or part time 10 Weeks weekends. Students are expected to study outside of their teaching hours to increase their productivity during their study.

Course Outcome

Students will gain practical knowledge required for the Microsoft MCSE certification exam and will be able to apply their knowledge in real world environment.

At the end of the course students can apply for the following job roles

  • Business Intelligence Developer

Course Content

MCSE 2012: Business Intelligence Training

  • Introduction to Microsoft SQL Server 2012
  • Getting Started with SQL Azure
  • 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
  • Using Subqueries
  • 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 Error Handling
  • Implementing Transactions
  • Improving Query Performance

  • Introduction to SQL Server 2012 and its Toolset
  • Preparing Systems for SQL Server 2012
  • Installing and Configuring SQL Server 2012
  • Working with Databases
  • Understanding SQL Server 2012 Recovery Models
  • Backup of SQL Server 2012 Databases
  • Restoring 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

  • 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
  • Developing Microsoft SQL Server 2012 Databases
  • Designing Database Solutions for 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 Multidimensional DatabasesThe fundamental purpose of using SQL Server Analysis Services
  • 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 Analysis Services Tabular Data Model
  • Creating Data Visualizations with Power View
  • Performing Predictive Analysis with Data Mining

  • 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

Reviews Statistic

4
4 out of 4
1 Ratings
5 Start 0
4 Start 1
3 Start 0
2 Start 0
1 Start 0

1 review for MCSE SQL Server 2012: Business Intelligence

  1. 4 out of 5

    :

    Great trainer, worth it. Thus course Help me to get my dream job.

Add a review

Duration 3 Weeks
Price £4,900.00

Choose Start Date *

Choose Package *

Location map

Share our course