Subscribe for access to this FREE e-learning mini-course!


Your First Name:


Your Surname:


Your Email Address:



Subscribe
Close


Small logo
Hamburger sub menu
More
Hamburger menu
Menu
bookings:   0333 6000 111
service:       0333 6000 555
    or           
Results-Based SQL Server Training
Results-Based SQL Server Training
Search

SQL SERVER 2012 CERTIFICATION

Microsoft SQL Server 2012 Certified Training

Training for Microsoft SQL Server delivered in 11 UK locations or at your offices UK-wide
See Our Latest Reviews on TrustPilot:
Versions Covered
Our courses cover 2014 versions
Your First Choice for SQL Server Training
Classroom training Classroom training

Classroom training is proven to give the best learning experience and knowledge retention. You have the benefit of a relaxed but professional learning environment, an experienced trainer and the opportunity to ask questions, so you are 100% sure you understand all the course content.

Click for details of:
    Course outlines and links
    More about classroom training

Move to next SQL Server section
Quick Links to Information

REQUEST MORE INFORMATION

PRICES for training

BOOK a public class date

Microsoft Certification page

More on This Page
COURSE OUTLINES & LINKS FOR
SQL SERVER TRAINING
Browse the outlines and click for more details on each course

10977: Upgrading SQL Skills to SQL Server 2014

10977: Upgrading SQL Skills to SQL Server 2014

COURSE OUTLINE
[Duration: five day]

  • Introduction to SQL Server 2014
  • Lab : Exploring SQL Server 2014
  • What's New in SQL Server Database Development
  • Lab : Developing SQL Server 2014 Databases
  • In-Memory Database Capabilities
  • Lab : Using In-Memory Database Capabilities
  • Scripting SQL Server 2014
  • Lab : Managing SQL Server with Scripts
  • Lab : Implementing Security
  • High Availability and Data Recovery Enhancements
  • Lab : Using AlwaysOn Availability Groups
  • New and Enhanced Features in SQL Server Integration Services
  • Lab : Using SQL Server Integration Services
  • Data Quality Services
  • Lab : Cleansing Data
  • Lab : Deduplicating Data
  • Master Data Services
  • Lab : Implementing Master Data Services
  • SQL Server 2014 Reporting Services
  • Lab : Using SQL Server 2014 Reporting Services
  • Implementing an Analysis Services Tabular Data Model
  • Lab : Working with an Analysis Services Tabular Data Model
  • Self-Service BI with Microsoft Excel
  • Lab : Self-Service BI with Excel
  • Introduction to Cloud Data Solutions
  • Lab : Using Windows Azure
  • Windows Azure SQL Database
  • Lab : Using Windows Azure SQL Database
  • SQL Server in Windows Azure Virtual Machines
  • Lab : Using Windows Azure Virtual Machines
  • Implementing Big Data Solutions
  • Lab : Creating a Big Data Solution

Click for FULL COURSE DETAILS

20461: Querying Microsoft SQL Server 2014

20461: Querying Microsoft SQL Server 2014

COURSE OUTLINE
[Duration: five day]

  • Introduction to Microsoft SQL Server 2014
  • Lab : Working with SQL Server 2014 Tools
  • Introduction to T-SQL Querying
  • Lab : Introduction to Transact-SQL Querying
  • Writing SELECT Queries
  • Lab : Writing Basic SELECT Statements
  • Querying Multiple Tables
  • Lab : Querying Multiple Tables
  • Sorting and Filtering Data
  • Lab : Sorting and Filtering Data
  • Working with SQL Server 2014 Data Types
  • Lab : Working with SQL Server 2014 Data Types
  • Using DML to Modify Data
  • Lab : Using DML to Modify Data
  • Using Built-In Functions
  • Lab : Using Built-In Functions
  • Grouping and Aggregating Data
  • Lab : Grouping and Aggregating Data
  • Using Subqueries
  • Lab : Using Subqueries
  • Using Table Expressions
  • Lab : Using Table Expressions
  • Using Set Operators
  • Lab : Using Set Operators
  • Using Window Ranking, Offset, and Aggregate Functions
  • Lab : Using Window Ranking, Offset and Aggregate Functions
  • Pivoting and Grouping Sets
  • Lab : Pivoting and Grouping Sets
  • Executing Stored Procedures
  • Lab : Executing Stored Procedures
  • Programming with T-SQL
  • Lab : Programming with T-SQL
  • Implementing Error Handling
  • Lab : Implementing Error Handling
  • Implementing Transactions
  • Lab : Implementing Transactions

