Menú
¡Llama gratis! 900 264 357

Máster en Microsoft MCSA administración de Microsoft SQL server 2016 en Madrid

CAS TRAINING

Programa de Máster en Microsoft MCSA administración de Microsoft SQL server 2016

CAS TRAINING
Presencial Duración: 60 horas
Pedir información
Presencial
Impartido en: Madrid
La obtención de una certificación MCSA: SQL 2016 le permite aspirar a un puesto de especialista en infraestructura o administrador de bases de datos.

Descripción

Si estás interesado en prepararte para los exámenes: 70-764: Administering a SQL Database Infrastructure y 70-765: Provisioning SQL Databases. esta es tu formación.

Desde CAS TRAINING, te preparamos para obtener la Certificación MCSA, con nuestra formación presencial con una duración total de 60 horas.


A quién va dirigido

A toda persona que cuente con conocimientos en Informática, a Profesionales del sector IT que deseen actualizar sus conocimientos.

A toda persona con Formación Profesional o Titulados Universitarios.



Objetivos

El objetivo principal del curso es proporcionar al estudiante conocimientos que le permitan obtener resultados exitosos en los exámenes: 70-764: Administering a SQL Database Infrastructure y 70-765: Provisioning SQL Databases, para obtener la Certificación MCSA.


Temario

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

Titulación obtenida

CAS TRAINING, hará entrega al estudiante de una Titulación Oficial, una vez se finalicen los estudios satisfactoriamente.

Requisitos

Para acceder al Máster en Microsoft MCSA administración de Microsoft SQL server 2016, el aspirante debe tener los siguientes conocimientos:

En el sistema operativo Microsoft Windows y su funcionalidad básica.

En Transact-SQL.

En bases de datos relacionales.

Y experiencia en el diseño de la base de datos.


Información Adicional



Contacta ahora con el centro