Why choose us?
Dismiss

T-SQL training course

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

4.8 out of 5 average

(see feedback)
CUSTOM COURSES
  • Train a team
  • Customised content
  • Free tasters
PUBLIC COURSES
  • Next on 6 Dec
  • £1,695.00+vat
  • Live / Virtual

JBI training course London UK

  • 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.

FULL COURSE DETAILS
ENQUIRE / BOOK

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.

FULL COURSE DETAILS
ENQUIRE / BOOK
JBI training course London UK
JBI training course London UK

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

FULL COURSE DETAILS
ENQUIRE / BOOK

4.8 out of 5 average

JBI training course London UK
  • 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
 
Course Updates & Newsletter
 
 

Receive the latest version of this course by email & subscribe to our Newsletter



CONTACT
+44 (0)20 8446 7555

enquiries@jbinternational.co.uk

SHARE

Corporate Policies     Terms & Conditions
JB International Training Ltd  -  Company number 08458005

Registered address Wohl Enterprise Hub 2B Redbourne Avenue London N3 2BS