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

20461: QUERYING MICROSOFT SQL SERVER 2014

The best source of Business Training

A hands-on five-day course with free pre-course online skills testing
See Our Latest Reviews on TrustPilot:
Activia Training Silver Jubilee - training since 1995

Our SILVER JUBILEE OFFER
Prices you'll not see anywhere else!

Training vouchers

Prices cut by up to 30%

Scheduled Public Classes: Additional delegates for just £99

Training at Your Offices: Prices from £299

Training Vouchers: Prices for block tickets from £725

Click the orange "Book Your Training" button on the right of the page, and see how much you can save ... but remember: these prices won't last for ever!



COURSE OUTLINE

Full details of modules and topics covered in this five-day course

VERSIONS COVERED

This course covers 2014 versions

DURATION

This is a five-day training course structured into 36 modules

COURSE AIMS

This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

TARGET AUDIENCE

This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren't necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.
Attendees ahould also have:

  • Working knowledge of relational databases.
  • Basic knowledge of the Microsoft Windows operating system and its core functionality

AUTHORISED MICROSOFT TRAINING COURSE

This is an authorised Microsoft training course, delivered by certified Microsoft trainers at fully equipped centres using the latest equipment, software and course materials. There is no better way to undertake your training, to maximise your learning and ensure the highest marks possible in your certification exams.


COURSE OBJECTIVES

Delegates will learn how to:

  • Write SELECT queries
  • Query multiple tables
  • Sort and filter data
  • Describe the use of data types in SQL Server
  • Modify data using Transact-SQL
  • Use built-in functions
  • Group and aggregate data
  • Use subqueries
  • Use table expressions
  • Use set operators
  • Use window ranking, offset and aggregate functions
  • Implement pivoting and grouping sets
  • Execute stored procedures
  • Program with T-SQL
  • Implement error handling
  • Implement transactions


CERTIFICATION

This course helps people to prepare for exam 70-461.


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

MODULE 1:  Introduction to Microsoft SQL Server 2014
Topics covered:
  • The Basic Architecture of SQL Server
  • SQL Server Editions and Versions
  • Getting Started with SQL Server Management Studio
MODULE 2:  Lab : Working with SQL Server 2014 Tools
Topics covered:
  • Working with SQL Server Management Studio
  • Creating and Organizing T-SQL scripts
  • Using Books Online
MODULE 3:  Introduction to T-SQL Querying
Topics covered:
  • Introducing T-SQL
  • Understanding Sets
  • Understanding Predicate Logic
  • Understanding the Logical Order of Operations in SELECT statements
MODULE 4:  Lab : Introduction to Transact-SQL Querying
Topics covered:
  • Executing Basic SELECT Statements
  • Executing queries which filter data using predicates
  • Executing queries which sort data using ORDER BY
MODULE 5:  Writing SELECT Queries
Topics covered:
  • Writing Simple SELECT Statements
  • Eliminating Duplicates with DISTINCT
  • Using Column and Table Aliases
  • Writing Simple CASE Expressions
MODULE 6:  Lab : Writing Basic SELECT Statements
Topics covered:
  • Write simple SELECT Statements
  • Eliminate Duplicates Using Distinct
  • Use Table and Column Aliases
  • Use a Simple CASE Expression
MODULE 7:  Querying Multiple Tables
Topics covered:
  • Understanding Joins
  • Querying with Inner Joins
  • Querying with Outer Joins
  • Querying with Cross Joins and Self Joins
MODULE 8:  Lab : Querying Multiple Tables
Topics covered:
  • Writing Queries That Use Inner Joins
  • Writing Queries That Use Multiple-Table Inner Join
  • Writing Queries That Use Self Joins
  • Writing Queries That Use Outer Joins
  • Writing Queries That Use Cross Joins
MODULE 9:  Sorting and Filtering Data
Topics covered:
  • Sorting Data
  • Filtering Data with a WHERE Clause
  • Filtering with the TOP and OFFSET-FETCH Options
  • Working with Unknown and Missing Values
