T-SQL Programming with SQL Server

Programming with Transact SQL (T-SQL)

• About Batches, Statement Blocks and Procedures
• SQL Server Programming Objects
• Transact-SQL procedural extensions

Working with Views

• Views Explained
• Advantages of Views
• Creating Views
• Dropping Views
• Modifying and Updating data with Views

Variables and Temporary Tables

• The System Global Variables
• Local Variables and Data Types
• Declaring Local Variables
• Assigning Values to Local Variables
• Working with Temporary Tables
• Using Table Variables
• Table Variables vs Temporary Tables

Using Control of Flow Statements

• Marking Code Blocks with BEGIN and END
• Conditional Processing with IF...ELSE and GOTO
• Using WHILE to Execute Statements Repeatedly
• Using Break and RETURN to Exit Blocks and Procedures

Working with Cursors

• About Cursors
• ANSI and T-SQL Cursors
• Declaring Cursors
• Using Cursors

Developing Stored Procedures

• About Stored Procedures
• Stored Procedure Usage and Benefits
• Creating Stored Procedures
• Executing Stored Procedures
• Passing values into Stored Procedures
• Returning Data from Stored Procedures
• Editing Stored Procedures
• Building and Using User Defined Functions

Error Handling

• Intercepting Errors with TRY ... CATCH
• Obtaining Error Information
• Using Error Functions
• Responding to Errors

Transaction Processing

• Introducing Transactions
• Understanding Transaction Processing
• Transactions and the SQL Server Log
• Setting Up a Transaction Environment
• Using ROLLBACK and Creating Save Points
• Using Locks
• Handling Transaction Errors
• Committing Transactions
• Transaction Tips

Enforcing Data Integrity with DML Triggers

• Introducing Triggers
• When to use Triggers
• Types of Triggers: INSERT, DELETE, UPDATE, INSTEAD OF
• Combining Trigger Types
• Reporting Errors

On Site Requirements

Remember, we provide all equipment and software required to deliver a course at your premises. Aside from this, we need a suitably quiet and equipped room with enough work space for each attendee and a whiteboard or flipchart. Most courses involve the use of a PC projector and we bring our own. But either a projector screen, or usually just a clear wall, would be very helpful.

Other Courses to Consider

• TSQ-63: Querying SQL Server with Transact SQL (T-SQL)
  For those needing to use T-SQL to extract data from SQL Server (Action queries which modify data or objects not included).
• TSQ-64: Introduction to Transact SQL (T-SQL)
  Using T-SQL to extract data from, and update data in, SQL Server (for developers and end users).
• TSQ-65: A Foundation in Transact SQL (T-SQL)
  Developing Transact-SQL (T-SQL) solutions which extract data from, and manipulate data (and database objects) in, Microsoft SQL Server.

on site training courses available in:  

• London
• , Birmingham
• , Edinburgh
• , Manchester
• , Scotland
• , Glasgow
• , Nottingham
• , Midlands
• , Bristol
• , Wales
• , Cardiff
• , Dublin
• , Belfast
• , Leeds
• , Liverpool
• , Sheffield
• , Reading
• , Oxford
• , Cambridge
• , Southampton
• , Newcastle
• , Durham
• , Warrington.

and across the UK and Ireland