70-464 Developing Microsoft SQL Server 2012 Databases Ausbildung - OEM Certkit

Das Schulung 70-464 Entwickeln von Microsoft SQL Server 2012-Datenbanken über ein spezielles Zertifizierungspaket. 1 Jahr Zugang zu revolutionärem E-Learning, um die Prüfung problemlos zu bestehen. Machen Sie sich mit dem Lernen über 1 Learning Portal (LMS) mit zertifizierten Lehrern vertraut. Exklusive Online-Mentoren rund um die Uhr und anspruchsvolle Kurstests und hinter den Kulissen Alle Tipps und Tricks anzeigen.
Garantiert immer die offizielle Testprüfung und eine offizielle Teilnahmebescheinigung nach dem Training. Optionale Livelabs (zusätzliche Kosten).

Kursinhalt

SQL Server 2012 – Developing Databases: Implementing Tables (Update Avail.)

Course: 1 Hour, 48 Minutes

• Designing Tables and Data Integrity in SQL Server 20122
• Using Data Types in SQL Server 20122
• Creating Tables in SQL Server 2012

SQL Server 2012 – Developing Databases: Implementing Indexes (Update Avail.)

Course: 1 Hour, 31 Minutes

• Designing an Index Strategy in SQL Server 2012
• Designing Effective Indexes in SQL Server 2012
• Creating Indexes in SQL Server 2012

SQL Server 2012 – Developing Databases: Stored Procedures (Update Avail.)

Course: 1 Hour, 30 Minutes

• Designing Stored Procedures in SQL Server 2012
• Creating Stored Procedures in SQL Server 2012
• Using Table Valued Parameters in SQL Server 2012

SQL Server 2012 – Developing Databases: CLR Integration (Update Avail.)

Course: 1 Hour, 30 Minutes

• Overview of CLR Integration in SQL Server 2012
• Implementing CLR Functions and Types in SQL Server 2012
• Implementing SQL CLR Stored Procedures and Triggers

SQL Server 2012 – Developing Databases: Working with Data (Update Avail.)

Course: 1 Hour, 42 Minutes

• Overview of CLR Integration in SQL Server 2012
• Implementing CLR Functions and Types in SQL Server 2012
• Implementing SQL CLR Stored Procedures and Triggers

SQL Server 2012 – Developing Databases: Working with XML Data (Update Avail.)

Course: 1 Hour, 49 Minutes

• XML Schemas and Namespaces in SQL Server 2012
• Using XML Data Types and Schemas in SQL Server 2012
• Implementing XML Indexes in SQL Server 2012

SQL Server 2012 – Developing Databases: Optimizing Queries (Update Avail.)

Course: 1 Hour, 30 Minutes

• Analyze Queries using SQL Server Profiler and DTA
• Using Execution Plans to Optimize Queries
• Identifying and Resolving Locks in SQL Server 2012
• Using Extended Events in SQL Server 2012
• Optimizing and Tuning SQL Server 2012 Queries

SQL Server 2012 – Developing Databases: Troubleshooting (Update Avail.)

Course: 1 Hour, 30 Minutes

• Managing Databases using Automation in SQL Server 2012
• Troubleshooting Server Issues for SQL Server 2012

Microsoft SQL Server 2014 - Developing Databases: New Features

Course: 2 Hours, 6 Minutes

• Course Introduction
• Creating In-Memory OLTP Tables in SQL Server 2014
• Troubleshooting In-Memory OLTP in SQL Server 2014

Microsoft SQL Server 2012 – Developing Databases: Implementing Tables and Views

Course: 1 Hour, 48 Minutes

• Monitoring In-Memory OLTP Resources in SQL Server 2014
• Automating Backups using Scripts in SQL Server 20144
• Designing Tables and Data Integrity in SQL Server 201223
• Using Data Types in SQL Server 2012
• Creating Tables in SQL Server 2012

Microsoft SQL Server 2012 – Developing Databases: Implementing Indexes

Course: 1 Hour, 31 Minutes

• Designing an Index Strategy in SQL Server 2012
• Designing Effective Indexes in SQL Server 2012
• Creating Indexes in SQL Server 2012

Microsoft SQL Server 2012 – Developing Databases: Stored Procedures

Course: 1 Hour, 18 Minutes

• Designing Stored Procedures in SQL Server 2012
• Creating Stored Procedures in SQL Server 2012
• Using Table Valued Parameters in SQL Server 2012

Microsoft SQL Server 2012 – Developing Databases: CLR Integration

Course: 1 Hour, 11 Minutes

• Overview of CLR Integration in SQL Server 2012
• Implementing CLR Functions and Types in SQL Server 2012
• Implementing SQL CLR Stored Procedures and Triggers

Microsoft SQL Server 2012 – Developing Databases: Working with Data

Course: 1 Hour, 42 Minutes

• Using FILESTREAM and FileTables in SQL Server 2012
• Using FileTables in SQL Server 2012
• Implementing Full-Text Search in SQL Server 2012
• Using Full-Text Search in SQL Server 2012
• Using Semantic Search in SQL Server 2012

Microsoft SQL Server 2012 – Developing Databases: Working with XML Data

Course: 1 Hour, 49 Minutes

• XML Schemas and Namespaces in SQL Server 2012
• Using XML Data Types and Schemas in SQL Server 2012
• Implementing XML Indexes in SQL Server 2012

Microsoft SQL Server 2012 – Developing Databases: Tuning and Optimizing Queries

Course: 1 Hour, 30 Minutes

• Analyze Queries using SQL Server Profiler and DTA
• Using Execution Plans to Optimize Queries
• Identifying and Resolving Locks in SQL Server 2012
• Using Extended Events in SQL Server 2012
• Optimizing and Tuning SQL Server 2012 Queries

Microsoft SQL Server 2012 – Developing Databases: Managing and Troubleshooting

Course: 1 Hour, 30 Minutes

• Managing Databases using Automation in SQL Server 2012
• Troubleshooting Server Issues for SQL Server 2012