Click for FULL COURSE DETAILS

20462: Administering MS SQL Server Databases

20462: Administering MS SQL Server Databases

COURSE OUTLINE
[Duration: five day]

  • Installing SQL Server 2014
  • Lab : Installing SQL Server 2014
  • Working with Databases
  • Lab : Creating and Configuring Databases
  • SQL Server 2014 Recovery Models
  • Lab : Understanding SQL Server Recovery Models
  • Backup of SQL Server 2014 Databases
  • Lab : Backing Up SQL Server Databases
  • Restoring SQL Server 2014 Databases
  • Lab : Restoring SQL Server Databases
  • Importing and Exporting Data
  • Lab : Importing and Exporting Data
  • Authenticating and Authorizing Users
  • Lab : Authenticating Users
  • Assigning Server and Database Roles
  • Lab : Assigning Server and Database Roles
  • Authorizing Users to Access Resources
  • Lab : Authorizing Users to Access Resources
  • Protecting Data by Using Encryption and Auditing
  • Lab : Using Auditing and Encryption
  • Automating SQL Server 2014 Management
  • Lab : Automating SQL Server Management
  • Configuring Security for SQL Server Agent
  • Lab : Configuring Security for SQL Server Agent
  • Monitoring SQL Server 2014 by Using Alerts and Notifications
  • Lab : Monitoring SQL Server by Using Alerts and Notifications
  • Performing Ongoing Database Maintenance
  • Lab : Performing Ongoing Database Maintenance
  • Tracing Access to SQL Server 2014
  • Lab : Tracing Access to SQL Server
  • Monitoring SQL Server 2014
  • Lab : Monitoring SQL Server

Click for FULL COURSE DETAILS

20463: Implement a Data Warehouse with SQL Server

20463: Implement a Data Warehouse with SQL Server

COURSE OUTLINE
[Duration: five day]

  • Introduction to Data Warehousing
  • Lab : Exploring a Data Warehousing Solution
  • Planning Data Warehouse Infrastructure
  • Lab : Planning Data Warehouse Infrastructure
  • Designing and Implementing a Data Warehouse
  • Lab : Implementing a Data Warehouse
  • Creating an ETL Solution with SSIS
  • Lab : Implementing Data Flow in an SSIS Package
  • Implementing Control Flow in an SSIS Package
  • Lab : Implementing Control Flow in an SSIS Package
  • Lab : Using Transactions and Checkpoints
  • Debugging and Troubleshooting SSIS Packages
  • Lab : Debugging and Troubleshooting an SSIS Package
  • Implementing a Data Extraction Solution
  • Lab : Extracting Modified Data
  • Loading Data into a Data Warehouse
  • Lab : Loading a Data Warehouse
  • Enforcing Data Quality
  • Lab : Cleansing Data
  • Master Data Services
  • Lab : Implementing Master Data Services
  • Extending SQL Server Integration Services
  • Lab : Using Custom Scripts
  • Deploying and Configuring SSIS Packages
  • Lab : Deploying and Configuring SSIS Packages
  • Consuming Data in a Data Warehouse
  • Lab : Using a Data Warehouse

Click for FULL COURSE DETAILS

20464: Developing MS SQL Server 2014 Databases

20464: Developing MS SQL Server 2014 Databases

COURSE OUTLINE
[Duration: five day]

  • Introduction to Database Development
  • Lab : Introduction to Database Development
  • Designing and Implementing Tables
  • Lab : Designing and Implementing Tables
  • Ensuring Data Integrity through Constraints
  • Lab : Ensuring Data Integrity through Constraints
  • Introduction to Indexing
  • Lab : Creating Indexes
  • Advanced Indexing
  • Lab : Planning for SQL Server 2014 Indexing
  • Columnstore Indexes
  • Lab : Using In-Memory Database Capabilities
  • Designing and Implementing Views
  • Lab : Designing and Implementing Views
  • Designing and Implementing Stored Procedures
  • Lab : Designing and Implementing Stored Procedures
  • Designing and Implementing User-Defined Functions
  • Lab : Designing and Implementing User-Defined Functions
  • Responding to Data Manipulation via Triggers
  • Lab : Responding to Data Manipulation via Triggers
  • Using In-Memory Tables
  • Lab : Using In-Memory Database Capabilities
  • Implementing Managed Code in SQL Server
  • Lab : Implementing Managed Code in SQL Server
  • Storing and Querying XML Data in SQL Server
  • Lab : Storing and Querying XML Data in SQL Server
  • Working with SQL Server Spatial Data
  • Lab : Working with SQL Server Spatial Data

