• Microsoft Certified Solutions Expert(MCSE) SQL Certification


  • classroom training. Instructor led hands-on classes.

Certification Exams:

  • 5 Exams, Real Time Simulation, Single and Multiple Choice Questions


Course Length:

  • 7 Weeks or Fast Track 7 Days


  • Hands-on Training, Lab Exercises, Project work, Unlimited Lab Access, Free Re-training


  • Liverpool Street, London
  • London Bridge, London
  • Moorgate, London

Flexible Starting Dates:

  • on Weekdays, Weekends and Evenings

Detail Syllabus

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

MCSE: SQL Server 2012 Data Platform

MCSE SQL Exam: Querying Microsoft SQL Server 2012 70-461

Microsoft SQL Server 2012 and Tools
  • Overview Microsoft SQL Server 2012
  • MS SQL Server Management Studio
  • Creating and Managing T-SQL scripts
  • Microsoft SQL Server 2012 architecture
SQL Azure
  • Overview of SQL Azure
  • Features of SQL Azure.
  • Provision a SQL Azure server and configure its security.
T-SQL Querying
  • T-SQL Scripts, Sets, Predicate Logic
  • Logical Order of Operations in SELECT statements
  • SELECT Statements, filter data, sort data using ORDER BY
SELECT Queries
  • SELECT statement, focusing on queries against a single table.
  • Eliminating Duplicates with DISTINCT
  • Using Column and Table Aliases
  • CASE Expressions, DISTINCT clause
Querying Multiple Tables
  • Understanding Joins, Inner Joins, Outer Joins, Cross Joins, Self Joins,
  • Multiple-Table Inner Join, self-joins and cross joins queries
Sorting and Filtering Data
  • Sorting Data, WHERE Clause, TOP and OFFSET-FETCH, ORDER BY
Working with SQL Server 2012 Data Types
  • SQL Server 2012 Data Types, Character Data, Character Functions
Using Built-In Functions, Grouping and Aggregating Data
  • Writing Queries with Built-In Functions, Conversion Functions
  • Using Logical Functions, Functions to Work with NULL
  • Using Aggregate Functions, GROUP BY Clause,
  • Filtering Groups with HAVING
Using Subqueries and Table Expressions
  • Correlated Subqueries, Self-Contained Subqueries
  • Using Derived Tables, Common Table Expressions
  • Using Views, Inline Table-Valued Functions
Using Set Operators
  • Using EXCEPT and INTERSECT, Set Operators
  • UNION set operators and UNION ALL multi-set operators
  • CROSS APPLY and OUTER APPLY operators
  • EXCEPT and INTERSECT operators
Pivoting and Grouping Sets
Querying SQL Server Metadata
  • Querying System Catalog Views and Functions
  • Executing System Stored Procedures
  • Querying Dynamic Management Objects
  • Querying System Catalog Views
  • Querying System Functions
  • Querying System Dynamic Management Views
Executing Stored Procedures
  • Passing Parameters to Stored Procedures, Dynamic SQL
  • Pass parameters to stored procedures
  • Execute system stored procedures
Programming with T-SQL
  • Controlling Program Flow and Elements
  • Variables and Delimiting Batches, Synonyms, Error Handling, TRY / CATCH Blocks, THROW
Implementing Transactions
  • Transactions and the Database Engine, Controlling Transactions, BEGIN, COMMIT, and ROLLBACK
  • Adding error handling to a CATCH block
Improving Query Performance
  • Factors in Query Performance, Execution Plans, role of indexes

MCSE SQL Exam: Administering Microsoft SQL Server 2012 Databases 70-462

MS SQL Server 2012 and its Toolset
  • SQL Server Platform, Server Tools, SQL Service Services, Component Installation
  • SQL Server New Instance, Name Pipes Protocol, Aias
  • Ensuring SQL Browser is Disabled and Configure a Fixed TCP/IP Port
Preparing Systems for SQL Server 2012
  • SQL Server Architecture, Resource Requirement,
  • Test Server, Memory Configuration
Installing and Configuring SQL Server 2012
  • Installing SQL Server, Upgrading and Automating Installation
  • Install the SQL Server instance, Configure Server Memory
