go backexam details

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

70-464

Developing Microsoft SQL Server 2012 Databases

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

EXAM OVERVIEW

 

This exam is intended for Database professionals who build and implement databases across the organization, while ensuring high levels of data availability. They perform tasks including creating database files, create data types, tables, plan create and optimize indexes, Implement data integrity, Implement views, stored procedures and functions, manage transactions and locks. Primary responsibilities may include but are not limited to:


  • Optimize and tune queries.
  • Create and alter stored procedures.
  • Create and alter indexes.
  • Maintain database integrity.
  • Optimize indexing strategies.
  • Create and alter tables.
  • Maintain indexes.
  • Create and modify constraints.
  • Create and alter views.
  • Create and alter user-defined functions (UDFs).
  • Control execution plans.
  • Work with XML Data
  • Implement full-text search.
  • Troubleshoot security.
  • Write automation scripts.
  • Troubleshoot performance issues.
Share it:

newsletter subscription

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