70-464: Developing Microsoft SQL Server 2012 Databases

In de online cursus 70-464: Developing Microsoft SQL Server 2012 Databases van Sinteno leer je database oplossingen te ontwerpen en te implementeren op basis van SQL Server 2012. Ook leer je hoe je tabellen, views en indexes kunt implementeren. Daarnaast komen ook nog belangrijke onderwerpen aan bod om te leren werken met XML data, Stored Procedures en het optimaliseren van queries.

Onderwerpen die onder andere aan bod komen zijn tabellen & views, indexes, stored procedures, CLR integratie, filestream configuratie, data manipulatie, XML Data, het optimaliseren van queries en nog veel meer.

Doelgroep

Netwerkbeheerder, Databasebeheerder

Let op: Deze training blijft wel bestaan maar de mogelijkheid om het bijbehorende examen af te leggen is per 31 januari 2021 komen te vervallen. 
Een groot aantal Microsoft trajecten zijn namelijk aan het veranderen. Veel MCSA en MCSE trajecten maken plaats voor Role-Based trajecten.

De vervanger van deze online training is nog niet bekend.

Resultaat

Je kunt zelfstandig database oplossingen ontwerpen en implementeren op basis van SQL Server 2012. Tevens ben je voorbereid op het MCSE examen 70-464.

Voorkennis

Je beschikt over de volgende voorkennis:

• Kennis met het schrijven van T-SQL queries
• Kennis van relationele database concepten

Deze kennis wordt behandeld in de cursus Querying Microsoft SQL Server 2012 (exam 70-461)

Inhoud

Tijdens de online cursus 70-464: Developing Microsoft SQL Server 2012 Databases worden de volgende onderwerpen 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

Inbegrepen

Duur

21 uur

Beschikbare taal

Engels

Online toegang

6 maanden

Home

• 
• Buffer
• Pin It