Why do we require your location?

It allows us to direct your request to the appropriate Customer Care team.

Preferred method of contact:

Writing SQL Queries with SQL Server Management Studio



Course Number



1 Day

PDF Add to WishList

SQL Server Management Studio helps ease the learning curve of SQL with the Query Designer and Query Window, and is a good starting point for those wanting to learn SQL. In this training course, you learn the basics of SELECT, INSERT, UPDATE, and DELETE statements, and gain the skills to leverage SQL Server Management Studio for graphically designing SQL queries.

You Will Learn How To

  • Leverage SQL Server Management Studio to graphically design SQL queries
  • Write Transact-SQL statements to collect and analyze data
  • Target data retrieval with the WHERE clause
  • Manipulate data with INSERT, UPDATE, and DELETE statements

Important Course Information

  • Prerequisites

    No formal prerequisites are required to attend this course.

Hands-On Experience

  • Selecting simple data sets with Transact-SQL
  • Joining columns from related tables
  • Analyzing aggregated data
  • Changing information in a query window
  • Creating a simple stored procedure

Convenient Ways to Attend This Instructor-Led Course

Live, Online

Private Team Training

Live, Online Instructor-Led

Tuition — Standard: $900   Government: $790

Dec 8 ( 1 Day)
9:00 AM - 4:30 PM EST
Online (AnyWare) Online (AnyWare) Reserve Your Seat

Mar 29 ( 1 Day)
9:00 AM - 4:30 PM EDT
Online (AnyWare) Online (AnyWare) Reserve Your Seat

Jun 28 ( 1 Day)
9:00 AM - 4:30 PM EDT
Online (AnyWare) Online (AnyWare) Reserve Your Seat

Sep 26 ( 1 Day)
9:00 AM - 4:30 PM EDT
Online (AnyWare) Online (AnyWare) Reserve Your Seat

Guaranteed to Run

When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time — will run. Guaranteed.

Private Team Training

Enrolling at least 3 people in this course? Consider bringing this (or any course that can be custom designed) to your preferred location as a private team training.

For details, call 1-888-843-8733 or Click here »

This event has been added to your cart.




In Classroom or





Private Team Training

Contact Us »

Course Tuition Includes:

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

After-Course Computing Sandbox
You'll be given remote access to a preconfigured virtual machine for you to redo your hands-on exercises, develop/test new code, and experiment with the same software used in your course.


Training Hours

Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm

- ,

Chat Now

Please Choose a Language

Canada - English

Canada - Français