Home
Courses
Writing SQL Queries with SQL Server Management Studio

Writing SQL Queries with SQL Server Management Studio

Course 4550

Duration: 1 day
Labs: Yes
Language: English
Level: Foundation

This SQL Server Management Studio course will teach you to write SQL queries and learn the basics of SELECT, INSERT, UPDATE, and DELETE statements. 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. Learn to leverage all it has to offer in this intensive 1-day course.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.

No formal prerequisites are required to attend this course.

Writing SQL Queries with SQL Server Management Studio Delivery Methods

Attend online, in person, or bring this course to your facility
After-course instructor coaching

Writing SQL Queries with SQL Server Management Studio Course Benefits

Leverage SQL Server Management Studio to graphically design SQL queriesWrite Transact-SQL statements to collect and analyze dataTarget data retrieval with the WHERE clauseManipulate data with INSERT, UPDATE, and DELETE statements

SQL Server Management Studio Course Outline

Outline

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

Get This Course £690

1-day instructor-led training course
One-on-one after-course instructor coaching
Tuition can be paid later by invoice -OR- at the time of checkout by credit card

Include dates with afternoon start times

#4550

Guaranteed to Run - you can rest assured that the class will not be cancelled.
Dec 18 2:00 PM - 9:30 PM GMT

Virtual
Jan 20 9:00 AM - 4:30 PM GMT

Virtual
Feb 11 2:00 PM - 9:30 PM GMT

Virtual
Mar 13 1:00 PM - 8:30 PM GMT

Virtual
Apr 22 9:00 AM - 4:30 PM BST

Virtual
Apr 23 2:00 PM - 9:30 PM BST

Virtual
Jun 23 2:00 PM - 9:30 PM BST

Virtual
Jul 21 9:00 AM - 4:30 PM BST

Virtual
Jul 23 2:00 PM - 9:30 PM BST

Virtual
Sep 3 2:00 PM - 9:30 PM BST

Virtual
Oct 20 9:00 AM - 4:30 PM BST

Virtual

Scroll to view additional course dates

Bring this or any training to your organization
Full - scale program development
Delivered when, where, and how you want it
Blended learning models
Tailored content
Expert team coaching

#4550

Questions about this course?

Customise Your Team Training Experience

Fill out the form below or call 44 (0) 207 874 5000

* Required Fields

Preferred method of contact:

Phone

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

Course FAQs

SQL Server Management Studio benefits you to learn SQL more efficiently by using Query Designer and Query Window.

Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs wherever you want, including online training.