Skip to content

Online Programming with Transact-SQL course
Impartica IT Training

Virtual classroom - online courses available

Summary

Price
£708 inc VAT
Study method
Online + live classes
Duration
2 days · Full-time
Qualification
No formal qualification
Certificates
  • Certificate of completion - Free
Additional info
  • Tutor is available to students

Overview

Transact-SQL (or T-SQL) is Microsoft’s (and Sybase’s) proprietary extension to SQL. This course will introduce you to the programming features of the language, using Microsoft SQL Server. With prior knowledge of SQL assumed, this course looks at the procedural programming language capabilities of T-SQL, such as local variables, flow control constructs, error handling and built-in functions.

Certificates

Certificate of completion

Digital certificate - Included

Description

Introducing Transact-SQL

  • What is Transact-SQL?
  • Procedural Programming Language
  • Programme structures
  • What does T-SQL look like?
  • Statement blocks
  • Comments
  • Adding comments

Variables

  • What are variables?
  • Declaring a variable
  • Variable names
  • Available data types
  • The scope of a variable
  • Setting a variable with SET
  • Initialising a variable
  • New operators in SQL Server 2008
  • Displaying the values of variables
  • Setting variables from queries
  • Assigning values in the UPDATE Statement

Table variables

  • Table variables
  • Table variable rules

Conditional logic

  • Conditions: IF
  • Conditions: ELSE
  • Conditions: Nested IF
  • Conditions
  • Note on declaring variables

Loops and other control-of-flow mechanisms

  • Loops
  • The WHILE statement
  • BREAK
  • CONTINUE
  • GOTO
  • WAITFOR

Processing records with cursors

  • Cursors
  • Using a cursor
  • Declaring a cursor
  • Local and global cursors
  • Opening a cursor and fetching a record
  • Check if a row was returned
  • Using @@FETCH_STATUS
  • Closing and deallocating a cursor
  • @@CURSOR_ROWS
  • Cursor variables
  • FOR UPDATE / WHERE CURRENT OF

More cursor options

  • More on the FETCH statement
  • DECLARE CURSOR options
  • Restrictions on cursor options

Handling errors

  • Error handling in SQL Server
  • The @@ERROR global function
  • Working with @@ERROR
  • TRY..CATCH
  • The CATCH block
  • More error functions
  • Nested TRY..CATCH blocks
  • RAISERROR

Stored procedures

  • What are stored procedures?
  • Advantages of stored procedures
  • What is/is not allowed?
  • Creating stored procedures
  • Stored procedure names
  • Executing stored procedures
  • SET NOCOUNT ON
  • Using a result set in an INSERT statement
  • Parameters
  • Executing a procedure with parameters
  • Procedures return a value
  • Setting the return value of a procedure
  • Output parameters
  • Viewing the source code of a stored procedure
  • More procedure DDL

User Defined Functions

  • What are UDFs?
  • Creating UDFs
  • Returning a value from a function
  • Calling a scalar function
  • Table-Valued Functions
  • Calling table valued functions
  • Inline table valued functions
  • Multistatement table valued functions
  • More UDF DDL

Schemas

  • SQL Server schemas
  • Creating a schema
  • Referencing a schema’s objects

Triggers

  • What are triggers?
  • Uses of Triggers
  • Types of trigger
  • What can you do in trigger code?
  • DML triggers
  • DML trigger syntax
  • The inserted and deleted tables
  • The UPDATE()function
  • COLUMNS_UPDATED
  • INSTEAD OF triggers
  • INSTEAD OF trigger rules
  • View Triggers
  • Notes on DML triggers
  • DDL triggers
  • Creating DDL triggers
  • Notes on DDL triggers
  • The EVENTDATA() Function
  • XML returned by EVENTDATA()
  • EVENTDATA() schema definition
  • Logon triggers
  • Finding information on triggers
  • Changing a trigger definition
  • Disabling, enabling and dropping triggers
  • More trigger DDL

Global functions

  • Global Functions
  • @@TRANCOUNT
  • @@IDENTITY
  • @@VERSION
  • SERVERPROPERTY()

Dynamic SQL

  • What is dynamic SQL?
  • Dynamic SQL example
  • Guard against SQL injection

Requirements

This course is for anyone who wants to learn SQL

Career path

These skills could be useful for anyone in a role that requires knowledge of SQL

Questions and answers

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Similar subjects: SQL, Coding
Related searches: Online courses