Microsoft SQL Server with Transact-SQL

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

Course description

The Microsoft SQL Server with Transact-SQL course covers the basics of the SQL language and more as implemented by Microsoft SQL Server.  The course is designed to give delegates practical experience in writing Transact-SQL statements by hand using the SQL Server Management Studio (SSMS) development environment.  The basic Transact-SQL statements, including the use of many built-in Transact-SQL functions will be covered along with  more advanced coding techniques required by Database Administrators, Database Developers and BI professionals.  This course covers Microsoft SQL Server up to version 2016.

The delegate will learn and acquire skills as follows:

  • Writing SELECT queries
  • Sorting and filtering data
  • Using SQL aggregate functions
  • Using SET operators
  • Writing joins to query multiple tables
  • Using built-in functions
  • Using Subqueries
  • Inserting, updating, deleting and merging rows
  • Transaction control
  • 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?

Anyone who needs to access and work with a Microsoft SQL Server Database up to version 2016.

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