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áze → Microsoft SQL → MS SQL 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:
Tento kurz již není v naší nabídce. Pro více informací nebo máte-li zájem o realizaci nás kontaktujte na skoleni@pcdir.cz nebo telefonu +420 543 533 610.