Database, Datafiles and SQL Server 2012 Recovery Models
  • MS SQL Server Databases Data Files, Log files
  • Working with Files and Filegroups
  • Moving Database Files, tempdb configuration, RateTracking datbase
  • Adjust tempdb configuration
  • Create the RateTracking database
  • Attach the OldProspects database
  • Add multiple files to tempdb
  • Backup Strategies, SQL Server Transaction Logging
  • Planning a SQL Server Backup Strategy, Recovery Models
  • Plan a backup strategy, Configure Reovery Models
  • Critical concepts surrounding backup strategies.
  • Transaction logging capabilities within the SQL Server database engine..
Backup of SQL Server 2012 Databases
  • Backing up Databases and Transaction Logs, Managing Database Backups
  • Working with Backup Options, Investigate backup compression
  • Differential, Copy-only, Partial backup
Restoring SQL Server 2012 Databases
  • Restoring Databases, Restore Process, Point-in-time recovery
  • Restoring System Databases and Individual Files
  • Restore strategy, STANDBY mode
Importing and Exporting Data
  • Importing & Exporting Table Data, Inserting Data in Bulk
  • Import the Excel spreadsheet, CSV File
Authenticaton and Authorizing Users
  • Authenticating Connections to SQL Server
  • Authorizing Logins to Access Databases
  • Authorization Across Servers, Create and Manage Logins, Database Users vs OS Users
Server and Database Roles
  • Server Roles, Fixed Database Roles, User-defined Database Roles, Check Role Assignments
Authorizing Users to Access Resources
  • User Access to Objects, Execute Code, Permission Schema Level
Auditing SQL Server Environments
  • Auditing Data Access in SQL, SQL Server Audit
  • Audit configuration and create audit
Automating SQL Server 2012 Management
  • Automating SQL Server Management
  • SQL Server Agent, Agent Jobs
  • Troubleshoot a Failing Job
  • SQL Server Agent Security, Configuring Credentials
Monitoring SQL Server 2012 with Alerts and Notifications
  • Configuration of Database Mail, SQL Server Errors
  • Monitoring SQL Server Errors, Alerts and Notifications
  • Configuring Operators, Alerts and Notifications
Performing Ongoing Database Maintenance
  • Ensuring Database Integrity, Maintaining Indexes
  • Check database integrity using DBCC CHECKDB
  • Correct index fragmentation
  • Create a database maintenance plan
  • Investigate table lock performance
Tracing Access to SQL Server 2012
  • Capturing Activity using SQL Server Profiler
  • Improving Performance with the Database Engine Tuning Advisor
  • Configure SQL Trace
Monitoring SQL Server 2012
  • Monitoring Activity, Capturing and Managing Performance Data
  • Configure Management Data Warehouse
  • Configure Instances for Data Collection
  • Work with Data Collector Reports
Managing Multiple Servers
  • Working with Multiple Servers, Virtualizing, Data-Tier Applications,

Implementing a Data Warehouse with Microsoft SQL Server 2012 70-463

MS SQL 2012 Data Warehousing
  • Data Warehousing, Data Warehouse Solution, ETL solution
  • Planning and Building a Data Warehouse
  • Data Warehouse Reference Architectures and Appliances
Designing and Implementing a Data Warehouse
  • Logical Design for a Data Warehouse, Physical Design for a Data Warehouse
  • Implementing a Star Schema, Snowflake Schema and Time Dimension Table
Creating an ETL Solution with SSIS and SSIS Package
  • ETL with SSIS, Source Data, Data, Flow
  • Control Flow, Creating Dynamic Packages
  • Using Containers, Managing Consistency
  • Using Variables and Parameters, Containers, Transactions, Checkpoints
Troubleshooting SSIS Packages
  • Debugging an SSIS Package, Logging, Errors, Event Handler
Implementing an Incremental ETL Process
  • Incremental ETL, Extracting Modified Data
  • Loading Modified Data, Using a DateTime Column to Incrementally Extract Data
  • Using a Change Data Capture, Using Change Tracking
  • Using a Lookup Transformation to Insert Dimension Data
  • Using a MERGE Statement to Load Fact Data
Cloud Data into a Data Warehouse
  • Cloud Data Sources, SQL Server Database
  • The Windows Azure Marketplace, SQL Azure Database
Enforcing Data Quality and Deduplicating Data
  • Data Quality, Using Data Quality Services to Cleanse Data
  • Using Data Quality Services to Match Data
  • Creating a Matching Policy, DQS Project to Match Data
Using Master Data Services
  • Implement a Master Data Services
  • Using the Master Data Services Add-in for Excel
  • Enforcing Business Rules
Deploying and Configuring SSIS Packages
  • Overview of SSIS Deployment
  • Planning SSIS Package Execution, Create a SSIS Catalog
  • SSIS Solution
  • Scheduling SSIS Packages with SQL Server Agent
