CUSTOMISED
Expert-led training for your team

Dismiss

T-SQL training course

Explore SQL Server's Powerful Development Features And Quickly Develop Robust Applications For Your Organisation

"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"

Brian Leek, Data Analyst, May 2022

Public Courses

09/12/24 - 3 days

£1695 +VAT

Enrol

20/01/25 - 3 days

£1695 +VAT

Enrol

03/03/25 - 3 days

£1695 +VAT

Enrol

Customised Courses

* Train a team
* Tailor content
* Flex dates

From £1200 / day

Highlights Details Audience Feedback Prices/Dates

Public Courses

Highlights

Utilisation of the new Management Studio and associated tools.
Confidence to program database objects in TSQL.
Use extensive new TSQL features.
Exploit native XML data support, including the new XQuery feature
Work with Visual Studio tools and the Common Language Runtime to create managed procedures and types.
Deliver functional Web Services with HTTP Endpoints
Use ADO.NET for new data access capabilities, including asynchronous commands.

Course Details

SQL Server 2014 Overview
Version History
Feature Overview
Development Tools

Programming with Transact SQL (TSQL) - the Basics
Using Variables
Control of Flow Statements
Error Handling
Using Cursors

Programming Views
Creating Views
Updating Through Views
Indexed Views

Programming Stored Procedures
Creating Procedures
Passing Parameters

Programming User Defined Functions
Scalar, Inline Table and Multi-Statement
Data Manipulation in UDFs
Profiling UDFs

Programming Triggers
Trigger Syntax
Trigger Events
Enabling/Disabling Triggers
Nested Triggers

TSQL Enhancements
Ranking Functions
Recursive Queries
Relational Operators

Monitoring your SQL Server
Data Definition Language Triggers
DDL Event Notifications
Metadata Views

Messaging with the SQL Server 2014 Service Broker
Architecture Overview
Service Broker Example
Conversation Architecture
Conversation Process
Security

Using SQL Server 2014 Integration Services (SSIS)
Work Flow and Data Flow
Package Design
Deployment
Worked Examples

XML-Based Solutions
XML Data Type
FOR XML Enhancements
OPENXML Enhancements
XML Schemas
XML Indexes

Web Services and HTTP Endpoints
Web Services Architecture
Native HTTP Support
HTTP Endpoint Declaration
XML Input/Output Types

Coding SQL Server with .NET
Enabling the .NET CLR
Creating Managed Stored Procedures
Creating Managed UDFs
Creating Managed Triggers

Building SQL 2014 Client Applications
Snapshot Isolation
Bulk Import

Who should attend

IT Professionals who need to learn to build database applications which take advantage of powerful server-side features that Microsoft SQL Server provides.

Feedback

4.8 out of 5 average

Brian Leek, Data Analyst, May 2022

“JBI did a great job of customizing their syllabus to suit our business needs and also bringing our team up to speed on the current best practices. Our teams varied widely in terms of experience and the Instructor handled this particularly well - very impressive”

Brian F, Team Lead, RBS, Data Analysis Course, 20 April 2022

SQL Server Administration

SQL Server Performance Tuning

Transact-SQL Server Programming

Sign up for the JBI Training newsletter to stay updated with world-class technology training opportunities, including Analytics, AI, ML, DevOps, Web, Backend and Security. Our Power BI Training Course is especially popular. Gain new skills, useful tips, and validate your expertise with an industry-leading organisation, all tailored to your schedule and learning preferences.

More about this course

This T-SQL training course provides a comprehensive introducion to developing applications using Microsoft SQL Server . Delegates will take full advantage of the powerful new development features with TSQL and the common language runtime. In addition the course explores native XML support, SQL Server as a Web Services platform, ADO/ADO.NET enhancements and the new suite of built-in application server capabilities.

FAQs

CONTACT
+44 (0)20 8446 7555

[email protected]

SHARE

Copyright © 2024 JBI Training. All Rights Reserved.
JB International Training Ltd - Company Registration Number: 08458005
Registered Address: Wohl Enterprise Hub, 2B Redbourne Avenue, London, N3 2BS

Modern Slavery Statement & Corporate Policies | Terms & Conditions | Contact Us