Introducción a Microsoft SQL Server 2016
Working with SQL Server Management Studio / Creating and Organizing T-SQL Scripts

Introducción a T-SQL Querying
Executing Basic SELECT Statements / Executing Queries that Filter Data using Predicates

Escribiendo consultas SELECT
Writing Simple SELECT Statements / Eliminating Duplicates with DISTINCT

Consultando Tablas Múltiples
Understanding Joins / Querying with Inner Joins and Outer Joins

Ordenar y filtrar datos
Sorting Data / Filtering Data with Predicates, TOP and OFFSET-FETCH

Trabajando con tipos de datos de SQL Server 2016
SQL Server 2016 Data Types / Working with Character Data, Date and Time Data

Usando DML para modificar data
Inserting Data / Modifying and Deleting Data

Uso de funciones incorporadas
Writing Queries with Built-In Functions / Conversion Functions and Logical Functions

Agrupando y Agregando Data
Aggregate Functions, the GROUP BY Clause / Filtering Groups with HAVING

Usando subqueries
Writing Self-Contained / Using the EXISTS Predicate with Subqueries

Usando expresiones de tabla
Using Views / Using Inline Table-Valued Functions and Derived Tables

Usando Operadores Set
Writing Queries with the UNION operator / Using EXCEPT, INTERSECT and APPLY

Conjuntos de pivote y agrupación
Writing Queries with PIVOT and UNPIVOT / Working with Grouping Sets

Ejecutando Stored Procedures
Querying Data with Stored Procedures / Creating Simple Stored Procedures

Implementando transacciones
Transactions and the database engines / Controlling transactions

Seguridad SQL Server:
Authenticating Connections to SQL Server
Authorizing Logins to Connect to databases / Authorization Across Servers

Asignando Servidor y Roles de Bases de Datos
- Working with server roles / Working with Fixed Database Roles 

Autorizando usuarios para acceso a recursos:
- Authorizing User Access to Objects
- Authorizing Users to Execute Code and Configuring Permissions at the Schema Level

Protegiendo Data con Encriptación y auditoría:
- Options for auditing data access in SQL Server
- Implementing SQL Server Audit and Managing SQL Server Audit

Modelos de recuperación y estrategias de copia de seguridad:
- Understanding Backup Strategies / - SQL Server Transaction Logs and Planning Backup Strategies

Backing Up en Bases de Datos SQL Server
- Backing Up Databases and Transaction Logs and Managing Database Backups

Restaurando bases de datos SQL Server:
- Understanding the Restore Process / - Restoring Databases and Advanced Restore Scenarios

Configurando Seguridad para SQL Server Agent:       
- Understanding SQL Server Agent Security / - Configuring Credential and Configuring Proxy Accounts

Monitoreando SQL Server con Alertas y Notificaciones:
- Monitoring SQL Server Errors / Configuring Database Mail
- Operators, Alerts, and Notifications and Alerts in Azure SQL Database

Introducción al Manejo de SQL Server usando PowerShell:
- Getting Started with Windows PowerShell
- Administering and Maintaining SQL Server with PowerShell

Rastreo de acceso a SQL Server con eventos extendidos:
- Extended Events Core Concepts / - Working with Extended Events

Troubleshooting de SQL Server:
- A TroubleShooting Methodology for SQL Server / Resolving Service Related Issues

Importando y exportando Data:
- Transferring Data to and from SQL Server / Importing and Exporting Table Data and Using bcp and BULK INSERT to Import Data