Examen 70-461: Querying Microsoft SQL Server 2012

Microsoft

Exam 70-461: Querying Microsoft SQL Server 2012: counts as credit toward the following certifications:

MCSA: SQL Server 2012
MCSE: Data Platform
MCSE: Business Intelligence

Voorbereiding / Training

Doelgroep

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

Categorie

Overige

Tarief

 195,00 *
Exclusief € 28,00 reserverings- en servicekosten indien u wel bij ons uw examen boekt, maar niet de bijbehorende training bij ons volgt.

Certificering / traject

Microsoft MCSA certificering
Microsoft MCSE certificering

Inschrijven

  • You may be tested on other skills and topics related to the objective that are not explicitly listed here.
  • This list is subject to change at any time without prior notice and at the sole discretion of Microsoft

Create Database Objects (24%)

  • Create and alter tables using T-SQL syntax (simple statements).
  • Create and alter views (simple statements).
  • Design views.
  • Create and modify constraints (simple statements).
  • Create and alter DML triggers.

Work with Data (27%)

  • Query data by using SELECT statements.
  • Implement sub-queries.
  • Implement data types.
  • Implement aggregate queries.
  • Query and manage XML data.

Modify Data (24%)

  • Create and alter stored procedures (simple statements).
  • Modify data by using INSERT, UPDATE, and DELETE statements.
  • Combine datasets.
  • Work with functions.

Troubleshoot & Optimize (25%)

  • Optimize queries.
  • Manage transactions.
  • Evaluate the use of row-based operations vs. set-based operations.
  • Implement error handling.

Zie ook de Learning Catalog van Microsoft voor eventuele aanvullingen op de inhoud van dit examen.

Categorie

Overige

Tarief

 195,00 *
Exclusief € 28,00 reserverings- en servicekosten indien u wel bij ons uw examen boekt, maar niet de bijbehorende training bij ons volgt.

Certificering / traject

Microsoft MCSA certificering
Microsoft MCSE certificering

Inschrijven