Advanced Querying Microsoft SQL Server with Transact-SQL

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

Course description

The Advanced Querying Microsoft SQL Server with Transact-SQL course is designed to give delegates practical experience in using more complex Transact-SQL techniques. This course covers Microsoft SQL Server up to version 2016.

The delegate will learn and acquire skills as follows:

  • Creating and using Views
  • Using table expressions
  • Enhanced Grouping and Pivoting Data
  • Using Windowing ranking, offset and ranking functions
  • Creating and using Stored Procedures
  • Controlling Program Flow
  • Using Dynamic SQL
  • Implementing Error Handling
  • Improving Query Performance

Who will the Course Benefit?

IT Professionals and non-technical 'power users' who are required to implement more complex Transact-SQL queries.

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