Administrar una infraestructura de bases de datos SQL (55380)

Duración: 28 horas.
Fecha: Del 27 de Febrero al 3 de Marzo de 15 a 20:20 Hrs.
¡Quiero saber más sobre el curso de Administrar una infraestructura de bases de datos SQL (55380)!

A quien va dirigido

Este curso está dirigido a un profesional de TI que administra y mantiene la administración de bases de datos de SQL Server

Descripción

Habilidosamente se ha reinventado este popular curso Administración de una base de datos SQL utilizando nuestro moderno modelo de diseño instruccional centrado en los desafíos. Los laboratorios prácticos en vivo están a la vanguardia de este curso, lo que permite a los estudiantes aprender mientras lo hacen e incluyen materiales de referencia adicionales y acceso posterior a la clase a …

A quien va dirigido

Este curso está dirigido a un profesional de TI que administra y mantiene la administración de bases de datos de SQL Server

Descripción

Habilidosamente se ha reinventado este popular curso Administración de una base de datos SQL utilizando nuestro moderno modelo de diseño instruccional centrado en los desafíos. Los laboratorios prácticos en vivo están a la vanguardia de este curso, lo que permite a los estudiantes aprender mientras lo hacen e incluyen materiales de referencia adicionales y acceso posterior a la clase a los laboratorios de desafíos de Skill para promover y permitir aún más el aprendizaje continuo. En este curso de 4 días, los alumnos validarán sus habilidades introductorias relacionadas con la administración de la infraestructura de base de datos de SQL Server, incluida la seguridad, el cifrado y las mejores prácticas de copia de seguridad y restauración.

  • Se recomienda que los alumnos tengan una comprensión funcional o experiencia laboral y conocimiento de los sistemas operativos cliente de Windows
  • Recomendado que los estudiantes tengan una comprensión funcional o experiencia laboral y conocimiento de bases de datos relacionales
  • Se recomienda que los alumnos tengan una comprensión funcional o experiencia laboral y conocimiento del diseño de bases de datos
  • Se recomienda que los alumnos tengan una comprensión funcional o experiencia laboral y conocimiento de Transact-SQL (T-SQL)

In this hands-on adaptive module, learners will configure SQL Server security. First, the learner will configure the server authentication mode, and then create SQL logins for authentication. Next, the learner will create Windows logins for authentication, and then create database users for authorization.

  • Configure server authentication mode
  • Create SQL logins for authentication
  • Create Windows logins for authentication
  • Create database users for authorization
  • Create SQL Logins for Authentication.
  • Create Windows Logins for Authentication.
  • Create Database Users for Authorization.
  • Configure server authentication mode
  • Create SQL logins for authentication
  • Create Windows logins for authentication
  • Create database users for authorization

In this hands-on adaptive module, learners will assign roles for a Microsoft SQL Server. First, the learner will assign a fixed server role to a login, and then create and assign a user-defined server role to a login. Finally, the learner will assign fixed and user-defined database roles to database users.

  • Assign Roles for a Microsoft SQL Server
  • Assign a fixed server role to a login
  • Create and assign a user-defined server role to a login
  • Assign fixed and user-defined database roles to database users.
  • Assign a Fixed Server Role
  • Create and Assign a User-defined Server Role
  • Assign Fixed and User-defined Database Roles
  • Explain server-scoped permissions. 
  • Describe server-scoped permissions. 
  • Understand fixed server roles and the public server role. 
  • Create user-defined server roles. 

In this hands-on adaptive module, learners will authorize access to a Microsoft SQL Server. First, the learner will authorize user access to objects, and then authorize users to execute code. Finally, the learner will configure permissions at the schema level.

  • Authorize access to a Microsoft SQL Server
  • Authorize user access to objects
  • Authorize users to execute code
  • Configure permissions at the schema level
  • Authorize User Access to Objects
  • Authorize Users to Execute Code
  • Configure Permissions at the Schema Level
  • Authorize user access to objects 
  • Authorize users to execute code 
  • Configure permissions at the schema level

In this hands-on adaptive module, learners will protect data in a Microsoft SQL Server. First, the learner will encrypt a database by using Transparent Data Encryption, and then encrypt sensitive columns by using Always Encrypted. Finally, the learner will enable SQL Audit to allow auditing of SQL Server activity.

  • Learners will protect data in a Microsoft SQL Server
  • Encrypt database by using Transparent Data Encryption
  • Encrypt sensitive columns by using Always Encrypted
  • Enable SQL Audit to allow auditing of SQL Server Activity
  • Encrypt a database
  • Encrypt sensitive columns
  • Enable SQL Audit
  • Describe the options for auditing data access. 
  • Implement and Manage SQL Serve Audit. 
  • Understand and implement encryption methods in SQL Server.

In this hands-on adaptive module, learners will back up Microsoft SQL Server databases. First, the learner will perform a full database backup, and then perform a transaction log backup.

  • Backup Microsoft SQL Server Databases
  • Perform a full database backup
  • Perform a transaction log backup
  • Create and execute a Transact-SQL query that returns backup
  • Create a logical backup device
  • Create a tail-log backup for a database
  • Understand a variety of backup strategies  
  • Explain how database transition logs work 
  • Create SQL Server backup strategies 

