Job Guarantee Program: Digital Marketing | CAD | Database | Networking
We are OPEN and delivering training as usual. View our COVID-19 statement.

MCSE: SQL Server 2012 Data Platform

Synopsis

  • Fast Track (7 Days) – Mon to Fri (10:00-17:00)
    Weekend Track (9 Weeks) – Every Saturday (14:30–18:30)
    Regular Track (9 Weeks) – Every Friday (14:30–18:30)
    Evening Track (7 Weeks) – Every Mon & Wed (18:30–21:30)
  • Course Fee: £2400 + VAT
  • Industry Expert and Certified Instructors
  • Training Venue: Central London Location
  • Tutor Led Classroom Training

Request Brochure


Attend Instructor Led Training From Anywhere

Course Information

Early age of Information Technology has experienced an unimaginable growth, e.g. comparing the early invention of colossus computer to hand held computers of today is just unbelievable! . These tiny hand held computer can perform thousand times better and are much more reliable than those colossus computers. The development of the modern technology has enabled us to store data in very compact form where millions and trillions of data are stored and finding the information will just take fraction of a second.

The growing amount of data in every organization has to be stored in the Database; which is an organized form of data stored digitally. These data will grow gradually and can be really big and difficult to maintain and manage without proper infrastructure. Take an example of a bank which has over 30 million customers' records, making transactions every second which might be colossal records a day. It would be absolutely impossible to track the information without having database in a reliable, easy accessible and secure platform. Here comes the Microsoft SQL Server 2012 database server which has the capacity to manage huge amount of data. Microsoft SQL Server 2012 is very reliable, robust and secure platform used by many organizations to store their growing data.

Microsoft SQL Server 2012 is capable of providing unlimited amount of tables, Terabytes of data, relational data capabilities, database mirroring capabilities, automatic recovery, easy backup and restore, server cluster, database replications, data warehouse, jobs and alerts, monitoring tools, analysing tools and many more.

Why not prove your abilities and add value to your employer or to your business, by learning the core database technologies, features and implementation of Microsoft SQL Server 2012 with London Training. Microsoft have introduced IT Professional certification called Microsoft Certified Solutions Expert (MCSE): Data Platform certification which validates your skills needed to run a highly efficient Database infrastructure in this innovative SQL Server 2012 platform.

Career Prospect

Microsoft SQL Server 2012 is widely used by many organizations both small and large and this has created lots of opportunities for database administrators, software developers, system analysts, project managers, business entrepreneurs etc. Why not start your MS SQL Server 2012 training with London Training and get certified or enhance your career and knowledge to next level and find your dream job.

How we deliver this course?

Our MCSE: Data Platform course is delivered by certified, industry expert and experienced trainers who have over 12 years of experience in Database Technologies. We provide hands-on, tutor led and classroom based training in Central London.

Career Prospect

Microsoft Database Engineer, Microsoft SQL DBA, Microsoft Database Administrator, Microsoft Database Consultant, Freelancer Microsoft SQL DBA, Microsoft Database Designer

Learning Facilities

We have immaculate learning facilities with state of art technology, fully equipped with high specs latest servers, workstations and software.

General Facilities

We also provide Free Wifi Internet, Refreshment, Water, Tea and Coffee Facilities.

Registration Process

Speak with course advisor about MCSE SQL training in London. Call us: 0207 256 7722

Course Fee: £2400 + VAT

  • Hands-on Tutor Led Training
  • Classroom Based Practical Training
  • Unlimited Practice Lab Access
  • Small Size Class and Interactive Sessions
  • Lab Exercises
  • Project Work
  • WiFi Internet
  • Refreshments
  • Completion Certificate
  • Free Re-training
  • The course fee excludes VAT
Interest Free Credit for IT course

Pay Monthly.

Interest Free Installments Upto 1 Year.

Contact


MCSE: SQL Server 2012 Data Platform

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

Course Syllabus

Querying Microsoft SQL Server 2012 70-461

Microsoft SQL Server 2012 and its features

  • Microsoft SQL Server 2012 and its features
  • MS SQL Server 2012 Management Studio

SQL Server 2012 Tools

  • SQL Server Management Studio, Creating and Organizing T-SQL scripts
  • architecture and editions of SQL Server 2012

SQL Azure Overview

  • Overview of SQL Azure
  • Features of SQL Azure.

T-SQL Querying and Select Statements

  • T-SQL, Sets, Order of Operations in SELECT statements
  • Filter data using predicates
  • Sort data using ORDER BY
  • SELECT statement, Eliminating Duplicates with DISTINCT
  • Using Column and Table Aliases, CASE Expressions

Multiple Table Joins

  • Joins, Inner Joins, Outer Joins, Cross Joins and Self Joins

Sorting and Filtering Data

  • Sorting Data, WHERE Clause, TOP and OFFSET-FETCH Options

SQL Server 2012 Data Types

  • SQL Server 2012 Data Types, Character Data, Time Data, Time Function, Character Functions

Built-In Functions

  • Queries with Built-In Functions, Conversion Functions
  • Using Logical Functions, Work with NULL

Grouping and Aggregating Data

  • Aggregate Functions,
  • Filtering Groups with HAVING clause
  • GROUP BY clause, distinct aggregate functions

Table Expressions

  • Using Derived Tables, Common Table Expressions
  • Using Views, Inline Table-Valued Functions

Set Operators

  • Using EXCEPT and INTERSECT, UNION ALL multi-set operators
  • CROSS APPLY and OUTER APPLY operators

Pivoting and Grouping Sets

  • Queries with PIVOT and UNPIVOT

SQL Server 2012 Metadata

  • Querying System Catalog Views and Functions
  • System Stored Procedures
  • Querying Dynamic Management Objects
  • Querying System Catalog Views
  • Querying System Functions

Executing Stored Procedures

  • Passing Parameters to Stored Procedures
  • Querying Data with Stored Procedures
  • Creating Simple Stored Procedures
  • Working with Dynamic SQL

Programming with T-SQL

  • Controlling Program Flow
  • T-SQL Programming Elements
  • TRY / CATCH Blocks, Synonyms, Error Handling

Implementing Transactions

  • Transactions and the Database Engine
  • Controlling Transactions
  • Implementing Transactions
  • Controlling transactions with BEGIN, COMMIT, and ROLLBACK
  • Adding error handling to a CATCH block

Improving Query Performance

  • Factors in Query Performance
  • Viewing Index Usage and Using SET STATISTICS Statements

Exam Administering Microsoft SQL Server 2012 Databases 70-462

