020 3137 3920

Training Programmes
We are experts in training design and delivery, from needs analysis through to follow-up support.
Industry-Specific Training

Your business is unique - and your training should be too. We deliver technical training programmes for industries including:

Finance
Insurance
Health Sciences

Role-Based Training

Bespoke training programmes which explore the most relevant technologies and techniques for your discipline or project, including:

Agile Kick-start
Security Professional
Data Scientist
Full Stack Developer

Graduate Intake Training

Ensure your next generation gets off to the right start with an exciting, on-brand, business-focused training programme.

Graduate Training Schemes
It’s vital to ensure your team has the right tools and techniques to bring the best products to market. Talk to us out about building a training programme that centres on your needs..

More on training programmes

Courses

Home

Courses

Data

Database Development Training Courses

SQL Server Training Course - T-SQL and Stored Procedures with SQL Server 2016

SQL Server Training Course - T-SQL and Stored Procedures with SQL Server 2016

Tailor this course for your business

Code: MSSQL1

Duration

4 Days

Looking for a cost effective solution that adds business value?

Talk to us

Learn to develop commercial SQL Server database applications

Our SQL Server Programming training course gives delegates a solid introduction to developing secure, robust commercial database applications incorporating Transact-SQL, Stored Procedures and XML.

Microsoft SQL Server combines power with scalability, and is at the heart of a huge number of the world's CRM, ERP, CMS and e-commerce systems, and has solid support for deployment in the Cloud through Microsoft's Azure platform.

Please let us know if you require this training on SQL Server 2008, SQL Server 2012, or SQL Server 2014 as we are happy to deliver custom courses on previous versions.

In a nutshell Who should attend On-site Syllabus

By the end of this course, you will have learnt:

Create robust and well-optimised databases in SQL Server 2016
Write SQL queries and Stored Procedures to manipulate data
Learn SQL Server Management Studio Best Practises
Creating tables and constraints
Replicating data between multiple databases
Disaster Recovery strategies
Overview of Microsoft Business Intelligence with Reporting Services

Who should attend

This course is aimed at anyone who needs to gain hands-on experience with SQL Server, creating commercial database solutions with T-SQL, XML and Stored Procedures

Prerequisites

Delegates will ideally have some experience of writing basic SQL queries in a Relational Database such as Access or MySQL.

On-site

If you are interested in custom / on-site SQL Server Programming training for any size of team, please get in touch – we would be glad to help build a course that meets your learning requirements.

We can take into account your existing technical skills, project requirements and timeframes, and specific topics of interest to tailor the most relevant and focussed course for you.

This can be particularly useful if you need to learn just the new features and SQL Server Programming Best Practices, or need to include extra topics to help with pre-requisite skills.

We can also base custom courses on SQL Server 2008, SQL Server 2012, or SQL Server 2014 if that is your current production environment.

SQL Server Programming Course Syllabus

Introduction to SQL Server 2016 Architecture

Client / Server modelSQL Server Management Studio
Business Intelligence Development Studio
Database schemas
Integrating with .NET CLR
Windows / .NET Authentication
Creating a database
Files and Directories
Parameters and options
Filegroups
SQL Server Database Schemas

TSQL Features

WithResultsSet
Throw / Catch (Error Handling)
Offset and Fetch
Sequence

Tables and Data Types

Pre-configured Data Types
Creating custom Data Types
Handling columns
Table Partitions
Indexing tables

Constraints and Triggers

Primary keys
Validation
Foreign keys
Triggers

Server-Side Programming with Transact-SQL

SQL statements in Query Designer
Joining multiple tables
INSERT, UPDATE, DELETE

Stored Procedures

Efficiency Benefits of using Stored Procedures
Creating and deploying new Stored Procedures
Maintaining existing Stored Procedures
AFTER Triggers

SQL Server and XML

Storing and Retrieving XML
Intro to XQuery
XML Native Data Types
XML Schemas and Indexes

Administration Essentials for Developers

Monitoring SQL Server
Roles and user memberships
Security policy
Maintenance Plan Wizard
Scheduling backups Checking database integrity
Defragmenting data
Notification Services / Management Reports
Replication - Snapshot / Transactional / Merge

"There was good breadth to the topics without giving too much information for an introductory course. The interactive activities were good. It was good to get suggestions specifically relating to what we do."

Agile Project Management Training Course
SO, Project Manager
AMEC

"The team had a great time on the course and we were all really impressed with Toby!"

Angular Training Course
CH, Software Developer
1x2 Network

"The tutor was very good. He definitely knows his stuff!"

Python Training Course
Anonymous, Test Analyst
BBC

"The instructor command of the subject was very high. Some subjects (like Testing and Mocking) was completely new to me but I now believe have acquired a good command of the subject and intend to apply it in practice soon."

Advanced C# Programming Training Course
CA, Senior Developer
Sayula

"I just want to drop you a note to say a huge thank you for such an amazing training course last week. The course exceeded all our expectations and was extremely timely for our team and has provided us with a way to move forward in terms of process & tool set. The level of discussion on process & its applicability was invaluable, so thanks. The full process from course tailoring to agreement and course delivery was professional and I can’t offer any suggested improvements!"

FD, Business Systems Manager
Frazer-Nash Consultancy

"The examples and labs were easy to follow. Many thanks!"

ASP.NET Core MVC 2.0 Training Course
SW, Software Engineer
DHL

"The course content was very good. John had delivered it in a way which was easy to understand, especially for me someone who has never worked on Angular before. I like the way he explained difficult concepts by showing the working examples and exercises. The best thing about the course was the focus on learning theory via hands-on practical examples."

Angular Training Course
SS, Developer
Aon Hewitt

"The instructor was very engaging and the training valuable to me. Really helped me appreciate the benefits of Scrum practice."

Professional Scrum Master I™ (PSM I) Training Course
IG, Project Manager
Amadeus

"We particularly enjoyed Stuart's anecdotes and stories which gave context to the topics discussed."

PCI DSS Training Course - PCI DSS 3.2.1 Compliancy
RT, Developer
JATO

"Very informative and enjoyable."

Professional Scrum Product Owner™ (PSPO) Training Course
JC, Project Lead
TFL

Get in touch

We would love to hear from you if you have any questions about your training needs.

or call us on 020 3137 3920

We use cookies on our website to provide you with the best user experience. If you're happy with this please continue to use the site as normal.
For more information please see our Privacy Policy.

I understand