Administering Microsoft SQL Server 2014 Databases (Course 20462C - equivalent to 10775A - Exam 70-462)
nanforiberica


Acerca de este Curso
Este curso proporciona a los alumnos los conocimientos y las habilidades necesarias para mantener una base de datos Microsoft SQL Server 2014.
El curso se centra en ensenar cómo utilizar SQL Server 2014, las características del producto y las herramientas relacionadas con el mantenimiento de una base de datos.
Además, este curso oficial de SQL server 2014 de Microsoft permite preparar la certificación 70-462.
Perfil de audiencia
Al finalizar el curso
- Planificar e instalar SQL Server.
- Describir las bases de datos del sistema, la estructura física de las bases de datos y las opciones de configuración más comunes relacionados con las mismas.
- Explicar el concepto de modelos de recuperación de SQL Server y el registro de transacciones y poner en práctica diferentes estrategias de copia de seguridad disponibles con SQL Server.
- Crear copias de seguridad de SQL Server.
- Restaurar las bases de datos de SQL Server.
- Utilizar los asistentes de importación / exportación y explicar cómo se relacionan con SSIS.
- Trabajar con SQL Server Security modelos, los inicios de sesión y usuarios.
- Trabajar con funciones fijas de servidor, los roles de servidor definidos por el usuario, funciones de base de datos fijas y las funciones de base de datos definidas por el usuario.
- Trabajar con permisos y la asignación de permisos.
- Trabajar con SQL Server Audit.
- Trabajar con el Agente SQL Server, los trabajos y la historia laboral.
- Implementar la seguridad del Agente SQL Server, cuentas de proxy y las credenciales.
- Configurar la base de datos de correo, alertas y notificaciones.
- Crear planes de mantenimiento de bases de datos.
- Trabajar con SQL y procedimientos almacenados de seguimiento de SQL.
- Conocer DMV y la configuración de la recopilación de datos.
- Trabajar con los servidores centrales de gestión y consultas de varios servidores, virtualización de SQL Server y aplicaciones de nivel de datos.
- Solucionar problemas de bases de datos SQL Server.
Pre-requisitos
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of Transact-SQL.
- Working knowledge of relational databases.
- Some experience with database design.
- 20461C: Querying Microsoft SQL Server 2014
Detalles del curso
Module 1: Introduction to SQL Server 2014 Database Administration
Lessons
- Database Administration Overview
- Introduction to the SQL Server Platform
- Database Management Tools and Techniques
Lab : Using SQL Server Administrative Tools
- Using SQL Server Management Studio
- Using the sqlcmd Utility
- Using Windows PowerShell with SQL Server
- Describe the SQL Server platform.
- Describe common database administration tasks.
- Use SQL Server administration tools.
Module 2: Installing and Configuring SQL Server 2014
Lessons
- Planning SQL Server Installation
- Installing SQL Server 2014
- Post-Installation Configuration
Lab : Installing SQL Server 2014
- Preparing to Install SQL Server
- Installing SQL Server
- Performing Post-Installation Configuration
- Plan a SQL Server 2014 installation.
- Install SQL Server 2014.
- Perform post-installation configuration tasks.
Module 3: Working with Databases and Storage
Lessons
- Introduction to Data Storage with SQL Server
- Managing Storage for System Databases
- Managing Storage for User Databases
- Moving Database Files
- Configuring the Buffer Pool Extension
Lab : Managing Database Storage
- Configuring tempdb Storage
- Creating Databases
- Attaching a Database
- Describe how SQL Server stores data.
- Manage storage for system databases.
- Manage storage for user databases.
- Move database files.
- Configure the buffer pool extension.
Module 4: Planning and Implementing a Backup Strategy
Lessons
- Understanding SQL Server Recovery Models
- Planning a Backup Strategy
- Backing up Databases and Transaction Logs
- Using Backup Options
- Ensuring Backup Reliability
Lab : Backing Up SQL Server Databases
- Backing Up Database
- Performing Database, Differential, and Transaction Log Backups
- Performing a Partial Backup
- Describe how database transaction logs function, and how they affect database recovery.
- Plan a backup strategy for a SQL Server database.
- Back up databases and transactions logs.
- Perform copy-only, compressed, and encrypted backups.
- Maximize backup reliability.
Module 5: Restoring SQL Server 2014 Databases
Lessons
- Understanding the Restore Process
- Restoring Databases
- Advanced Restore Scenarios
- Working with Point-in-Time Recovery
Lab : Restoring SQL Server Databases
- Restoring a Database Backup
- Restoring Database, Differential, and Transaction Log Backups
- Performing a Piecemeal Restore
- Explain the restore process.
- Restore databases.
- Perform advanced restore operations.
- Perform a point-in-time recovery.
Module 6: Importing and Exporting Data
Lessons
- Introduction to Transferring Data
- Importing and Exporting Table Data
- Copying or Moving a Database
Lab : Importing and Exporting Data
- Using the SQL Server Import and Export Wizard
- Using the bcp Utility
- Using the BULK INSERT Statement
- Using the OPENROWSET Function
- Describe tools and techniques for transferring data.
- Import and export data.
- Copy or move a database.
Module 7: Monitoring SQL Server 2014
Lessons
- Introduction to Monitoring SQL Server
- Dynamic Management Views and Functions
- Performance Monitor
Lab : Monitoring SQL Server 2014
- Collecting Baseline Metrics
- Monitoring a Workload
- Describe considerations for monitoring SQL Server and use Activity Monitor.
- Use dynamic management views and functions to monitor SQL Server.
- Use Performance Monitor to monitor SQL Server.
Module 8: Tracing SQL Server Activity
Lessons
- Tracing SQL Server Workload Activity
- Using Traces
Lab : Tracing SQL Server Workload Activity
- Capturing a Trace in SQL Server Profiler
- Generating Database Tuning Recommendations
- Using SQL Trace
- Trace activity in SQL Server.
- Use captured traces to test, troubleshoot, and optimize database performance.
Module 9: Managing SQL Server Security
Lessons
- Introduction to SQL Server Security
- Managing Server-Level Security
- Managing Database-Level Principals
- Managing Database Permissions
Lab : Managing SQL Server Security
- Managing Server-Level Security
- Managing Database-Level Security
- Testing Database Access
- Describe core security concepts in the SQL Server security architecture.
- Manage server-level security.
- Manage database-level security principals.
- Manage database permissions.
Module 10: Auditing Data Access and Encrypting Data
Lessons
- Auditing Data Access in SQL Server
- Implementing SQL Server Audit
- Encrypting Databases
Lab : Auditing Data Access and Encrypting Data
- Implementing Auditing
- Implementing Transparent Database Encryption
- Describe options for auditing data access.
- Implement SQL Server audit.
- Manage SQL Server audit.
- Implement Transparent Data Encryption.
Module 11: Performing Ongoing Database Maintenance
Lessons
- Ensuring Database Integrity
- Maintaining Indexes
- Automating Routine Database Maintenance
Lab : Performing Ongoing Database Maintenance
- Managing Database Integrity
- Managing Index Fragmentation
- Implementing a Maintenance Plan
- Ensure database integrity by using DBCC CHECKDB.
- Maintain indexes.
- Configure Database Maintenance Plans.
Module 12: Automating SQL Server 2014 Management
Lessons
- Automating SQL Server Management
- Implementing SQL Server Agent Jobs
- Managing SQL Server Agent Jobs
- Managing Job Step Security Contexts
- Managing Jobs on Multiple Servers
Lab : Automating SQL Server Management
- Creating a Job
- Scheduling a Job
- Configuring Job Step Security Contexts
- Describe methods for automating SQL Server management.
- Create jobs, job step types, and schedules.
- Manage SQL Server Agent jobs.
- Configure job security contexts.
- Configure master and target servers.
Module 13: Monitoring SQL Server 2014 by Using Alerts and Notifications
Lessons
- Monitoring SQL Server Errors
- Configuring Database Mail
- Configuring Operators, Alerts, and Notifications
Lab : Monitoring SQL Server by Using Alerts and Notifications
- Configuring Database Mail
- Implementing Operators and Notifications
- Implementing Alerts
- Configure Database Mail.
- Monitor SQL Server errors.
- Configure operators, alerts, and notifications.