Developing SQL Databases provee a los estudiantes los conocimientos y técnicas necesarias para desarrollar una base de datos Microsoft SQL Server 2016.

Requisitos:
Conocimientos de sistemas operativos basados en MS Windows (conectividad, cuentas, NTFS, seguridad) y Transact-SQL. Experiencia en el uso de bases de datos relacionales y diseño de nuevas estructuras. Duración: 40 horas

Temario:
Introduction to Database Development
Introduction to the SQL Server Platform
SQL Server Database Development Tasks
Working with SQL Server Tools
Designing Tables
Using Data Types
Working with Schemas
Creating and Altering Tables
Advanced Table Designs
Partitioning data
Compressing Data
Temporal Tables
Ensuring Data Integrity through Constraints
Enforcing Data Integrity
Implementing Domain Integrity
Implementing Entity and Referential Integrity
Introduction to Indexing
Core Indexing Concepts
Data Types and Indexes
Single Column and Composite Indexes
Designing Optimized Index Strategies
Covering Indexes
Managing Indexes
Execution Plans
Introduction to Columnstore indexes
Creating and Working Columnstore indexes
Introduction to Views
Creating and Managing Views
Performance Considerations for Views
Introduction to Stored Procedures
Designing and Implementing Stored Procedures
Implementing Parameterized Stored Procedures
Controlling Execution Context
Overview of Functions
Designing and Implementing Scalar Functions and Table-Valued Functions
Implementation Considerations for Functions
Alternatives to Functions
Responding to Data Manipulation via Triggers
Designing and Implementing DML Triggers
Advanced Trigger Concepts
Using In-Memory Tables
Native Stored Procedures
Implementing Managed Code in SQL Server
Introduction to SQL CLR Integration
Importing and Configuring Assemblies
Implementing SQL CLR Integration
Introduction to XML and XML Schemas
Storing XML Data and XML Schemas
Using the T-SQL FOR XML Statement
Getting Started with XQuery
Introduction to Spatial Data
Using Spatial Data in Applications
Storing and Querying Blobs and Text Documents in SQL Server
Considerations for BLOB Data
Working with FileStream
Using Full-Text Search
Certificaciones Asociadas:  Microsoft Certified Solutions Associate (MCSA): SQL 2016 Database Development

CursosDuraciónExámenes
20761 - Querying Data with Transact-SQL40 hrs70-761 - Querying Data with Transact-SQL
20762 - Developing SQL Databases40 hrs.70-762 - Developing SQL Databases

Microsoft Certified Solutions Expert (MCSE): Business Intelligence

Certificación anteriorCertificación actualCursosExámenes
MCSA: SQL Server 2012/2014MCSA: SQL 2016 Database Development20762 - Developing SQL Databases70-762 - Developing SQL Databases
MCSA: SQL Server 2012/2014MCSA: SQL 2016 Database Administration20765 - Provisioning SQL Databases70-765 - Provisioning SQL Databases
MCSA: SQL Server 2012/2014MCSA: SQL 2016 Business Intelligence Development20768 - Developing SQL Data Models70-768 - Developing SQL Data Models