In this hands-on adaptive module, learners will restore databases on a Microsoft SQL Server. First, the learner will perform a restore by using a full database backup, and then perform a second restore by using a differential database backup. Finally, the learner will perform a point-in-time restore by using transaction log backups.

  • Learners will restore databases on a Microsoft SQL Server
  • Perform a restore by using a full database backup
  • Perform a second restore by using a differential database backup
  • Perform a point-in-time restore by using transaction log backups
  • Create and execute a Transact-SQL query that performs a restore
  • Create a differential database backup
  • Perform a point-in-time restore by using SSMS
  • Understand the restore process
  • Restore databases
  • Conduct advanced restore operations
  • Complete a point-in-time recovery

In this hands-on adaptive module, learners will automate management in a Microsoft SQL Server. First, the learner will enable SQL Server Agent for automation, and then create, run, and schedule a job. Next, the learner will create a single-schedule maintenance plan, and finally create a multi-schedule maintenance plan.

  • Automate management in a Microsoft SQL Server
  • Enable SQL Server Agent for automation
  • Create, run, and schedule a job
  • Create a single-schedule maintenance plan
  • Create a multi-schedule maintenance plan
  • Create a SQL Server Agent job for to back up the database
  • Create and executed maintenance plans by using SSMS
  • Manage SQL Server Agent jobs.  
  • Define jobs, job types, and job categories. 
  • Troubleshoot failed jobs.

In this hands-on adaptive module, learners will configure security for automation in a Microsoft SQL Server. First, the learner will create and run a job by impersonating a user, and then create a job to perform file operations.

  • Configure security for automation in a Microsoft SQL Server
  • Create and run a job by impersonating a user
  • Create a job to perform file operations
  • Enable SQL Server Agent and job to automate backup
  • Automate file operations with proper permissions
  • Create and enable a proxy
  • Give an overview of security in SQL Server Agent. 
  • Describe the fixed SQL Server Agent roles. 
  • Troubleshoot problems with security in SQL Server Agent. 
  • Discuss configuring credentials in SQL Server Agent

In this hands-on adaptive module, learners will manage alerts and notifications in a Microsoft SQL Server. First, the learner will configure SQL Server Agent to use Database Mail, and then create an operator and a notification to monitor a database. Finally, the learner will create and test an alert.

  • Manage alerts and notifications in a Microsoft SQL Server
  • Configure SQL Server Agent to use Database mail
  • Create an operator and a notification to monitor database
  • Create and test an alert
  • Configure SQL Server Agent to enable default mail profiles
  • Create a query to show all emails sent from mail profiles
  • Automate notifications and alerts
  • Configure a SQL Server error log. 
  • Configure Database Mail profiles and security. 
  • Describe the role of operators in SQL Server Agent.

In this hands-on adaptive module, learners wil ltrace activity for a Microsoft SQL Server. First, the learner will create an Extended Events session, and then use the XEvent Profiler. The learner will then use the system_health Extended Events session.

  • Create an Extended Events session using the XEvent Profiler
  • Use the system_health Extended Events session.
  • Create Windows groups and database user accounts
  • Create, start, and view an Extended Events session
  • Captures events related to deadlocks in SQL Server
  • View system-heal in graphical format
  • Capture and manage SQL Server performance data. 
  • Discuss SQL Server activity and data. 
  • Describe the functionality of Activity Monitor in SQL Server Management Studio.  
  • Explain the advantages of working with Performance Monitor.  
  • Explain the role of the data collector. 
  • Discuss the value of Query Statistics reports

In this hands-on adaptive module, learners will monitor activity and performance for a Microsoft SQL Server. First, the learner will use Activity Monitor in SQL Server Management Studio, and then use dynamic management objects to view activity. Finally, the learner will configure data collection for performance analysis

  • Monitor activity and performance for a Microsoft SQL Server
  • Use Activity Monitor in SQL Server Management Studio
  • Use dynamic management objects to view activity
  • Configure data collection for performance analysis
  • Enable Activity Monitor to discover the blocking and blocked connections activities
  • Use dynamic management objects (DMO) to capture activities
  • Configure a management data warehouse for data collection
  • Enable data collection sets
  • Capture and manage SQL Server performance data. 
  • Discuss SQL Server activity and data. 
  • Describe the functionality of Activity Monitor in SQL Server Management Studio.  
  • Explain the advantages of working with Performance Monitor.  
  • Explain the role of the data collector. 
  • Discuss the value of Query Statistics reports. 

In this hands-on adaptive module, learners will mport and export data for a Microsoft SQL Server. First, the learner will switch partitions for data transfer, and then use the SQL Server Import and Export wizard. Finally, the user will use the BCP utility and the BULK INSERT statement.

  • Import and export data for a Microsoft SQL Server
  • Switch partitions for data transfer
  • Use the SQL Server Import and Export wizard
  • Use the BCP utility and the BULK INSERT statement
  • Execute a Transact-SQL query that creates a partition function, scheme, and tables
  • Initiate and verify data transfer
  • Execute an Import and Export of data using the SQL Server Import and Export Wizard
  • Create and execute a Transact-SQL query that imports data by using various statements
  • Describe data transfer concepts. 
  • Describe SQL Server tools for transferring data. 
  • Import and export table data. 
  • Explain the use of data-tier applications to import and export database applications. 
  • Discuss the SQL Server Integration Services. 
  • Describe working with bcp to import and export data.