MODULE 10:  Lab : Sorting and Filtering Data
Topics covered:
  • Writing Queries That Filter Data Using a WHERE Clause
  • Writing Queries That Filter Data Using an ORDER BY Clause
  • Writing Queries That Filter Data Using the TOP Option
  • Writing Queries That Filter Data Using the OFFSET-FETCH Clause
MODULE 11:  Working with SQL Server 2014 Data Types
Topics covered:
  • Introducing SQL Server 2014 Data Types
  • Working with Character Data
  • Working with Date and Time Data
MODULE 12:  Lab : Working with SQL Server 2014 Data Types
Topics covered:
  • Writing Queries That Return Date and Time Data
  • Writing Queries That Use Date and Time Functions
  • Writing Queries That Return Character Data
  • Writing Queries That Use Character Functions
MODULE 13:  Using DML to Modify Data
Topics covered:
  • Inserting Data
  • Modifying and Deleting Data
MODULE 14:  Lab : Using DML to Modify Data
Topics covered:
  • Inserting Data
  • Updating and Deleting Data
MODULE 15:  Using Built-In Functions
Topics covered:
  • Writing Queries with Built-In Functions
  • Using Conversion Functions
  • Using Logical Functions
  • Using Functions to Work with NULL
MODULE 16:  Lab : Using Built-In Functions
Topics covered:
  • Write queries which use conversion functions
  • Write queries which use logical functions
  • Write queries which test for nullability
MODULE 17:  Grouping and Aggregating Data
Topics covered:
  • Using Aggregate Functions
  • Using the GROUP BY Clause
  • Filtering Groups with HAVING
MODULE 18:  Lab : Grouping and Aggregating Data
Topics covered:
  • Write queries which use the GROUP BY clause
  • Write queries which use aggregate functions
  • Write queries which use distinct aggregate functions
  • Write queries which filter groups with the HAVING clause
MODULE 19:  Using Subqueries
Topics covered:
  • Writing Self-Contained Subqueries
  • Writing Correlated Subqueries
  • Using the EXISTS Predicate with Subqueries
MODULE 20:  Lab : Using Subqueries
Topics covered:
  • Write queries which use self-contained subqueries
  • Write queries which use scalar and multi-result subqueries
  • Write queries which use correlated subqueries and EXISTS predicate
MODULE 21:  Using Table Expressions
Topics covered:
  • Using Derived Tables
  • Using Common Table Expressions
  • Using Views
  • Using Inline Table-Valued Functions
MODULE 22:  Lab : Using Table Expressions
Topics covered:
  • Write Queries Which Use Views
  • Write Queries Which Use Derived Tables
  • Write Queries Which Use Common Table Expressions
  • Write Queries Which Use Inline Table-Valued Functions
MODULE 23:  Using Set Operators
Topics covered:
  • Writing Queries with the UNION Operator
  • Using EXCEPT and INTERSECT
  • Using APPLY
MODULE 24:  Lab : Using Set Operators
Topics covered:
  • Write queries which use UNION set operators and UNION ALL multi-set operators
  • Write queries which use CROSS APPLY and OUTER APPLY operators
  • Write queries which use EXCEPT and INTERSECT operators
MODULE 25:  Using Window Ranking, Offset, and Aggregate Functions
Topics covered:
  • Creating Windows with OVER
  • Exploring Window Functions
MODULE 26:  Lab : Using Window Ranking, Offset and Aggregate Functions
Topics covered:
  • Write queries which use ranking functions
  • Write queries which use offset functions
  • Write queries which use window aggregate functions
MODULE 27:  Pivoting and Grouping Sets
Topics covered:
  • Writing Queries with PIVOT and UNPIVOT
  • Working with Grouping Sets
MODULE 28:  Lab : Pivoting and Grouping Sets
Topics covered:
  • Write queries which use the PIVOT operator
  • Write queries which use the UNPIVOT operator
  • Write queries which use the GROUPING SETS subclause
MODULE 29:  Executing Stored Procedures
Topics covered:
  • Querying Data with Stored Procedures
  • Passing Parameters to Stored Procedures
  • Creating Simple Stored Procedures
  • Working with Dynamic SQL
