Programming Microsoft SQL Server with Transact-SQL

Focus on Training
Course summary
Next available date: - United Kingdom
Professional Training

Course description

The Programming Microsoft SQL Server with Transact-SQL SQL training course introduces the delegate to the programming features of the Transact-SQL programming language,  using Microsoft SQL Server. This course looks at the procedural programming language capabilities of T-SQL. The delegate will learn how to use local variables,  write program flow control constructs, create stored procedures and triggers, handle errors and use built-in functions.

The delegate will learn and acquire skills as follows:

  • Declaring and using variables
  • Using conditional programming logic
  • Implementing conditional execution and loop constructs
  • Using cursors to process records
  • Trapping and handling errors and exceptions in code
  • Creating stored procedures
  • Creating user defined functions
  • Creating triggers
  • Using dynamic SQL

Who will the Course Benefit?

Software development personnel and database support staff who need to write Transact-SQL scripts to enhance their productivity in manipulating data.

About provider

Focus on Training: Best Practice Skills from the Specialists

Focus on Training is a professional training company specialising in offering accredited Project Management and IT programmes. With over 10,000 courses offered in over 100 locations throughout the United Kingdom, Focus is a premier training provider. All programmes can be booked online...

Read more and show all courses with this provider

Contact info

Focus on Training

Olympus House, Werrington Centre
PE4 6NA Peterborough

 Show phone number

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here