MCSA Administración de Microsoft SQL Server 2016

Cas Training
Precio

Precio a consultar

Impartición

Máster en Madrid

Objetivos

Objetivos de la Certificación MCSA 70-764: Administering a SQL Database Infrastructure 70-765: Provisioning SQL Databases

A quién va dirigido

• Personas con conocimientos en Informática. • Formación Profesional. • Titulados Universitarios. • Profesionales del sector IT que deseen actualizar sus conocimientos.

Requisitos

 Conocimiento básico del sistema operativo Microsoft Windows y su funcionalidad básica.  Conocimiento práctico de Transact-SQL.  Conocimiento práctico de las bases de datos relacionales.  Alguna experiencia con el diseño de la base de datos

Sedes

Madrid

Temario completo de este curso

MOC 20764-ADMINISTERING A SQL DATABASE INFRASTRUCTURE

SQL Server Security

-          Authenticating Connections to SQL Server

-          Authorizing Logins to Connect to databases

-          Authorization Across Servers

-          Partially Contained Databases

Assigning Server and Database Roles

-          Working with server roles

-          Working with Fixed Database Roles

-          Assigning User-Defined Database Roles

Authorizing Users to Access Resources

-          Authorizing User Access to Objects

-          Authorizing Users to Execute Code

-          Configuring Permissions at the Schema Level

Protecting Data with Encryption and Auditing

-          Options for auditing data access in SQL Server

-          Implementing SQL Server Audit

-          Managing SQL Server Audit

-          Protecting Data with Encryption

Recovery Models and Backup Strategies

-          Understanding Backup Strategies

-          SQL Server Transaction Logs

-          Planning Backup Strategies

Backing Up SQL Server Databases

-          Backing Up Databases and Transaction Logs

-          Managing Database Backups

-          Advanced Database Options

Restoring SQL Server 2016 Databases

-          Understanding the Restore Process

-          Restoring Databases

-          Advanced Restore Scenarios

-          Point-in-Time Recovery

Automating SQL Server Management

-          Automating SQL Server management

-          Working with SQL Server Agent

-          Managing SQL Server Agent Jobs

-          Multi-server Management

Configuring Security for SQL Server Agent

-          Understanding SQL Server Agent Security

-          Configuring Credentials

-          Configuring Proxy Accounts

Monitoring SQL Server with Alerts and Notifications

-          Monitoring SQL Server Errors

-          Configuring Database Mail

-          Operators, Alerts, and Notifications

-          Alerts in Azure SQL Database

Introduction to Managing SQL Server by using PowerShell

-          Getting Started with Windows PowerShell

-          Configure SQL Server using PowerShell

-          Administer and Maintain SQL Server with PowerShell

-          Managing Azure SQL Databases using PowerShell

Tracing Access to SQL Server with Extended events

-          Extended Events Core Concepts

-          Working with Extended Events

Monitoring SQL Server

-          Monitoring activity

-          Capturing and Managing Performance Data

-          Analyzing Collected Performance Data

-          SQL Server Utility

Troubleshooting SQL Server

-          A Trouble Shooting Methodology for SQL Server

-          Resolving Service Related Issues

-          Resolving Connectivity and Log-in issues

Importing and Exporting Data

-          Transferring Data to and from SQL Server

-          Importing and Exporting Table Data

-          Using bcp and BULK INSERT to Import Data

-          Deploying and Upgrading Data-Tier Application

 

MOC 20765: PROVISIONING SQL DATABASES

SQL SERVER 2016 COMPONENTS

-          Introduction to the SQL Server Platform

-          Overview of SQL Server Architecture

-          SQL Server Services and Configuration Options

 

INSTALLING SQL SERVER 2016

-          Considerations for installing SQL Server

-          TempDB Files

-          Installing SQL Server 2016

-          Automating Installation

 

UPGRADING SQL SERVER TO SQL SERVER 2016

-          Upgrade Requirements

-          Upgrade SQL Server Services

-          Migrating SQL Server Data and Applications

 

DEPLOYING SQL SERVER ON MICROSOFT AZURE

-          SQL Server Virtual Machines in Azure

-          Deploying an Azure SQL Database

-          Migrating an On-Premise Database to an Azure SQL Database

 

WORKING WITH DATABASES

-          Overview of SQL Server Databases

-          Creating Databases

-          Database Files and Filegroups

-          Moving Database Files

-          Buffer Pool Extension

 

DATABASE STORAGE OPTIONS

-          SQL Server storage Performance

-          SMB Fileshare

-          SQL Server Storage in Azure

-          Stretch Databases

 

PLANNING TO DEPLOY SQL SERVER ON MICROSOFT AZURE

-          SQL Server Virtual Machines in Azure

-          Azure Storage

-          Azure SQL Authentication

-          Deploying an Azure SQL Database

 

MIGRATING DATABASES TO AZURE SQL DATABASE

-          Database Migration Testing Tools

-          Database Migration Compatibility Issues

-          Migrating a SQL Server Database to Azure SQL Database

 

DEPLOYING SQL SERVER ON A MICROSOFT AZURE VIRTUAL MACHINE

-          Automating Routine Database Maintenance

-          Deploying SQL Server on an Azure VM

-          The Deploy Database to a Microsoft Azure VM Wizard

 

MANAGING DATABASES IN THE CLOUD

-          Managing Azure SQL Database Security

-          Configure Azure storage

-          Azure Automation

Ver más

Más cursos relacionados de Bases de datos

New Horizons Madrid

MCSA SQL Server 2016 Database Administration

New Horizons Madrid - Máster en Madrid
SERVER 2016 COMPONENTS Introduction to the SQL Server Platform Overview of SQL Server Architecture SQL Server Services and Configuration Options Lab: SQL
Descuento por matrícula anticipada

2.050 € 1.550 
PUE

MCSA SQL Server 2014

PUE - Curso en Madrid y 1 sede más
Módulo 1. Querying Microsoft SQL Server 2014 1.- Introduction to Microsoft SQL Server2014 2.- Introduction to Microsoft SQL ServerAzure 3

1.650 
Intergrupo

Máster MCSA: SQL SERVER 2012

Intergrupo - Máster online
Simuladores de Examen 70-461 "Querying Microsoft SQL Server 2012" Módulo 2: Administración de BBDD en SQL Server 2012 Implementación y Mantenimiento de SQL

Precio a consultar
Meforma

Máster SQL SERVER

Meforma - Máster online
El programa de formación MÁSTER DBA EN SQL SERVER, contempla una duración de 600 horas para la consecución de los objetivos propuestos al inicio

Precio a consultar
SLG INSTITUTO DE FORMACION S.L.

Microsoft SQL Server 2005

SLG INSTITUTO DE FORMACION S.L. - Curso online
. Estudia los dos tipos de desencadenadores en SQL Server 2005: AFTER e INSTEAD OF. Administración Estudia el servidor de bases de datos SQL Server 2005 desde

Precio a consultar
Ver más