MODULE 30:  Lab : Executing Stored Procedures
Topics covered:
  • Use the EXECUTE statement to invoke stored procedures
  • Pass parameters to stored procedures
  • Execute system stored procedures
MODULE 31:  Programming with T-SQL
Topics covered:
  • T-SQL Programming Elements
  • Controlling Program Flow
MODULE 32:  Lab : Programming with T-SQL
Topics covered:
  • Declaring Variables and Delimiting Batches
  • Using Control-of-Flow Elements
  • Generating Dynamic SQL
  • Using Synonyms
MODULE 33:  Implementing Error Handling
Topics covered:
  • Using TRY / CATCH Blocks
  • Working with Error Information
MODULE 34:  Lab : Implementing Error Handling
Topics covered:
  • Redirecting Errors with TRY / CATCH
  • Using THROW to Pass an Error Message Back to a Client
MODULE 35:  Implementing Transactions
Topics covered:
  • Transactions and the Database Engine
  • Controlling Transactions
  • Isolation Levels
MODULE 36:  Lab : Implementing Transactions
Topics covered:
  • Controlling transactions with BEGIN, COMMIT, and ROLLBACK
  • Adding error handling to a CATCH block

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

RELATED COURSES

10977: Upgrading SQL Skills to SQL Server 2014

  • 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


20462: Administering MS SQL Server Databases

  • 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


20463: Implement a Data Warehouse with SQL Server

  • 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

20464: Developing Microsoft SQL Server 2014 Databases

COURSE OUTLINE
[Duration: five day]

20464: Developing MS SQL Server 2014 Databases

  • 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


20465: Designing a Data Solution - SQL Server 2014

  • 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


20466: Implement Data Models with SQL Server 2014

  • 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


20467: Business Intelligence (BI): SQL Server 2014

  • 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

MORE INFORMATION FOR
QUERYING MICROSOFT SQL SERVER 2014

General Information

All SQL Server training courses use the latest content, qualified and experienced trainers, and provide delegates with the best learning experience. Training is interactive and classroom-based, and the ability to ask questions reinforces knowledge acquisition during the class.

Class Sizes

Maximum class sizes vary, but there is always adequate time for delegates to ask questions of the instructor.

How to book
Course, dates and delegate numbers
Decide on the SQL Server course you want, the date(s) you can attend, and the number of delegates involved
Call us
if at any time you want help or advice, or you want to book on the telephone, just call us on 0333 6000 111 to speak to one of our friendly training advisors

Note: With non-credit card bookings you must sign and return a Booking Form before we can confirm your training.

Also note: If you are a private individual you must pay by credit card at the time of booking.

