Menu
Live Chat
Contact Us
Scheduling Tool
888-843-8733
 

Home ❯ SQL Server

PDF Add to WishList









Preferred method of contact:

Writing SQL Queries with SQL Server Management Studio

COURSE TYPE

Foundation

Course Number

4550

Duration

1 Day
Reserve Your Seat

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

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

Hassle-Free Enrolment: No advance payment required to reserve your seat.
Tuition due 30 days after you attend your course.

Live, Online

Private Team Training

888-843-8733

info@LearningTree.ca

Live Chat

Live, Online Instructor-Led

Tuition — Standard: $900   Government: $790

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

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

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

Jan 7 ( 1 Day)
9:00 AM - 4:30 PM EST 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, location — 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.

Tuition

Standard

Government

In Classroom or
Online

Standard

$900

Government

$790

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.

Prev
Next

Training Hours

Standard Course Hours:9:00 am – 4:30 pm


FREE Online Course Exam (if applicable) – Last Day:3:30 pm – 4:30 pm


By successfully completing your FREE online course exam, you will:

  • Earn College Credit Units — Many Learning Tree courses are recommended for College Credits, which are accepted by over 2,000 colleges and universities, and may qualify you to receive Tuition Reimbursement.
  • Receive a Certificate of Achievement with the designation "Awarded with Distinction."

Each Course Day - Informal discussion with instructor about your projects or areas of special interest:4:30 pm – 5:30 pm

- ,

Prev
Next
Chat Now

Please Choose a Language

Canada - English

Canada - Français