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


Your First Name:


Your Surname:


Your Email Address:



Subscribe
Close


Hamburger menu
Menu
bookings:   0333 6000 111
service:       0333 6000 555
    or           
Results-Based SQL Server Training
Results-Based SQL Server Training
 

CERTIFICATION FOR SQL SERVER 2012

Your place for classes in Microsoft SQL Server 2012

Training for Microsoft SQL Server, delivered UK-wide in 11 Activia training centres or at your offices
See Our Latest Reviews on TrustPilot:

Versions of SQL Server Covered

Our courses cover the 2014 versions of SQL Server.
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.

And with our long history of training since 1995, along with our experienced trainers, you are sure to get the service and skills enhancement you need.

Want to see prices and options for delivery of your training?

PRICES FOR YOUR
SQL SERVER TRAINING

Move to next SQL Server section

COURSE OUTLINES & LINKS

Browse the outlines and click for more details on each course

2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

Logo for Microsoft SQL Server 2012 Certified Training : 2778: SQL Server 2008: Writing Queries
COURSE OUTLINE     [Duration: four days]

  • Module 1: Getting Started with Databases and Transact-SQL in SQL Server 2008
  • Lab : Using SQL Server Management Studio and SQLCMD
  • Module 2: Querying and Filtering Data
  • Lab : Querying and Filtering Data
  • Module 3: Grouping and Summarizing Data
  • Lab : Grouping and Summarizing Data
  • Module 4: Joining Data from Multiple Tables
  • Lab : Joining Data from Multiple Tables
  • Module 5: Working with Subqueries
  • Lab : Working with Subqueries
  • Module 6: Modifying Data in Tables
  • Lab : Modifying Data in Tables
  • Module 7: Querying Metadata, XML, and Full-Text Indexes
  • Lab : Querying Metadata, XML, and Full-Text Indexes
  • Module 8: Using Programming Objects for Data Retrieval
  • Lab : Using Programming Objects for Data Retrieval
  • Module 9: Using Advanced Querying Techniques
  • Lab : Using Advanced Querying Techniques

Click for FULL COURSE DETAILS

2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

