MENU
Vorwort
Kurse
Developing Microsoft® SQL Server® 2012 Databases
Interesse für den Kurs

Developing Microsoft® SQL Server® 2012 Databases (MOC10776)

This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to implementing a database. This course maps to the skills and knowledge measured by Microsoft Exam 70-464, and in conjunction with on-the-job experience, can help prepare you for the exam.

Der Kurs ist den Kategorien zugeordnet: Microsoft Official Course
DatabázeMicrosoft SQLMS SQL 2012/2014
Microsoft

Kursstufe: Fortgeschritten

Course duration: 5 days

Kursinhalt:

  • Introduction to SQL Server® 2012 and its Toolset
  • Working with Data Types
  • Designing and Implementing Tables
  • Ensuring Data Integrity through Constraints
  • Planning for SQL Server® 2012 Indexing
  • Implementing Table Structures in SQL Server® 2012
  • Reading SQL Server® 2012 Execution Plans
  • Improving Performance through Nonclustered Indexes
  • Designing and Implementing Views
  • Designing and Implementing Stored Procedures
  • Merging Data and Passing Tables
  • Designing and Implementing User-Defined Functions
  • Creating Highly Concurrent SQL Server® 2012 Applications
  • Handling Errors in T-SQL Code
  • Responding to Data Manipulation via Triggers
  • Implementing Managed Code in SQL Server® 2012
  • Storing XML Data in SQL Server® 2012
  • Querying XML Data in SQL Server® 2012
  • Working with SQL Server® 2012 Spatial Data
  • Working with Full-Text Indexes and Queries

Erforderliche Kenntnisse: Knowledge of writing T-SQL queries. Knowledge of basic relational database concepts. Students who attend this training can meet the prerequisites by attending the following courses, or obtaining equivalent knowledge and skills: 10774A: Writing T-SQL Queries for Microsoft SQL Server 2012.

.

Kurstermine:

22.10. 26.10.2018 Praha
25 450 CZK (Ohne MwSt.)
05.11. 09.11.2018 Bratislava
990 EUR (Ohne MwSt.)
12.11. 16.11.2018 Brno
25 450 CZK (Ohne MwSt.)
12.11. 16.11.2018 Praha 25 450 CZK (Ohne MwSt.) Bestellen
19.11. 23.11.2018 Košice 990 EUR (Ohne MwSt.) Bestellen
19.11. 23.11.2018 Ostrava 25 450 CZK (Ohne MwSt.) Bestellen
03.12. 07.12.2018 Brno 25 450 CZK (Ohne MwSt.) Bestellen
03.12. 07.12.2018 Bratislava 990 EUR (Ohne MwSt.) Bestellen
10.12. 14.12.2018 Ostrava 25 450 CZK (Ohne MwSt.) Bestellen
10.12. 14.12.2018 Praha 25 450 CZK (Ohne MwSt.) Bestellen
17.12. 21.12.2018 Košice 990 EUR (Ohne MwSt.) Bestellen
24.12. 28.12.2018 Bratislava 990 EUR (Ohne MwSt.) Bestellen
02.01. 06.01.2019 Brno 25 450 CZK (Ohne MwSt.) Bestellen
07.01. 11.01.2019 Praha 25 450 CZK (Ohne MwSt.) Bestellen
21.01. 25.01.2019 Bratislava 990 EUR (Ohne MwSt.) Bestellen