Course Summary
Credit Type:
Self-paced, 18 hours
Dates Offered:
Credit Recommendation & Competencies
Level Credits (SH) Subject
Lower-Division Baccalaureate 1 Relational Databases or Sql


The course objective is to help prepare learners for the Microsoft SQL Server 2016: Querying (70-761) certification exam.

Learning Outcomes:

  • Configure T-SQL statements in SQL Server 2016
  • Create T-SQL variables
  • Work with T-SQL control of flow, errors, and transactions
  • Use T-SQL comments and batch separators
  • Use SELECT statements in SQL Server 2016 to query tables and views and manipulate data
  • Work with various clauses with SELECT statements including ORDER BY, TOP, OFFSET, and FETCH
  • Write queries using various SQL Server built-in functions
  • Use aggregate functions such as SUM, MIN, MAX, AVG, and COUNT, as well as the GROUP BY clause
  • Use and create stored procedures
  • Use database programmability objects
  • Change a table-valued expression into another table using the PIVOT and UNPIVOT operators
  • Write subqueries and correlated subqueries
  • Use set operators including UNION, INTERSECT, EXCEPT and APPLY
  • Demonstrate how to input and output parameters in SQL 2016

General Topics:

  • T-SQL querying
  • Querying and manipulating data
  • Filter and modify data in SQL Server 2016
  • Using functions in SQL Server 2016
  • Aggregating data in SQL Server 2016
  • Subqueries and predicate
  • Operators and expressions in SQL Server 2016
  • Database programmability objects and non-relational data
Instruction & Assessment

Instructional Strategies:

  • Computer Based Training
  • Practical Exercises

Methods of Assessment:

  • Examinations
  • Quizzes

Minimum Passing Score:

Supplemental Materials