Cart 0

Writing SQL Queries with SQL Server Management Studio
Course 4550
1 DAY COURSE

Course Outline

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 Benefits

  • 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

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
Course Dates
Attendance Method
Note about the Certification Exam

When you register for the course, you will be prompted to choose Y/N to take the exam. Please select yes, as all HHS CISO employees are required to attempt the exam if one is offered for the course. Please be advised, if your course if funded by DIR, the Certification Organization has agreed to provide DIR the pass/fail status of your exam. DIR will only share this information in an aggregated report to state leadership that reflects total exam pass or fails. No individual names of any students will be included in any reports.

DIR requires that you submit the request for your exam voucher within one month of the last day of your course. DIR requires that you take your exam within six months of the last day of your course.

Additional comments or questions (optional)