The confirmation process
Course places allocated
Your place is allocated, along with the trainer, workbooks and exercise files if appropriate
Booking confirmation
You receive an official confirmation, with joining instructions (and directions if it's at our centre)
Training invoice
You receive a VAT invoice

Note: Please allow 1 - 2 working days for your confirmation and invoice.

What happens on the day

If you are coming to our centre, dress code is smart casual.   The timetable is as follows:

9:15

ARRIVAL TIME

9:30

TRAINING STARTS

11:00

MID-MORNING BREAK



1:00

ONE HOUR LUNCH BREAK

3:15

MID-AFTERNOON BREAK

4:30

WRAP UP

Note: break times can vary according to the needs of the training, and course duration for smaller class sizes are usually shorter because fewer delegates have fewer questions !

What you get

With your SQL Server training course from Activia, you get a free workbook, so you can review and revise afterwards to reinforce your knowledge.



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
Quick Links
More on This Page
Information & Resources
Special Offers
Information Updates
About Activia
Admin Tools
Quality Assurance

[NOTE: Mouse over the titles above,
then to visit the website pages you want,
click on the links in the right hand panel]
About Activia Training
Silver Jubilee training offers
To celebrate our 25 years in business, we're offering prices you won't see anywhere else:
  • Prices cut by up to 30%
  • Scheduled Public Classes: Extra delegates for just £99
  • Training at Your Offices: Prices from £299
  • Training Vouchers: Prices for block tickets from £725
e-Directory
Training e-directory
More than a brochure
Download on to a PC or Mac and
reference whenever you like
Newsletter
Activia newsletter
Stay In Touch
Don't miss out on out latest courses,
resources and special offers
Training Vouchers
Training vouchers
The Smart Way to Organise Training
Activia's Training Vouchers allow you to purchase
your training in advance at big discounts
Useful Information
Useful information
What Would You Like to Know?
Information about how we work, and think,
what we provide and the resources we offer
Download Your Certificate
Get your course certificate
Sent Straight to Your Inbox

Download your Activia certificate: just enter a few details
GateWay Login
Training GateWay
Your Complete Learning Management System
Schedule and manage company-wide training requirements
E-Learning Dashboard
Online dashboard
Log in and Get Started

View and manage your online courses
and videos
ISO9001
ISO9001 logo
Quality Assured continuously
since 2005

ISO9001 guarantees the quality of
operations and customer service
CPD Corporate Member
CPD corporate logo
CPD accredited courses:
quality content AND delivery

Get a CPD certificate with
most courses we deliver
ILM
ILM logo
See details of our ILM
development awards

Get official ILM certificates
after your training
Our Courses
Microsoft Desktop Software
Management
Project Management
HR, Training & Recruitment
Sales & Developing Business
Personal & Business Skills
Crystal Reports
 
Online Training: Videos
Online Training: Webinars
 
Use our Full Course Finder

[NOTE: Mouse over the titles above,
then to visit the website pages you want,
click on the links in the right hand panel]
Our courses
Select Your Course
We cover all you need
to improve productivity and
quality at work
Upgrade your skills in the shortest time!
Browse the categories on the left
but if you can't see what you want, click below:
Training course finder
Our Locations
London
South and South East
Midlands
North
 
About Our Training Centres
 
Training at Your Offices
 
Online Training: Videos
Online Training: Webinars

[NOTE: Mouse over the titles above,
then to visit the website pages you want,
click on the links in the right hand panel]
Our training centres
Activia's Centres in London
London Victoria training centre
60 Buckingham Palace Road
London
SW1W 0RR

0207 118 0069
Tower Bridge training centre
Tower Bridge Business Centre
46-48 East Smithfield
London
E1W 1AW
0207 118 0069
 
Activia's Centres in the South and South East
Reading training centre
9 Greyfriars Road
Reading
Berkshire
RG1 1NU
0118 418 1009
Bristol training centre
Easton Business Centre
Felix Road
Bristol
BS5 0HE
0117 259 1009
Milton Keynes training centre
Technology House
151 Silbury Boulevard
Milton Keynes
MK9 1LH
01908 984 151
Activia's Centres in the Midlands
Birmingham training centre
The McLaren Building
46 The Priory, Queensway
Birmingham
B4 7LR
0121 4011 369
Leicester training centre
Rutland House
23-25 Friar Lane
Leicester
LE1 5QQ
0116 416 1005
Nottingham training centre
Two King Street Nottingham
NG1 2AS

0115 7401 464
Activia's Centres in the North
Manchester training centre
111 Piccadilly
Manchester
M1 2HY
0161 207 1221
Leeds training centre
100-114 Wellington Street
Leeds
LS1 1BA
0113 4001 246
 
About our training centres
About Our Training Centres
With ten training centres, and a national network of trainers, we're sure to fit the bill for your training.
Training at Your Offices
How about this for easy training of groups of people?
All you need is a suitable room, and we can bring your training to you!
In house training
Ways to Contact Us
Email
Email Us Direct

Call
0333 6000 111 for Sales/Bookings
0333 6000 555 for Service
Callback request
Free Callback
If you'd like us to call you back, just fill in a simple form and we'll get back to you very soon!
More information
Request More Information
If you want more information, use our request form and we'll be in touch.



Contact us
Speedy Quote
If you can't see a price for what you want on the website, get in touch!

Feedback
Give Us Feedback
We always want to know what our customers think, so please contact us!

Schedule your own training course
Schedule Your Own
Only at Activia can you actually schedule your own Public/Open course.

We do not have classes for 20461: Querying Microsoft SQL Server 2014 scheduled at present but contact us to see how you can schedule your own

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