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

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