go backexam details

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

70-461

Querying Microsoft SQL Server 2012

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

EXAM OVERVIEW

 

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:

newsletter subscription

Εάν επιθυμείτε να λαμβάνετε ενημέρωση από εμάς, δώστε μας το e-mail σας.
PASS chapter logo
Official Professional Association for SQL Server (PASS) chapter for Greece
Join to PASS