Course not currently available

MCSE: SQL Server 2012 Data Platform

London Training Group LTD
4.7
9 reviews
  • I have done SQL development from the London training group and I have enjoyed both courses from here. The office staff is nice and so helpful.
    ← | →
  • My CCNA course went amazing and my trainer was extremely great.
    ← | →
  • The training was so informative and my trainer Mr. Saif made it easier to understand as well. Everything was explained so nicely.
    ← | →

Course

In City of London ()

£ 2,400 + VAT

The best SQL Server courses

See all

See all

Description

  • Type

    Course

  • Level

    Intermediate

  • Duration

    6 Weeks

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.

About this course

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.

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.

Basic computer knowledge

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

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

Our experts will contact you to speak about the MCSE: SQL Server 2012 Data Platform training in London.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.7
excellent
  • I have done SQL development from the London training group and I have enjoyed both courses from here. The office staff is nice and so helpful.
    ← | →
  • My CCNA course went amazing and my trainer was extremely great.
    ← | →
  • The training was so informative and my trainer Mr. Saif made it easier to understand as well. Everything was explained so nicely.
    ← | →
100%
4.7
excellent

Course rating

Recommended

Centre rating

Abdirahman Ahmed

4.5
01/12/2019
About the course: I have done SQL development from the London training group and I have enjoyed both courses from here. The office staff is nice and so helpful.
Would you recommend this course?: Yes

Mohamed Siyad Mohamed

5.0
01/12/2019
About the course: My CCNA course went amazing and my trainer was extremely great.
Would you recommend this course?: Yes

Khulud AL Mutairi

4.5
30/11/2019
About the course: The training was so informative and my trainer Mr. Saif made it easier to understand as well. Everything was explained so nicely.
Would you recommend this course?: Yes

Tom

5.0
30/11/2019
About the course: The trainer made the classes so amazing and knowledgeable. They clear all the topics related to doubts easily.
Would you recommend this course?: Yes

Camilla McConnell

5.0
30/11/2019
About the course: It was amazing and I have truly like London training. I have completed my web design course and it was so informative. The instructor was so helpful and supportive.
Would you recommend this course?: Yes

Musharaf Hussain

4.5
30/11/2019
About the course: The trainer was amazing and so patient. He explained everything so well.
Would you recommend this course?: Yes

PETER AGBON

5.0
27/11/2019
About the course: The environment was amazing and the trainers were highly knowledgeable. I like the kind of atmosphere they offer.
Would you recommend this course?: Yes

Diana

4.5
27/11/2019
About the course: I have thoroughly enjoyed my SQL development training. It went so nice and made my sessions informative and interesting.
Would you recommend this course?: Yes

Tafseer

4.5
23/05/2017
What I would highlight: Saif is an excellent tutor, very thorough with explaining topics and providing examples.
What could be improved: .
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2019

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 11 years

Subjects

  • Monitoring
  • Access
  • Transactions
  • Auditing
  • XML training
  • Server
  • Database
  • SQL
  • Database training
  • MCSE training
  • MCSE
  • Technology
  • Design
  • IT Auditing
  • Microsoft Database Engineer
  • Microsoft SQL DBA
  • Microsoft Database Administrator
  • Microsoft Database Consultant
  • Freelancer Microsoft SQL DBA
  • Microsoft Database Designer

Course programme

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

Additional information

0% interest available .Pay Monthly.Interest Free Installments Upto 1 Year.

Duration
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)

See related categories

MCSE: SQL Server 2012 Data Platform

£ 2,400 + VAT

The best SQL Server courses

See all

See all