20762 – Developing Microsoft SQL Databases

A Distancia    On Demand

Objetivo: Este curso 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

 

Ver calendario

 

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

24 octubre, 2016

Empower

La misión de Ulearn es brindar soluciones de capacitación para profesionales de TI, que se traduzca en optimización de sus habilidades para una mayor eficiencia.

mail [email protected]
tel
+598 98 410 014

Redes Sociales

linkedin