Group Size
3 Months
Skill Level
Course Brochure
Download here
Apply Form
Download here

Course Description

This course is intended for SQL Server database administrators, implementers, system engineers, and developers. with two or more years of experience, who are seeking to prove their skills and knowledge in writing queries. Primary responsibilities may include but are not limited to:

  • Apply built-in scalar functions.
  • Apply ranking functions.
  • Combine datasets.
  • Create and alter DML triggers.
  • Create and alter indexes.
  • Create and alter stored procedures.
  • Create and alter tables.
  • Create and alter user-defined functions (UDFs).
  • Create and alter views.
  • Create and modify constraints.
  • Design T-SQL stored procedures.
  • Design views.
  • Implement aggregate queries.
  • Implement data types.
  • Implement error handling.
  • Implement subqueries.
  • Implement the sequence generator
  • Manage transactions.
  • Modify data by using INSERT, UPDATE, and DELETE statements.
  • Modify data by using MERGE statements.
  • Optimize queries.
  • Query  and Manage XML data.
  • Query data by using SELECT statements.
  • Return data by using the OUTPUT clause.

Teachers / Speakers

Sany Asrat

Did you see these?

You might be interested in these courses as well: