Inhoud ICT-cursus 70-464 Developing Microsoft SQL Server 2012 Databases

Inhoud van de ICT-cursus 70-464 Developing Microsoft SQL Server 2012 Databases | De Kantooropleider

Tijdens de ICT-cursus 70-464 Developing Microsoft SQL Server 2012 Databases worden de volgende onderdelen behandeld:

Implementing Indexes

  • determine the most appropriate index type to use in a given scenario
  • identify how to optimize index performance
  • describe how to manage indexes in a given scenario
  • identify how to maintain indexes in a given scenario
  • identify how to repair fragmented indexes
  • create and maintain indexes in SQL Server

Stored Procedures

  • identify the characteristics of stored procedures
  • identify how to manage stored procedures in a given scenario
  • recognize the advantages of using table-valued parameters
  • differentiate between table-valued and scalar functions
  • identify the considerations for using a multi-statement table-valued function
  • create and use different types of tables and views in a given scenario

CLR Integration

Determine the most appropriate CLR function to use in a given scenario choose the most appropriate partial command to use in a given scenario identify how to implement triggers identify the type of transaction being used in a given scenario use the CLR and maintain database integrity with transactions in SQL Server 2012.

Working with Data

  • configure FILESTREAM in SQL Server 2012
  • recognize how to manage SQL Server 2012 FileTables in a given scenario
  • create a full-text index in a given scenario
  • describe how to use Full-Text Search to do searches on character-based data
  • recognize how to use Semantic Search to identify key phrases in unstructured data
  • describe how to manipulate data using query techniques in a given scenario
  • identify the considerations involved in creating spatial indexes
  • use SQL Server 2012 features to manage, search and manipulate data

Working with XML Data

  • Describe the advantages of using XML data storage in SQL Server 2012
  • Identify how to work with XML data in a given scenario
  • Describe the characteristics of XML indexes in SQL Server 2012
  • Recognize how to query relational data as XML in SQL Server 2012
  • Recognize how to query XML data using XQuery() in SQL Server 2012
  • Describe how to shred XML data in SQL Server 2012
  • Store and query XML data in SQL Server 2012

Tuning and Optimizing Queries

Differentiate between tools for analyzing queries recognize the functions of DMVs determine the most appropriate transaction isolation level to used in a certain situation identify sources where Extended Events correlate data from troubleshoot poorly performing applications in a database.

Managing and Troubleshooting

Identify methods for scheduling a job describe a method to shrink a database describe the advantages of encrypting data describe the advantages of using change data capture design, implement, and troubleshoot security, troubleshoot and resolve performance problems, design tables, create and alter tables (complex statements).

TestPrep 70-464 Developing Microsoft SQL Server Databases

  • TestPrep 70-464 Developing Microsoft SQL Server Databases
Print pagina