Click for FULL COURSE DETAILS

20465: Designing a Data Solution - SQL Server 2014

20465: Designing a Data Solution - SQL Server 2014

COURSE OUTLINE
[Duration: five day]

  • Introduction to Enterprise Data Architecture
  • Lab : Assessing an Existing Enterprise Data Infrastructure
  • Multi-Server Configuration Management
  • Lab : Planning and Implementing Policy-Based Management
  • Consolidating Database Workloads with SQL Server 2014
  • Lab : SQL Server Consolidation
  • Introduction to Cloud Data Solutions
  • Lab : Preparing a SQL Server Installation in a Virtual Machine Template
  • Introduction to Windows Azure
  • Lab : Using Windows Azure
  • Windows Azure SQL Database
  • Lab : Using Windows Azure SQL Database
  • SQL Server in Windows Azure Virtual Machines
  • Lab : Using Windows Azure Virtual Machines
  • Introduction to High Availability in SQL Server 2014
  • Lab : Using Log Shipping
  • Clustering with Windows Server and SQL Server 2014
  • Lab : Implementing an AlwaysOn Failover Cluster Instance
  • AlwaysOn Availability Groups
  • Lab : Implementing and Testing an AlwaysOn Availability Group
  • Planning High Availability and Disaster Recovery
  • Lab : Planning High Availability and Disaster Recovery
  • Replicating Data
  • Lab : Planning and Implementing Replication

Click for FULL COURSE DETAILS

20466: Implement Data Models with SQL Server 2014

20466: Implement Data Models with SQL Server 2014

COURSE OUTLINE
[Duration: five day]

  • Introduction to Business Intelligence and Data Modeling
  • Lab : Exploring a BI Solution
  • Creating Multidimensional Databases
  • Lab : Creating a Multidimensional Database
  • Working with Cubes and Dimensions
  • Lab : Defining Dimensions
  • Working with Measures and Measure Groups
  • Lab : Configuring Measures and Measure Groups
  • Introduction to MDX
  • Lab : Using MDX
  • Enhancing a Cube
  • Lab : Customizing a Cube
  • Implementing an Analysis Services Tabular Data Model
  • Lab : Implementing an Analysis Services Tabular Data Model
  • Introduction to DAX
  • Lab : Using DAX to Enhance a Tabular Data Model
  • Implementing Reports with SQL Server Reporting Services
  • Lab : Creating a Report with Report Designer
  • Enhancing Reports with SQL Server Reporting Services
  • Lab : Enhancing a Report
  • Managing Report Execution and Delivery
  • Lab : Configuring Report Execution and Delivery
  • Delivering BI with SharePoint PerformancePoint Services
  • Lab : Implementing a SharePoint Server BI Solution
  • Performing Predictive Analysis with Data Mining
  • Lab : Using Data Mining to Support a Marketing Campaign

Click for FULL COURSE DETAILS

20467: Business Intelligence (BI): SQL Server 2014

20467: Business Intelligence (BI): SQL Server 2014

COURSE OUTLINE
[Duration: four day]

  • Introduction to Self-Service Business Intelligence
  • Lab : Exploring an Enterprise BI Solution
  • Self-Service Reporting
  • Lab : Implementing Self-Service Reporting
  • Self-Service Data Modeling with PowerPivot
  • Lab : Self-Service Data Modeling with PowerPivot
  • Importing Data with Power Query
  • Lab : Using Power Query
  • Visualizing Data with Power View in Microsoft Excel
  • Lab : Visualizing Data with Power View
  • Visualizing Geographic Data with Power Map
  • Lab : Visualizing Geographic Data with Power Map
  • Collaborative BI with Microsoft SharePoint Server
  • Lab : Using SharePoint Server for BI Collaboration
  • The Windows Azure Marketplace Data Market
  • Lab : Using the Windows Azure Marketplace
  • Cloud Collaboration with Power BI for Microsoft Office 365
  • Lab : Using Power BI
  • Introduction to Big Data and Windows Azure HDInsight
  • Lab : Using Windows Azure HDInsight
  • Processing Big Data with Pig and Hive
  • Lab : Processing Big Data with Pig and Hive
  • Implementing Big Data Processing Solutions with Windows Azure HDInsight
  • Lab : Creating a Big Data Solution

