go backexam details

αναλυτικές πληροφορίες εξέτασης


Querying Microsoft SQL Server 2012

SQL Server Version : 2012
Απευθύνεται σε : IT Professionals, Developers



This exam 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.
Share it: