Describa el diseño de tablas lógicas, la indexación y los planos de consulta. También se centra en la creación de objetos de base de datos que incluyen vistas, procedimientos almacenados, junto con parámetros y funciones.
Describe the design of logical tables, indexing, and query planes. It also focuses on creating database objects that include views, stored procedures, along with parameters and functions. Other common aspects of procedural coding, such as indexes, concurrency, error handling, and triggers are also covered in this course. Also, this course helps you prepare for the 70-464 exam.
Minimum 3 participants to attend the course.
Lab : Introduction to Database Development
Lab : Designing and Implementing Tables
Lab : Ensuring Data Integrity through Constraints
Lab : Implementing Indexes
Lab : Designing Optimized Index Strategies
Lab : Using Columnstore Indexes
Lab : Designing and Implementing Views
Lab : Designing and Implementing Stored Procedures
Lab : Designing and Implementing User-Defined Functions
Lab : Responding to Data Manipulation via Triggers
Lab : In-Memory OLTP
Lab : Implementing Managed Code in SQL Server 2014
Lab : Storing and Querying XML Data in SQL Server 2014
Lab : Working with SQL Server Spatial Data
Lab : Implementing a Solution for Storing Data Files
10 Students
40 Hours
US$920