Querying Microsoft SQL Server with Transact-SQL

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

Course description

The Querying Microsoft SQL Server with Transact-SQL course covers the basics of the SQL language as implemented by Microsoft SQL Server.  The course is designed to give delegates practical experience in writing Transact-SQL statements using the SQL Server Management Studio (SSMS) development environment.  The basic Transact-SQL statements, including the use of many built-in Transact-SQL functions are covered on this course.  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

Who will the Course Benefit?

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

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