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: Data Platform

MCSE SQL Server 2012: Data Platform

Course code

MCSE-12DP

Course Overview

This certification will demonstrate your skill sets in building and administrating enterprise-level data solutions both on-site and in cloud environments.

MCSE: Data Platform certification will qualify you for such jobs as database analyst and database designer.

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-464 -Developing Microsoft SQL Server 2012 Databases
  • Exam 70-465 – Designing Database Solutions for SQL Server

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 TimeDays Duration Location
27/04/202010.00 - 17.00Mon to Fri3 WeeksBrentford
01/06/202010.00 - 17.00Mon to Fri3 WeeksBrentford
06/07/202010.00 - 17.00Mon to Fri3 WeeksBrentford
10/08/202010.00 - 17.00Mon to Fri3 WeeksBrentford
14/09/202010.00 - 17.00Mon to Fri3 WeeksBrentford
12/10/202010.00 - 17.00Mon to Fri3 WeeksBrentford
16/11/202010.00 - 17.00Mon to Fri3 WeeksBrentford

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

  • MS SQL Database Developer

Course Content

MCSE 2012 Data Platform

  • 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 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 Nonclustered 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

  • Designing a Database Server Infrastructure
  • Designing a Database Solution for BLOB Data
  • Tuning Database Performance
  • Designing Database Security
  • Monitoring Server Health
  • Managing SQL Server with PowerShell
  • Replicating Data

Reviews Statistic

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

Reviews

There are no reviews yet.

Be the first to review “MCSE SQL Server 2012: Data Platform”

Duration 3 Weeks
Price £4,900.00

Start Date *

Package *

Location map

Share our course