MENU
Úvod
Kurzy
Developing Microsoft® SQL Server® 2012 Databases
zájem o kurz

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.

Kurz je zařazen v kategoriích: Microsoft Official Course
DatabázeMicrosoft SQLMS SQL 2012/2014
Microsoft

Náročnost kurzu: pokročilý

Délka kurzu: 5 dní

Náplň kurzu:

  • 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

Předpokládané znalosti: 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.

.

Termíny kurzu:

22.10. 26.10.2018 Praha
25 450 Kč (bez DPH)
05.11. 09.11.2018 Bratislava
1 000 EUR (bez DPH)
12.11. 16.11.2018 Brno
25 450 Kč (bez DPH)
12.11. 16.11.2018 Praha 25 450 Kč (bez DPH) objednat
19.11. 23.11.2018 Košice 1 000 EUR (bez DPH) objednat
19.11. 23.11.2018 Ostrava 25 450 Kč (bez DPH) objednat
03.12. 07.12.2018 Brno 25 450 Kč (bez DPH) objednat
03.12. 07.12.2018 Bratislava 1 000 EUR (bez DPH) objednat
10.12. 14.12.2018 Ostrava 25 450 Kč (bez DPH) objednat
10.12. 14.12.2018 Praha 25 450 Kč (bez DPH) objednat
17.12. 21.12.2018 Košice 1 000 EUR (bez DPH) objednat
24.12. 28.12.2018 Bratislava 1 000 EUR (bez DPH) objednat
02.01. 06.01.2019 Brno 25 450 Kč (bez DPH) objednat
07.01. 11.01.2019 Praha 25 450 Kč (bez DPH) objednat
21.01. 25.01.2019 Bratislava 1 000 EUR (bez DPH) objednat