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

Standard duration: 4 Days
Email course link

Tailor this course for your business

Looking for a cost effective solution that adds business value? Talk to us to find out how we can customise the course for your business.

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

" Course was very relevant, and all the basic topics were covered. Good pace. "

Data Science with Python Training Course
MFA, Data Analyst [Remote online course]
ActiveViam

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

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

" The Jupyter notebooks were really handy, and I liked the group work using the breakout room feature of Zoom. Although the participants were from different backgrounds, Marco handled this very well by constantly checking if anyone has questions, adding explanations and making sure that the pace is right for the group. "

Data Science with Python Training Course
FSK, Data Analyst [Remote online course]
ActiveViam

" It was very good. In particular the separated chat rooms used for some of the exercises worked very well. "

Data Science with Python Training Course
JHO, Data Analyst [Remote online course]
ActiveViam

"I thought the introduction stage and discussion exercises to be very useful."

Data Analysis with Python Training Course
EL, Software Engineer
Major UK retail and commercial bank

About the course:

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.

Trusted by:

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

Public Courses Dates and Rates

Standard duration: 4 Days

Please get in touch for pricing and availability.

Interested in this course?

If you want to explore how you can tailor this course for your organisation, want to sign up for our newsletter, or have any other questions then please speak to us on 020 3137 3920 or get in touch using this form.

This form requires javaScript to work, please email us at webenquiries@frameworktraining.co.uk if you do not have it enabled.