SQL Training Overview:


  • Microsoft Certified Solutions Associate(MCSA) SQL Certification


  • SQL classroom training. Instructor led hands-on classes.

SQL Certification Exams:

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

MCSA: Data Platform 2012 courses

SQL Course Length:

  • 4 Weeks or Fast Track 4 Days

SQL Training Includes:

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

SQL Training Locations:

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

Flexible Starting Dates:

  • SQL Training 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 SQ

MCSA: SQL Server 2012 Data Platform

MCSA 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

MCSA 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

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 Associate(MCSA) SQL Certification
  • SQL classroom training. Instructor led hands-on classes.
  • 3 Exams, Real Time Simulation, Single and Multiple Choice Questions
  • 4 Weeks or Fast Track 4 Days
  • Lab Exercises, Project work, Unlimited Lab Access, Free Re-training
  • SQL Training on Weekdays, Weekends and Evenings
Brochure Request