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