Programming with Transact-SQL

Impartica IT Training
5.0
2 reviews
  • Highly recommended, gave good insight into T-SQL and its real world usage.
    ← | →
  • Overall, the course was well-structured and difficulty rises in line you’re your own knowledge. My instructor knew very well the subject and was happy to answer all my inquiries, and he made sure that I was completely sure of my understanding of each topic before moving on. I would certainly take more courses with my trainer and recommended them to my employers.
    ← | →

Course

In Manchester, London and Shadwell

£ 650 VAT inc.

The best SQL Server courses

See all

See all

Description

  • Duration

    2 Days

Transact-SQL (or T-SQL) is Microsoft’s (and Sybase’s) proprietary extension to SQL. This Transact-SQL training 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.

Facilities

Location

Start date

London
See map
164-180 Union Street, Waterloo, SE1 0LH

Start date

On request
Manchester (Cheshire)
See map

Start date

On request
Shadwell (West Yorkshire)
See map

Start date

On request

Start date

On request

About this course

A working level of basic SQL (SELECT, INSERT, UPDATE and DELETE statements) is assumed. Delegates without this experience should consider the Introduction to SQL course.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

5.0
  • Highly recommended, gave good insight into T-SQL and its real world usage.
    ← | →
  • Overall, the course was well-structured and difficulty rises in line you’re your own knowledge. My instructor knew very well the subject and was happy to answer all my inquiries, and he made sure that I was completely sure of my understanding of each topic before moving on. I would certainly take more courses with my trainer and recommended them to my employers.
    ← | →
100%
4.7
excellent

Course rating

Recommended

Centre rating

Gibbo

5.0
19/01/2017
What I would highlight: Highly recommended, gave good insight into T-SQL and its real world usage.
What could be improved: .
Would you recommend this course?: Yes

Adam Biggins

5.0
15/04/2016
What I would highlight: Overall, the course was well-structured and difficulty rises in line you’re your own knowledge. My instructor knew very well the subject and was happy to answer all my inquiries, and he made sure that I was completely sure of my understanding of each topic before moving on. I would certainly take more courses with my trainer and recommended them to my employers.
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

Subjects

  • SQL
  • Programming
  • Server
  • Global
  • Options
  • Transact-SQL
  • Transact SQL
  • T-SQL
  • Microsoft
  • Database
  • NET
  • Object oriented

Course programme

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

See related categories

Programming with Transact-SQL

£ 650 VAT inc.

The best SQL Server courses

See all

See all