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?

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

"Mixture of lecture and tutorial content. "Learn by doing""

Data Science with Python Training Course
JD, Data Scientist
Winton Capital

"Well paced, good overview of the material as required. Good balance of hands-on and talk/theory."

Apache Spark Training Course
JB, Lead Developer
Orange

"The pace of the course and the instructor's flexibility meant we were able to cover a lot of ground, all of which was directly relevant to our upcoming projects. A number of different Big Data solutions were explored."

Hadoop Training Course
NB, Senior Analyst
University of Oxford

We would love to hear from you

Speak to us on 020 3137 3920 or get in touch below

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