Consuming Data in a Data Warehouse
  • Business Intelligence, Reporting, Data Analysis, PowerPivot

Developing Microsoft SQL Server 2012 Databases 70-464

Designing and Implementing Tables
  • Designing Tables, Working with Schemas
  • Creating and Altering Tables, Table Design
  • Improving the Design of Tables
SQL Server 2012 Indexing
  • Core Indexing Concepts
  • Data Types and Indexes
Implementing Table Structures in SQL Server 2012
  • SQL Server Table Structures, Clustered Indexes,
  • Comparing the Performance of Clustered Indexes vs. Heaps
Designing Effective Nonclustered Indexes
  • Implementing Nonclustered Indexes, Database Engine Tuning Advisor
  • Nonclustered index, SQL Server Profiler and Database Engine Tuning Advisor
Designing and Implementing Views, Stored Procedures
  • Introduction to Views, Creating and Managing Views
  • Performance Considerations for Views
  • Introduction to Stored Procedures, Manage and Implement Stored Procedures
  • Implementing Parameterized Stored Procedures
User-Defined Functions
  • Overview of Functions, Implementing Scalar Functions, Table-Valued Functions
Creating Highly Concurrent SQL Server 2012 Applications
  • Introduction to Transactions, Locks, Deadlocks, Isolation Levels
Responding to Data Manipulation via Triggers
  • Implementing DML Triggers
  • Designing DML Triggers
  • Advanced Trigger Concepts
Implementing Managed Code in SQL Server 2012
  • Introduction to SQL CLR Integration
  • Importing and Configuring Assemblies
  • Storing XML Data and Schemas in SQL Server
  • Introduction to XML and XML Schemas
  • Implementing the XML Data Type
  • XML Data Storage in SQL Server, XML Data in Variables
Querying XML Data in SQL Server
  • Using the T-SQL FOR XML Statement
  • XQuery, Shredding XML
  • Query SQL Server data as XML
Working with Full-Text Indexes and Queries
  • Introduction to Full-Text Indexing, stoplist

Designing Database Solutions for SQL Server 2012 70-465

Designing a Database Server Infrastructure
  • Introduction to Database Server Infrastructure
  • Planning a Database Server Infrastructure
  • Planning for Consolidation, Single Instance, Single Windows Server, Virtual Servers
Designing a Database Solution for BLOB Data
  • Considerations for BLOB Data, Working with FileStream
  • Using Full-text Search, Creating FileTable
Tuning Database Performance
  • Optimizing Query Performance with Indexes,
  • Performance Monitoring and Tuning
Designing Database Security
  • Designing Database-Level Security, Server -Level Security, Transparent Database Encryption
  • Security for MIA-SQL Instance and the Human Resources Database
  • Implementing Security for SQL Server Agent
Monitoring Server Health
  • Using the SQL Server Utility
  • Creating a Utility Control Point, Configuring Health Policies
  • Analyzing Server Health Issues
Managing SQL Server with PowerShell
  • Introduction to PowerShell, Backing up a Database Using PowerShell
Replicating Data
  • SQL Server Replication, Plan and Implementing Replication

Price Info

  • Hands-on Tutor Led Training
  • Classroom Based Practical Training
  • Unlimited Practice Lab Access
  • Small Size Class and Interactive Sessions
  • Lab Exercises
  • Mock Exam
  • WiFi Internet
  • Refreshments
  • Completion Certificate
  • Free Re-training
  • Cost is calculated at 70 percent Tuition Vatable and 30 percent Training Book(s) with 0 rated Vat

Package Offer: Great Savings!!!

Career Package

MCSA SQL Server 2012 - £1250+MCSE SQL Server 2012 - £3000 +MCSE Server 2012 - £1750 : Total Price £4750

Professional Package

MCSA SQL Server 2012 - £1250+Oracle 11g OCP - £3500 : Total Price £4750

Specialised Package

MCSA SQL Server 2012 - £1250+MCSE Server 2012 - £1750 : Total Price £3000

  • Microsoft Certified Solutions Expert(MCSE) SQL Certification
  • Classroom training. Instructor led hands-on classes.
  • 5 Exams, Real Time Simulation, Single and Multiple Choice Questions
  • 7 Weeks or Fast Track 7 Days
  • Lab Exercises, Project work, Unlimited Lab Access, Free Re-training
  • Training on Weekdays, Weekends and Evenings
Brochure Request