Logo for Microsoft SQL Server 2012 Certified Training : 2778: SQL Server 2008: Writing Queries
COURSE OUTLINE     [Duration: three days]

    Click for FULL COURSE DETAILS

    2779: Implementing a Microsoft SQL Server 2005 Database

    Logo for Microsoft SQL Server 2012 Certified Training : 2779: SQL Server 2005: Implementing a Database
    COURSE OUTLINE     [Duration: five days]

    • Module 1: Identify and Resolve New Software Installation Issues
    • Lab : Identify and Resolve New Software Installation Issues
    • Module 2: Resolve Software Configuration Issues
    • Lab : Resolve Software Configuration Issues
    • Module 3: Resolve Software Failure
    • Lab : Resolve Software Failure
    • Module 4: Identify and Resolve Logon Issues
    • Lab : Identify and Resolve Logon Issues
    • Module 5: Identify and Resolve Network Connectivity Issues
    • Lab : Identify and Resolve Network Connectivity Issues
    • Module 6: Identify and Resolve Name Resolution Issues
    • Lab : Identify and Resolve Name Resolution Issues
    • Module 7: Identify and Resolve Network Printer Issues
    • Lab : Identify and Resolve Network Printer Issues
    • Module 8: Identify and Resolve Performance Issues
    • Lab : Identify and Resolve Performance Issues
    • Module 9: Identify and Resolve Hardware Failure Issues
    • Lab : Identify and Resolve Hardware Failure Issues
    • Module 10: Identify and Resolve Wireless Connectivity Issues
    • Lab : Identify and Resolve Wireless Connectivity Issues
    • Module 11: Identify and Resolve Remote Access Issues
    • Lab : Identify and Resolve Remote Access Issues
    • Module 12: Manage File Synchronization
    • Lab : Manage File Synchronization
    • Module 13: Identify and Resolve Internet Explorer Security Issues
    • Lab : Identify and Resolve Internet Explorer Security Issues
    • Module 14: Identify and Resolve Firewall Issues
    • Lab : Identify and Resolve Firewall Issues
    • Module 15: Identify and Resolve Issues Due To Malicious Software
    • Lab : Identify and Resolve Issues Due To Malicious Software
    • Module 16: Identify and Resolve Encryption Issues
    • Lab : Identify and Resolve Encryption Issues
    • Module 17: Identify and Resolve Software Update Issues
    • Lab : Identify and Resolve Software Update Issues

    Click for FULL COURSE DETAILS

    2786: Designing a Microsoft SQL Server 2005 Infrastructure

    Logo for Microsoft SQL Server 2012 Certified Training : 2786: SQL Server 2005: Infrastructure Design
    COURSE OUTLINE     [Duration: two days]

    • Module 1: Analyzing Capacity Needs
    • Lab : Analyzing Capacity Needs
    • Module 2: Designing a Strategy for Data Archiving
    • Lab : Designing a Strategy for Data Archiving
    • Module 3: Designing a Strategy for Database Server Consolidation
    • Lab : Designing a Database Server Consolidation Strategy
    • Module 4: Designing a Strategy for Data Distribution
    • Lab : Designing a Data Distribution Strategy Using Replication
    • Module 5: Designing a Database Server Infrastructure
    • Lab : Designing a Database Server Infrastructure
    • Module 6: Designing a Strategy for Data Recovery
    • Lab : Designing a Data Recovery Solution
    • Module 7: Establishing Database Conventions and Standards
    • Lab : Establishing Database Conventions and Standards

    Click for FULL COURSE DETAILS

    2787: Designing Security for Microsoft SQL Server 2005

    Logo for Microsoft SQL Server 2012 Certified Training : 2787: SQL Server 2005: Security
    COURSE OUTLINE     [Duration: two days]

    • Module 1: Introduction to Designing SQL Server Security
    • Module 2: Designing a SQL Server Systems Infrastructure Security Policy
    • Lab : Designing a SQL Server Systems Infrastructure Security Policy
    • Lab : Creating an Infrastructure Security Inventory
    • Module 3: Designing Security Policies for Instances and Databases
    • Lab : Designing Security Policies for Instances and Databases
    • Lab : Validating Security Policies for Instances and Databases
    • Module 4: Integrating Data Encryption into a Database Security Design
    • Lab : Integrating Data Encryption into a Database Security Design
    • Module 5: Designing a Security Exceptions Policy
    • Lab : Designing a Security Exceptions Policy
    • Module 6: Designing a Response Strategy for Threats and Attacks
    • Lab : Designing a Response Strategy for Threats and Attacks

    Click for FULL COURSE DETAILS

    2788: Designing High Availability Database Solutions Using Microsoft SQL Server 2005

    Logo for Microsoft SQL Server 2012 Certified Training : 2788: SQL Server 2005: Database Design
    COURSE OUTLINE     [Duration: three days]

    • Module 1: Selecting the Appropriate High-availability Solution
    • Lab : Proposing a High-availability Solution
    • Module 2: Designing a Clustering Solution
    • Lab : Designing a Database Clustering Solution
    • Module 3: Designing a Highly Available Database Storage Solution
    • Lab : Designing a Highly Available Database Storage Solution
    • Module 4: Designing a Log Shipping Solution
    • Lab : Designing a Log Shipping Solution
    • Module 5: Designing a Database Mirroring Solution
    • Lab : Designing a Database Mirroring Solution
    • Module 6: Designing a Highly Available Solution Based on Replication
    • Lab : Designing a Highly-availability Solution Based on Replication
    • Module 7: Combining High-availability Technologies
    • Lab : Combining High-availability Technologies
    • Module 8: Documenting and Testing a High-availability Strategy
    • Lab : Documenting and Testing a High-availability Strategy

    Click for FULL COURSE DETAILS

    2789: Administering and Automating Microsoft SQL Server 2005 Databases and Servers

    Logo for Microsoft SQL Server 2012 Certified Training : 2789: SQL Server 2005: Databases and Servers
    COURSE OUTLINE     [Duration: one day]

    • Module 1: Managing and Automating Databases and Servers
    • Lab : Managing and Automating Databases and Servers
    • Module 2: Managing SQL Server Supporting Services
    • Lab : Managing SQL Server Supporting Services

    Click for FULL COURSE DETAILS

    2790: Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005

    Logo for Microsoft SQL Server 2012 Certified Training : 2790: SQL Server 2005: Database Servers
    COURSE OUTLINE     [Duration: two days]

    • Module 1: Unit 1: Building a Monitoring Solution for SQL Server Performance Issues
    • Lab : Building a Monitoring Solution for SQL Server Performance Issues
    • Module 2: Unit 2: Troubleshooting Database and Database Server Performance Issues
    • Lab : Troubleshooting Database and Database Server Performance Issues
    • Module 3: Unit 3: Optimizing the Query Performance Environment
    • Lab : Optimizing the Query Performance Environment
    • Module 4: Unit 4: Troubleshooting SQL Server Connectivity Issues
    • Lab : Troubleshooting SQL Server Connectivity Issues
    • Module 5: Unit 5: Troubleshooting SQL Server Data Issues
    • Lab : Troubleshooting SQL Server Data Issues
    • Module 6: Unit 6: Troubleshooting SQL Server Data Concurrency Issues
    • Lab : Troubleshooting SQL Server Data Concurrency Issues

    Click for FULL COURSE DETAILS

    6231: Maintaining a Microsoft SQL Server 2008 R2 Database

    Logo for Microsoft SQL Server 2012 Certified Training : 6231: Maintaining SQL Server 2008 R2
    COURSE OUTLINE     [Duration: five days]

    • Introduction to SQL Server 2008 R2 and its Toolset
    • Lab : Introduction to SQL Server 2008 R2 and its Toolset
    • Preparing Systems for SQL Server 2008 R2
    • Lab : Preparing Systems for SQL Server 2008 R2
    • Installing and Configuring SQL Server 2008 R2
    • Lab : Installing and Configuring SQL Server 2008 R2
    • Working with Databases
    • Lab : Working with Databases
    • Understanding SQL Server 2008 R2 Recovery Models
    • Lab : Understanding SQL Server 2008 R2 Recovery Models
    • Backup of SQL Server 2008 R2 Databases
    • Lab : Backup of SQL Server 2008 R2 Databases
    • Restoring SQL Server 2008 R2 Databases
    • Lab : Restoring SQL Server 2008 R2 Databases
    • Importing and Exporting Data
    • Lab : Importing and Exporting Data
    • Authenticating and Authorizing Users
    • Lab : Authenticating and Authorizing Users
    • Assigning Server and Database Roles
    • Lab : Assigning Server and Database Roles
    • Authorizing Users to Access Resources
    • Lab : Authorizing Users to Access Resources
    • Auditing SQL Server Environments
    • Lab : Auditing SQL Server Environments
    • Automating SQL Server 2008 R2 Management
    • Lab : Automating SQL Server 2008 R2 Management
    • Configuring Security for SQL Server Agent
    • Lab : Configuring Security for SQL Server Agent
    • Monitoring SQL Server 2008 R2 with Alerts and Notifications
    • Lab : Monitoring SQL Agent Jobs with Alerts and Notifications
    • Performing Ongoing Database Maintenance
    • Lab : Ongoing Database Maintenance
    • Tracing Access to SQL Server 2008 R2
    • Lab : Tracing Access to SQL Server 2008 R2
    • Monitoring SQL Server 2008 R2
    • Lab : Monitoring SQL Server 2008 R2
    • Managing Multiple Servers
    • Lab : Managing Multiple Servers
    • Troubleshooting Common SQL Server 2008 R2 Administrative Issues
    • Lab : Troubleshooting Common Issues

    Click for FULL COURSE DETAILS

    6232: Implementing a Microsoft SQL Server 2008 R2 Database

    Logo for Microsoft SQL Server 2012 Certified Training : 6232: Implementing SQL Server 2008 R2
    COURSE OUTLINE     [Duration: five days]

    • Introduction to SQL Server and its Toolset
    • Lab : Introduction to SQL Server and its Toolset
    • Working with Data Types
    • Lab : Working with Data Types
    • Designing and Implementing Tables
    • Lab : Designing and Implementing Tables
    • Designing and Implementing Views
    • Lab : Designing and Implementing Views
    • Planning for SQL Server Indexing
    • Lab : Planning for SQL Server Indexing
    • Implementing Table Structures in SQL Server
    • Lab : Implementing Table Structures in SQL Server
    • Reading SQL Server Execution Plans
    • Lab : Reading SQL Server Execution Plans
    • Improving Performance through Nonclustered Indexes
    • Lab : Improving Performance through Nonclustered Indexes
    • Designing and Implementing Stored Procedures
    • Lab : Designing and Implementing Stored Procedures
    • Merging Data and Passing Tables
    • Lab : Merging Data and Passing Tables
    • Creating Highly Concurrent SQL Server Applications
    • Lab : Creating Highly Concurrent SQL Server Applications
    • Handling Errors in T-SQL Code
    • Lab : Handling Errors in T-SQL Code
    • Designing and Implementing User-Defined Functions
    • Lab : Designing and Implementing User-Defined Functions
    • Ensuring Data Integrity through Constraints
    • Lab : Ensuring Data Integrity through Constraints
    • Responding to Data Manipulation via Triggers
    • Lab : Responding to Data Manipulation via Triggers
    • Implementing Managed Code in SQL Server
    • Lab : Implementing Managed Code in SQL Server
    • Storing XML Data in SQL Server
    • Lab : Storing XML Data in SQL Server
    • Querying XML Data in SQL Server
    • Lab : Querying XML Data in SQL Server
    • Working with SQL Server Spatial Data
    • Lab : Working with SQL Server Spatial Data
    • Working with Full-Text Indexes and Queries
    • Lab : Working with Full-Text Indexes and Queries

    Click for FULL COURSE DETAILS

    6235: MS SQL Server 2008 Integration Services SUPERCEDED

    Logo for Microsoft SQL Server 2012 Certified Training : 6235: SQL Server 2008: Integration Services
    COURSE OUTLINE     [Duration: three days]

    • Module 1: Introduction to SQL Server 2008 Integration Services
    • Lab : Introduction to SQL Server Integration Services
    • Module 2: Developing Integration Services Solutions
    • Lab : Developing Integration Services Solutions
    • Module 3: Implementing Control Flow
    • Lab : Implementing Control Flow
    • Module 4: Implementing Data Flow
    • Lab : Implementing Data Flow
    • Module 5: Implementing Logging
    • Lab : Implementing Logging
    • Module 6: Debugging and Error Handling
    • Lab : Debugging and Error Handling
    • Module 7: Implementing Checkpoints and Transactions
    • Lab : Implementing Checkpoints and Transactions
    • Module 8: Configuring and Deploying Packages
    • Lab : Configuring and Deploying Packages
    • Module 9: Managing and Securing Packages
    • Lab : Managing and Securing Packages

    Click for FULL COURSE DETAILS

    6235: Implementing and Maintaining Microsoft SQL Server 2008 Integration Services

    Logo for Microsoft SQL Server 2012 Certified Training : 6235: SQL Server 2008: Integration Services
    COURSE OUTLINE     [Duration: three days]

    • Module 1: Introduction to SQL Server 2008 Integration Services
    • Lab : Introduction to SQL Server Integration Services
    • Module 2: Developing Integration Services Solutions
    • Lab : Developing Integration Services Solutions
    • Module 3: Implementing Control Flow
    • Lab : Implementing Control Flow
    • Module 4: Implementing Data Flow
    • Lab : Implementing Data Flow
    • Module 5: Implementing Logging
    • Lab : Implementing Logging
    • Module 6: Debugging and Error Handling
    • Lab : Debugging and Error Handling
    • Module 7: Implementing Checkpoints and Transactions
    • Lab : Implementing Checkpoints and Transactions
    • Module 8: Configuring and Deploying Packages
    • Lab : Configuring and Deploying Packages
    • Module 9: Managing and Securing Packages
    • Lab : Managing and Securing Packages

    Click for FULL COURSE DETAILS

    6236: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

    Logo for Microsoft SQL Server 2012 Certified Training : 6236: SQL Server 2008: Reporting Services
    COURSE OUTLINE     [Duration: three days]

    • Module 1: Introduction to Microsoft SQL Server Reporting Services
    • Lab : Introduction to Microsoft SQL Server Reporting Services
    • Module 2: Authoring Basic Reports
    • Lab : Authoring Basic Reports
    • Module 3: Enhancing Basic Reports
    • Lab : Enhancing Basic Reports
    • Module 4: Manipulating Data Sets
    • Lab : Manipulating Data Sets
    • Module 5: Using Report Models
    • Lab : Using Report Models
    • Module 6: Publishing and Executing Reports
    • Lab : Publishing and Executing Reports
    • Module 7: Using Subscriptions to Distribute Reports
    • Lab : Using Subscriptions to Distribute Reports
    • Module 8: Administering Reporting Services
    • Lab : Administering Reporting Services
    • Module 9: Programming Reporting Services
    • Lab : Programming Reporting Services

    Click for FULL COURSE DETAILS

    10774: Querying Microsoft SQL Server 2012

    Logo for Microsoft SQL Server 2012 Certified Training : 10774: Querying Microsoft SQL Server 2012
    COURSE OUTLINE     [Duration: five days]

    • Introduction to Microsoft SQL Server 2012
    • Lab : Working with SQL Server 2012 Tools
    • Getting Started with SQL Azure
    • 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 2012 Data Types
    • Lab : Working with SQL Server 2012 Data Types
    • 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
    • Querying SQL Server Metadata
    • Lab : Querying SQL Server Metadata
    • 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
    • Improving Query Performance
    • Lab : Improving Query Performance

    Click for FULL COURSE DETAILS

    10775: Administering Microsoft SQL Server 2012 Databases

    Logo for Microsoft SQL Server 2012 Certified Training : 10775: Administering SQL Server 2012 Databases
    COURSE OUTLINE     [Duration: five days]

    • Introduction to SQL Server 2012 and its Toolset
    • Lab : Introduction to SQL Server and its Toolset
    • Preparing Systems for SQL Server 2012
    • Lab : Preparing Systems for SQL Server
    • Installing and Configuring SQL Server 2012
    • Lab : Installing and Configuring SQL Server
    • Working with Databases
    • Lab : Working with Databases
    • Understanding SQL Server 2012 Recovery Models
    • Lab : Understanding SQL Server Recovery Models
    • Backup of SQL Server 2012 Databases
    • Lab : Backup of SQL Server Databases
    • Restoring SQL Server 2012 Databases
    • Lab : Restoring SQL Server 2012 Databases
    • Importing and Exporting Data
    • Lab : Importing and Exporting Data
    • Authenticating and Authorizing Users
    • Lab : Authenticating and Authorizing Users
    • Assigning Server and Database Roles
    • Lab : Assigning Server and Database Roles
    • Authorizing Users to Access Resources
    • Lab : Authorizing Users to Access Resources
    • Auditing SQL Server Environments
    • Lab : Auditing SQL Server Environments
    • Automating SQL Server 2012 Management
    • Lab : Automating SQL Server Management
    • Configuring Security for SQL Server Agent
    • Lab : Configuring Security for SQL Server Agent
    • Monitoring SQL Server 2012 with Alerts and Notifications
    • Lab : Monitoring SQL Agent Jobs with Alerts and Notifications
    • Performing Ongoing Database Maintenance
    • Lab : Performing Ongoing Database Maintenance
    • Tracing Access to SQL Server 2012
    • Lab : Tracing Access to SQL Server 2012
    • Monitoring SQL Server 2012
    • Lab : Monitoring SQL Server 2012
    • Managing Multiple Servers
    • Lab : Managing Multiple Servers
    • Troubleshooting Common SQL Server 2012 Administrative Issues
    • Lab : Troubleshooting Common Issues

    Click for FULL COURSE DETAILS

    10776: Developing Microsoft SQL Server 2012 Databases

    Logo for Microsoft SQL Server 2012 Certified Training : 10776: Developing SQL Server 2012 Databases
    COURSE OUTLINE     [Duration: five days]

    • Introduction to SQL Server 2012 and its Toolset
    • Lab : Introduction to SQL Server and its Toolset
    • Working with Data Types
    • Lab : Working with Data Types
    • Designing and Implementing Tables
    • Lab : Designing and Implementing Tables
    • Ensuring Data Integrity through Constraints
    • Lab : Ensuring Data Integrity through Constraints
    • Planning for SQL Server 2012 Indexing
    • Lab : Planning for SQL Server Indexing
    • Implementing Table Structures in SQL Server 2012
    • Lab : Implementing Table Structures in SQL Server
    • Reading SQL Server 2012 Execution Plans
    • Lab : Reading SQL Server Execution Plans
    • Improving Performance through Nonclustered Indexes
    • Lab : Improving Performance through Nonclustered Indexes
    • Designing and Implementing Views
    • Lab : Designing and Implementing Views
    • Designing and Implementing Stored Procedures
    • Lab : Designing and Implementing Stored Procedures
    • Merging Data and Passing Tables
    • Lab : Passing Tables and Merging Data
    • Designing and Implementing User-Defined Functions
    • Lab : Designing and Implementing User-Defined Functions
    • Creating Highly Concurrent SQL Server 2012 Applications
    • Lab : Creating Highly Concurrent SQL Server Applications
    • Handling Errors in T-SQL Code
    • Lab : Handling Errors in T-SQL Code
    • Responding to Data Manipulation via Triggers
    • Lab : Responding to Data Manipulation via Triggers
    • Implementing Managed Code in SQL Server 2012
    • Lab : Designing and Implementing Views
    • Storing XML Data in SQL Server 2012
    • Lab : Storing XML Data in SQL Server
    • Querying XML Data in SQL Server
    • Lab : Querying XML Data in SQL Server
    • Working with SQL Server 2012 Spatial Data
    • Lab : Working with SQL Server Spatial Data
    • Working with Full-Text Indexes and Queries
    • Lab : Working with Full-Text Indexes and Queries

    Click for FULL COURSE DETAILS

    10777: Implementing a Data Warehouse with Microsoft SQL Server 2012

    Logo for Microsoft SQL Server 2012 Certified Training : 10777: Data Warehousing with SQL Server 2012
    COURSE OUTLINE     [Duration: five days]

    • Introduction to Data Warehousing
    • Lab : Exploring a Data Warehousing Solution
    • Data Warehouse Hardware
    • Designing and Implementing a Data Warehouse
    • Lab : Implementing a Data Warehouse Schema
    • Creating an ETL Solution with SSIS
    • Lab : Implementing Data Flow in a 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 an Incremental ETL Process
    • Lab : Extracting Modified Data
    • Lab : Loading Incremental Changes
    • Incorporating Data from the Cloud into a Data Warehouse
    • Lab : Using Cloud Data in a Data Warehouse Solution
    • Enforcing Data Quality
    • Lab : Cleansing Data
    • Lab : Deduplicating Data
    • Using Master Data Services
    • Lab : Implementing Master Data Services
    • Extending SQL Server Integration Services
    • Lab : Using Custom Components and Scripts
    • Deploying and Configuring SSIS Packages
    • Lab : Deploying and Configuring SSIS Packages
    • Consuming Data in a Data Warehouse
    • Lab : Using Business Intelligence Tools

    Click for FULL COURSE DETAILS

    10778: Implementing Data Models and Reports with Microsoft SQL Server 2012

    Logo for Microsoft SQL Server 2012 Certified Training : 10778: Data Models & Reports with SQL Server 2012
    COURSE OUTLINE     [Duration: five days]

    • Introduction to Business Intelligence and Data Modeling
    • Lab : Reporting and Analyzing Data
    • Implementing Reports with SQL Server Reporting Services
    • Lab : Creating a Report with Report Designer
    • Lab : Enhancing and Publishing a Report
    • Supporting Self Service Reporting
    • Lab : Implementing Self Service Reporting
    • Managing Report Execution and Delivery
    • Lab : Configuring Report Execution and Delivery
    • Lab : Creating a Multidimensional Database
    • Working with Dimensions
    • Lab : Defining Dimensions
    • Working with Measures and Measure Groups
    • Lab : Configuring Measures and Measure Groups
    • Introduction to MDX
    • Lab : Using MDX
    • Customizing Cube Functionality
    • Lab : Customizing a Cube
    • Implementing a Tabular Data Model with Microsoft PowerPivot
    • Lab : Using PowerPivot for Excel
    • Introduction to DAX
    • Lab : Creating Calculated Columns and Measures by Using DAX
    • Implementing an Analysis Services Tabular Data Model
    • Lab : Working with an Analysis Services Tabular Data Model
    • Creating Data Visualizations with Power View
    • Lab : Creating Data Visualizations with Power View
    • Performing Predictive Analysis with Data Mining
    • Lab : Using Data Mining to Support a Marketing Campaign

    Click for FULL COURSE DETAILS

    10977: Upgrading Your SQL Server Skills to Microsoft SQL Server 2014

    Logo for Microsoft SQL Server 2012 Certified Training : 10977: Upgrading SQL Skills to SQL Server 2014
    COURSE OUTLINE     [Duration: five days]

    • 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

    10990: Analysing Data With SQL Server Reporting Services

    Logo for Microsoft SQL Server 2012 Certified Training : Analysing Data With SQL Server Reporting
    COURSE OUTLINE     [Duration: five days]

      Click for FULL COURSE DETAILS

      20461: Querying Microsoft SQL Server 2014

      Logo for Microsoft SQL Server 2012 Certified Training : 20461: Querying Microsoft SQL Server 2014
      COURSE OUTLINE     [Duration: five days]

      • 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 Microsoft SQL Server 2014 Databases

      Logo for Microsoft SQL Server 2012 Certified Training : 20462: Administering MS SQL Server Databases
      COURSE OUTLINE     [Duration: five days]

      • 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: Implementing a Data Warehouse with Microsoft SQL Server 2014

      Logo for Microsoft SQL Server 2012 Certified Training : 20463: Implement a Data Warehouse with SQL Server
      COURSE OUTLINE     [Duration: five days]

      • 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 Microsoft SQL Server 2014 Databases

      Logo for Microsoft SQL Server 2012 Certified Training : 20464: Developing MS SQL Server 2014 Databases
      COURSE OUTLINE     [Duration: five days]

      • 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 with Microsoft SQL Server 2014

      Logo for Microsoft SQL Server 2012 Certified Training : 20465: Designing a Data Solution - SQL Server 2014
      COURSE OUTLINE     [Duration: five days]

      • 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: Implementing Data Models and Reports with Microsoft SQL Server 2014

      Logo for Microsoft SQL Server 2012 Certified Training : 20466: Implement Data Models with SQL Server 2014
      COURSE OUTLINE     [Duration: five days]

      • 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: Designing Business Intelligence Solutions with Microsoft SQL Server 2014

      Logo for Microsoft SQL Server 2012 Certified Training : 20467: Business Intelligence (BI): SQL Server 2014
      COURSE OUTLINE     [Duration: four days]

      • 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

      Querying SQL Databases using T-SQL

      Logo for Microsoft SQL Server 2012 Certified Training : QATSQL : Querying SQL Databases using T-SQL
      COURSE OUTLINE     [Duration: two days]

        Click for FULL COURSE DETAILS

        50027: Querying and Processing SQL Server Data Using Microsoft SQL Server

        Logo for Microsoft SQL Server 2012 Certified Training : 50027: SQL Server: Querying & Processing Data
        COURSE OUTLINE     [Duration: two days]

        • Module 1: Quick Intro to SQL Query Basics
        • Module 2: Working with Views
        • Module 3: Advanced SQL Query Tactics
        • Module 4: Data Manipulation Statements
        • Module 5: Working with Procedures
        • Module 6: Task-Oriented Queries

        Click for FULL COURSE DETAILS

        50401: Designing and Optimising Database Solutions with Microsoft SQL Server 2008

        Logo for Microsoft SQL Server 2012 Certified Training : 50401: SQL Server 2008: Database Solutions
        COURSE OUTLINE     [Duration: five days]

        • Module 1: Designing a Conceptual Database Model
        • Lab : Designing a Conceptual Database Model
        • Module 2: Designing a Logical Database Model
        • Lab : Designing a Logical Database Model
        • Module 3: Designing a Physical Database Model
        • Lab : Designing a Physical Database Model
        • Module 4: Designing Databases for Optimal Performance
        • Lab : Designing Databases for Optimal Performance
        • Module 5: Designing Security for SQL Server 2008
        • Lab : Designing Security for SQL Server 2008
        • Module 6: Designing a Strategy for Database Access
        • Lab : Designing a Strategy for Database Access
        • Module 7: Designing Queries for Optimal Performance
        • Lab : Designing Queries for Optimal Performance
        • Module 8: Designing a Transaction and Concurrency Strategy
        • Lab : Designing a Transaction and Concurrency Strategy
        • Module 9: Designing an XML Strategy
        • Lab : Designing an XML Strategy
        • Module 10: Designing SQL Server 2008 Components
        • Lab : Designing SQL Server 2008 Components

        Click for FULL COURSE DETAILS

        Want to see prices and options for delivery of your training?

        Move to next SQL Server section

        GENERAL INFORMATION

        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!



        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

        Stay in touch
                  TrustPilot
        CPD
        ILM
        ISO9001


        Back to top
        HOME
        Get your Attendance Certificate
        See Our SQL Server Courses
            10977: Upgrading SQL Skills to SQL Server 2014
            Analysing Data With SQL Server Reporting
            20461: Querying Microsoft SQL Server 2014
            20462: Administering MS SQL Server Databases
            20463: Implement a Data Warehouse with SQL Server
            20464: Developing MS SQL Server 2014 Databases
            20465: Designing a Data Solution - SQL Server 2014
            20466: Implement Data Models with SQL Server 2014
            20467: Business Intelligence (BI): SQL Server 2014
            QATSQL : Querying SQL Databases using T-SQL
            10774: Querying Microsoft SQL Server 2012
            10775: Administering SQL Server 2012 Databases
            10776: Developing SQL Server 2012 Databases
            10777: Data Warehousing with SQL Server 2012
            10778: Data Models & Reports with SQL Server 2012
            6232: Implementing SQL Server 2008 R2
            6231: Maintaining SQL Server 2008 R2
            6235: SQL Server 2008: Integration Services
            6236: SQL Server 2008: Reporting Services
            50401: SQL Server 2008: Database Solutions
            2778: SQL Server 2008: Writing Queries
            6235: SQL Server 2008: Integration Services
            2778: SQL Server 2008: Writing Queries
            2786: SQL Server 2005: Infrastructure Design
            2787: SQL Server 2005: Security
            2788: SQL Server 2005: Database Design
            2789: SQL Server 2005: Databases and Servers
            2790: SQL Server 2005: Database Servers
            50027: SQL Server: Querying & Processing Data
            2779: SQL Server 2005: Implementing a Database
        Microsoft Certification Courses
        REQUEST MORE INFORMATION
        View prices/options, and book
        We do not schedule classes for SQL Server, please contact us to discuss delivering training at your offices.

        OK
        Site Cookies
        We have placed cookies on your device to help make this website better.

        You can change your cookie settings in your browser. Otherwise, we’ll assume you’re OK to continue.

        I'm fine with this