SQL Server 2012 and its Toolset

  • SQL Server Platform, SQL Server Tools
  • Configuring SQL Server Services, Component Installation
  • New Instance, Named Pipes Protocol for Both Instances
  • Configure a Fixed TCP/IP Port (Only if time permits

Installing and Configuring SQL Server 2012

  • Preparing to Install SQL Server, Upgrading and Automating Installation
  • Configure Server Memory

Working with Databases

  • SQL Server Databases, Working with Files and Filegroups
  • tempdb configuration, RateTracking database

SQL Server 2012 Recovery Models

    Backup Strategies, SQL Server Transaction Logging
  • SQL Server Backup Strategy, Recovery Models, Backup strategies
  • .

Backup of SQL Server 2012 Databases

  • Backing up Databases and Transaction Logs
  • Backup compression
  • Differential backup, Copy-only backup, Partial backup

Restoring SQL Server 2012 Databases

  • Restoring Databases, Restore Process
  • Working with Point-in-time recovery
  • Restoring System Databases and Individual Files
  • Restoring SQL Server 2012 Databases
  • Determine a restore strategy
  • Restore the database, Using STANDBY mode
  • Restore system databases and individual files.

Importing and Exporting Data

  • Importing & Exporting Table Data
  • Inserting Data in Bulk
  • Import the Excel spreadsheet
  • Import the CSV file

Authenticating and Authorizing Users

  • Authenticating Connections to SQL Server
  • Authorizing Logins to Access Databases
  • Authorization Across Servers
  • Create Logins, Database Users

Server and Database Roles

  • Server Roles, User-defined Database Roles
  • Fixed Database Roles
  • Check Role Assignments

Users Access Resources

  • User Access to Objects, Execute Code
  • Configuring Permissions at the Schema Level
  • Assign Schema-level Permissions, Object-level Permissions

Auditing SQL Server Environments

  • Options for Auditing Data Access in SQL
  • Implementing SQL Server Audit
  • Managing SQL Server Audit

Automating SQL Server 2012 Management

  • Automating SQL Server Management
  • SQL Server Agent, SQL Server Agent Jobs
  • Managing SQL Server Agent Jobs

Monitoring SQL Server 2012 with Alerts and Notifications

  • Configuration of Database Mail, SQL Server Errors
  • Configuring Operators, Alerts and Notifications

Performing Ongoing Database Maintenance

  • Ensuring Database Integrity, Maintaining Indexes
  • Automating Routine Database Maintenance, DBCC CHECKDB

Tracing Access to SQL Server 2012

  • Capturing Activity using SQL Server Profiler
  • Analyze a trace using Database Engine Tuning Advisor

Implementing a Data Warehouse with Microsoft SQL Server 2012 - 463

Data Warehousing and Hardware

  • Data Warehousing, Data Sources, ETL solution
  • Considerations for Building a Data Warehouse
  • Data Warehouse Reference Architectures and Appliances
  • Hardware considerations for building a data warehouse.

Design and Implementing a Data Warehouse

  • Logical Design, Physical Design for a Data Warehouse
  • Implementing a Star Schema, Snowflake Schema, Time Dimension Table

Implementing Control Flow in an SSIS Package

  • Control Flow, Creating Dynamic Packages
  • Using Containers, Managing Consistency
  • Using Containers, Transactions, Checkpoints

Debugging and Troubleshooting SSIS Packages

  • Debugging an SSIS Package, SSIS Package Events
  • Handling Errors in an SSIS Package
  • Implementing an Event Handler

Incorporating Data from the Cloud into a Data Warehouse

  • Cloud Data Sources, SQL Server Database
  • The Windows Azure Marketplace, Creating a SQL Azure Database
  • Extracting Data from a SQL Azure Database
  • Obtaining Data from the Windows Azure Marketplace

Deduplicating Data

  • Creating a Matching Policy
  • Use Data Quality Services to match data and cleanse your data

Using Master Data Services

  • Master Data Services
  • Implementing a Master Data Services Model
  • Creating a Basic Model
  • Loading Data into a Model

Deploying and Configuring SSIS Packages

  • Using Custom Components in SSIS, Scripts in SSIS, Script Task
  • Deploying SSIS Projects,
  • Scheduling SSIS Packages with SQL Server Agent

Consuming Data in a Data Warehouse

  • Business Intelligence, Reporting, Data Analysis, Service Report
  • PowerPivot Workbook, Power View Report

Exam Developing Microsoft SQL Server 2012 Databases 70-464

Designing and Implementing Tables

  • Designing Tables, Schemas, Altering Tables

Data Integrity through Constraints

  • Enforcing Data Integrity, Implementing Domain Integrity
  • Implementing Entity and Referential Integrity

SQL Server 2012 Indexing

  • Core Indexing Concepts
  • Data Types and Indexes
  • Single Column and Composite Indexes

Table Structures in SQL Server 2012

  • SQL Server Table Structures, Clustered Indexes
  • Creating Tables as Heaps
  • Creating Tables with Clustered Indexes
  • Comparing the Performance of Clustered Indexes vs. Heaps

Designing Effective Nonclustered Indexes

  • Implementing Nonclustered Indexes, Database Engine Tuning Advisor

Implementing Views

  • Overview of Views
  • Creating and Managing Views

Implementing Stored Procedures

  • Overview of Stored Procedures
  • Working With Stored Procedures
  • Implementing Parameterized Stored Procedures
  • Creating stored procedures

Merging Data and Passing Tables

  • MERGE Statement, Implementing Table Types
  • Using TABLE Types As Parameters
  • Creating a Table Type
  • Using a Table Type Parameter

User-Defined Functions

  • Functions, Scalar Functions, Table-Valued Functions

Responding to Data Manipulation via Triggers

  • Designing and Implementing DML Triggers

Implementing Managed Code in SQL Server 2012

  • SQL CLR Integration, Importing and Configuring Assemblies
  • Implementing SQL CLR Integration
  • CLR User-defined Aggregate and CLR User-defined Data Type
  • Storing XML Data and Schemas in SQL Server
  • Introduction to XML and XML Schemas and XML Data Type

Storing XML Data in SQL Server

  • Appropriate Usage of XML Data Storage in SQL Server
  • Investigating the Storage of XML Data in Variables
  • Investigating the use of XML Schema Collections
  • Investigating the Creation of Database Columns Based on XML

Querying XML Data in SQL Server

  • T-SQL FOR XML Statement
  • Shredding XML
  • Stored procedure returning XML

SQL Server 2012 Spatial Data

  • SQL Server Spatial Data Types
  • Using Spatial Data in Applications
  • Familiarity With Geometry Data Type
  • Adding Spatial Data to an Existing Table

Working with Full-Text Indexes and Queries

  • Introduction to Full-Text Indexing
  • Implementing Full-Text Indexes in SQL Server
  • Working with Full-Text Queries
  • Implementing a full-text index
  • Implementing a stoplist
  • Creating a stored procedure to implement a full-text search

Exam Designing Database Solutions for SQL Server 2012 70-465

Designing a Database Server Infrastructure

  • Database Server Infrastructure, Database Server Infrastructure
  • Analyzing Capacity Requirements

Designing a Logical Database Schema

  • Relational Database Design Techniques, Schemas
  • Denormalized View of a Database

Designing a Physical Database Implementation

  • Files and Filegroups, Partitioning Data, Compressing Data

Designing a Database Solution for BLOB Data

  • Considerations for BLOB Data, Working with FileStream
  • Using Full-text Search

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
  • Auditing Database Activity

Policy-Based Management

  • Planning Policy-Based Management
  • Implementing Policy-Based Management
  • Applying a Policy

Monitoring Server Health

  • Introduction to Health Monitoring
  • SQL Server Utility

Managing SQL Server with PowerShell

  • Using PowerShell interactively
  • Backing up a Database by Using PowerShell

Replicating Data

  • SQL Server Replication
  • Planning a Replication Strategy
  • Implementing Replication

What Our Customers says

MCSE: SQL Server 2012 Data Platform Package Offer: Great Savings!!!

Giveaway Price
£2000 +VAT
Silver Package
  • Package Includes
  • MCSA: SQL 2016 Database Administration £1200
  • MCSA: SQL 2016 Database Development £1200
  • Total Price £2400
  • Offer Price £2000
  • Savings £400
Giveaway Price
£4000 +VAT
Diamond Package
  • Package Includes
  • MCSA: SQL 2016 Database Administration £1200
  • MCSA: SQL 2016 Database Development £1200
  • MCSA SQL 2016 BI Development £1200
  • MCSA MS SQL 2012 Data Platform £1200
  • Total Price £4800
  • Offer Price £4000
  • Savings £800
Giveaway Price
£3000 +VAT
Gold Package
  • Package Includes
  • MCSA: SQL 2016 Database Administration £1200
  • MCSA: SQL 2016 Database Development £1200
  • MCSA SQL 2016 BI Development £1200
  • Total Price £3600
  • Offer Price £3000
  • Savings £600

Time Table and Pricing

This is an On-Demand course. Please call us on 0207 256 7722 to arrange the training as per your requirement.

Training Facilities

Training And Certification

Why Choose London Training ?

  • Authorized Training Center
  • Hands-on Training
  • Tutor Led Classroom
  • Small Class Size 5-7 max
  • Central London Locations
  • Expert and Certified Trainers
  • Price includes Tuition Fee, Classroom Training and Course Material
  • Expert and Certified Trainers
  • Classes on Week Days, Evening or Weekends
  • Free Re-training
  • Modern Training Facilities
  • Inclusive Books / Materials
  • Mock Exams / Projects