Objetivo: Este curso provee a los estudiantes los conocimientos y técnicas necesarias para implementar bases de datos con Microsoft SQL Server 2012 o 2014.

Requisitos: Conocimientos de sistemas operativos basados en MS Windows (conectividad, cuentas, NTFS, seguridad). Experiencia en el uso de bases de datos relacionales y diseño de nuevas estructuras.

Duración: 40 horas

Temario:

  • Introduction to the SQL Server Platform
  • Working with SQL Server Tools
  • Configuring SQL Server Services
  • Using Data Types
  • Working with Character Data
  • Designing Tables
  • Working with Schemas
  • Creating and Altering Tables
  • Ensuring Data Integrity through Constraints
  • Enforcing Data Integrity
  • Implementing Domain Integrity
  • Implementing Entity and Referential Integrity
  • Introduction to Indexing
  • Core Indexing Concepts
  • Single Column and Composite Indexes
  • Implementing Table Structures in SQL Server
  • Working with Clustered Indexes
  • Working with Nonclustered Indexes
  • Advanced Indexing
  • Working with Execution Plans
  • Performance Monitoring
  • In-Memory Database Capabilities
  • 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 DML Triggers
  • 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
  • Implementing XML Indexes
  • Using the T-SQL FOR XML Statement
  • Getting Started with XQuery
  • Shredding XML
  • Introduction to Spatial Data
  • Working with SQL Server Spatial Data Types
  • Using Spatial Data in Applications
  • Incorporating Data Files into Databases
  • Considerations for Working with Data Files
  • Implementing FILESTREAM and FileTables
  • Searching Data Files
  • Crear tipos de datos y tablas.
  • Utilizar características XML de Microsoft SQL Server.
  • Planificar, crear y optimizar índices.
  • Implementar integridad en los datos con Microsoft SQL Server.
  • Implementar vistas.
  • Implementar procedimientos almacenados y funciones.
  • Implementar managed code en la base de datos.
  • Manejar transacciones.
  • Consultar datos XML en SQL Server.