SSQWE SQL Server Query Writing Essentials

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 all SQL Server versions.

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