Click for FULL COURSE DETAILS
Move to next SQL Server section
CLASSROOM TRAINING FOR
SQL SERVER
Do you want the best? Here's how to get it!
Classroom training for SQL SERVER
Classroom training provides the best learning experience and knowledge retention, and is the preferred choice if you want to really get to grips with the subject.
Our class sizes are always small, allowing lots of time for questions and discussion, so you come away with a full grasp of the content, ready to use it right away.
Options for Classroom Training
Scheduled Public Classes

Best for: 1 - 4 delegates

With 11 centres across the UK, we always have a full schedule of great courses at super prices.
And we don't cancel classes – even if you are the only delegate booked on the course!

Price Guide
  • Prices for public classes start at £1899
  • For multiple delegates, prices can be as low as £1749

Book Online
It couldn't be easier with our full listings of classes and dates: just click here and reserve your place in two minutes.

Private Training at Our Centres

Best for: 3 or more delegates

If you want training away from your offices (and possible distractions), we can arrange a day at one of our centres with only your staff in attendance.

Call us on 0333 6000 111 or request a callback so we can discuss your needs.

Move to next SQL Server section
YOU MAY ALSO LIKE ...
SUPPLEMENTARY INFORMATION
More content that may be of interest to you
SQL Server Certification Tracks
How to get the right certification in Windows Server: read more

SQL Server: Latest Courses
Make sure you attend the latest course: read more

Move to next SQL Server section

GENERAL INFORMATION
ABOUT SQL SERVER TRAINING

What we do, and how we work, to make sure you get the most from the courses you attend

If you are designing, building and maintaining the next wave of cloud-ready database and information solutions in your organisation, writing Transact SQL queries and analysing business intelligence, then certification in Microsoft SQL Server provides a level of confidence which benefits both employees and employers.

SQL SERVER: SPECIAL MCSA PRICING

We have obtained special pricing for a limited time only:
Book all three courses for your MCSA certification for £4,999

A further discount is available at some centres in London, Manchester, Leeds and Wokingham which reduces the price to just £3,999

NOTE: this pricing is available for a limited period only, so please don't delay because we hate to disappoint!

We deliver official Microsoft SQL Server courses that map directly to the examinations required for certification, making the progress through your chosen career track both simple and effective.



GET IN TOUCH

Call us on:
0333 6000 111

   You can Email us direct (You'll usually get a response within 2-3 working hours)
   Or fill out the details below and we'll be in touch very soon:
SEND MESSAGE

MICROSOFT SQL SERVER 2012 CERTIFIED TRAINING

We can enhance your skills with certified training in Microsoft SQL Server 2012 at any of our twelve training centres UK wide, or we can come to your offices: if you have groups of three or more staff who need training, this is a very convenient, flexible and cost effective option. Moreover, most of our sql server 2012 certification courses are 1 day, which keeps "out of office" periods for attendees to a minimum.

We have been delivering Microsoft sql server 2012 certified training all over the UK since 1995 and have continually developed our philosophy of high quality, flexible and results-driven provision of certification for SQL Server 2012 to ensure constantly improving standards of quality.   So you can be confident that we have the expertise, and the experience, to give you a great return on your investment in Certification for SQL Server 2012 from Activia.

Why not contact us today to see how we can help with providing your classes in Microsoft SQL Server 2012 ?


Stay in touch

Stay In Touch!

Google+
LinkedIn
Twitter
FaceBook
YouTube

Contact Details

Activia Training

Locations Address: Head Office, Regus House,
268 Bath Road
Slough, Berkshire SL1 4DX

Phone Sales:           0333 6000 111

Service:       0333 6000 555

Accounts:   0333 6000 777



Back to top
Quick Links to Information
More on This Page
We do not schedule classes for SQL Server, please contact us to discuss delivering training at your offices.

OK