SQL Server Query Writing Essentials
Course Code: SSQWE
Course Duration: 1 Day
Overview
The goal of this course is to provide participants with the
technical skills and knowledge to write Transact-SQL statements for
Microsoft SQL Server. Upon completion, participants will be able to
retrieve and modify data from SQL Server and understand how to
perform these operations whilst maximising query performance.
This course is designed for both SQL Server 2005, 2008 and 2008
R2.
Who Should Attend
This course is designed for individuals who are looking to gain
an understanding of how to write T-SQL queries.
Course Objectives
After completing this course, students will be able to:
- Write SQL Server T-SQL queries to retrieve data
- Understand the performance impact of queries
- Develop queries to be used in reporting solutions
- Update and Insert data into tables
Course Prerequisites
Before attending this course, participants should have:
- A basic understanding of database concepts