MCSA: SQL Server 2012/2014

Synopsis

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

Request Brochure


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 (MCSA): 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 MCSA: 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, DatMicrosoftabase 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 SQL training in London. Call us: 0207 256 7722

Course Fee: £1200 + 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


MCSA: SQL Server 2012/2014

  • 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

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

What Our Customers says

MCSA: SQL Server 2012/2014 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

September

17 Sep 2018

Price £1200 + VAT
Start Date
MCSA: SQL Server 2012/2014 17 Sep 2018
Liverpool Street Wilson Street , Central London , EC2M 2SJ
End Date 21 Sep 2018
Time 10:00-17:00
Mode Fast Track
Days M,T,W,T,F

22 Sep 2018

Price £1200 + VAT
Start Date
MCSA: SQL Server 2012/2014 22 Sep 2018
Liverpool Street Wilson Street , Central London , EC2M 2SJ
End Date 03 Nov 2018
Time 10:00-14:00
Mode Weekend
Days Saturday

24 Sep 2018

Price £1200 + VAT
Start Date
MCSA: SQL Server 2012/2014 24 Sep 2018
Liverpool Street Wilson Street , Central London , EC2M 2SJ
End Date 24 Oct 2018
Time 18:30 - 21:30
Mode Evening
Days Mon,Wed

October

22 Oct 2018

Price £1200 + VAT
Start Date
MCSA: SQL Server 2012/2014 22 Oct 2018
Liverpool Street Wilson Street , Central London , EC2M 2SJ
End Date 26 Oct 2018
Time 10:00-17:00
Mode Fast Track
Days M,T,W,T,F

29 Oct 2018

Price £1200 + VAT
Start Date
MCSA: SQL Server 2012/2014 29 Oct 2018
Liverpool Street Wilson Street , Central London , EC2M 2SJ
End Date 28 Nov 2018
Time 18:30 - 21:30
Mode Evening
Days Mon,Wed

November

10 Nov 2018

Price £1200 + VAT
Start Date
MCSA: SQL Server 2012/2014 10 Nov 2018
Liverpool Street Wilson Street , Central London , EC2M 2SJ
End Date 22 Dec 2018
Time 10:00-14:00
Mode Weekend
Days Saturday

26 Nov 2018

Price £1200 + VAT
Start Date
MCSA: SQL Server 2012/2014 26 Nov 2018
Liverpool Street Wilson Street , Central London , EC2M 2SJ
End Date 30 Nov 2018
Time 10:00-17:00
Mode Fast Track
Days M,T,W,T,F

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