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

"The course had a good structure. We liked the informal approach. "

Angular Training Course
MS, Senior Developer
Aon Hewitt

"The course gave me a good understanding of Angular and associated packages. I would have preferred to spend less time on the initial setup as additional software was needed that was not on my machine."

Angular Training Course
MB, Developer
SSTL

"Very informative and enjoyable."

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

"Useful discussions helped clarify and demonstrate the Product Owner role."

Professional Scrum Product Owner™ (PSPO) Training Course
SI, Product Owner
TFL

"This Agile methodology can be applied to every day life!"

Professional Scrum Product Owner™ (PSPO) Training Course
M-CD, Product Owner
Amadeus

"The tutor was obviously very knowledgeable who encouraged interesting discussions across the group. "

Professional Scrum Master I™ (PSM I) Training Course
KB, Scrum Master
Amadeus

"The instructor was very knowledgeable and his explanations were very clear. "

Advanced C# 7 & C# 6 Programming Training Course
BM, Senior Analyst
Carl Zeiss Microcopy

"Great course. It does what is says on the tin. The course fitted to our needs. The instructor was friendly, approachable and very knowledgeable."

Agile Project Management Training Course
AF, Project Manager
AMEC

"That was an excellent course, I loved the interactivity and group work. Excellent to open our minds and help us having a Scrum mindset."

Professional Scrum Product Owner™ (PSPO) Training Course
MS, Product Owner
Amadeus

"Framework Training delivered an excellent course that was well-structured and nicely taught. I will recommend to my manager that the other members of our team would really benefit from attending."

grep, SED and AWK for Linux / UNIX Best Practices Training Course
SC, DevOps Consultant
CGG

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