Dgroove S.r.l. - PCSNET Nordest

MOC 20764 - Administering a SQL Database Infrastructure

Dgroove S.r.l. - PCSNET Nordest
A Villafranca di Verona

1.700 
+IVA
Preferisci chiamare subito il centro?
Chiedi informazioni a un consulente Emagister

Informazioni importanti

Tipologia Corso
Luogo Villafranca di verona
Ore di lezione 35h
Durata 5 Giorni
Inizio Scegli data
  • Corso
  • Villafranca di verona
  • 35h
  • Durata:
    5 Giorni
  • Inizio:
    Scegli data
Descrizione

Autenticare e autorizzare gli utenti
Assegnare ruoli server e database
Autorizzare gli utenti ad accedere alle risorse
Proteggere i dati con la crittografia e il controllo
Descrivere i modelli di recupero e le strategie di backup
Effettuare i backup di Database SQL Server
Ripristinare i database di SQL Server
Automatizzare la gestione di database
Configurare la protezione per l'agente di SQL Server
Gestire avvisi e notifiche
Gestire SQL Server utilizzando PowerShell
Tracciare l'accesso a SQL Server
Monitorare una infrastruttura di SQL Server
Risoluzione dei problemi di una infrastruttura di SQL Server
Importare ed esportare i dati

Strutture (1)
Dove e quando
Inizio Luogo
Scegli data
Villafranca di Verona
Via Monte Baldo 6, 37069, Verona, Italia
Visualizza mappa
Inizio Scegli data
Luogo
Villafranca di Verona
Via Monte Baldo 6, 37069, Verona, Italia
Visualizza mappa

Domande e risposte

Comunicaci i tuoi dubbi,altri utenti potranno risponderti

Cosa impari in questo corso?

Import
SQL
Audit
Security
Server
Microsoft
Microsoft SQL Server
Automating Administration
PowerShell
Troubleshooting

Programma

Module 1: Authenticating and Authorizing UsersAuthenticating connections to SQL ServerAuthorizing logins to access databasesAuthorization across serversPartially contained databasesLab : Authenticating UsersAfter completing this module, you will be able to:Describe server level securityDescribe database level securityDescribe multi-server authenticationDescribe partially contained databasesModule 2: Assigning Server and Database RolesWorking with server rolesWorking with Fixed database rolesCreating user-defined database rolesLab : Assigning server and database rolesAfter completing this module, you will be able to:Describe server rolesDescribe fixed database rolesDescribe user-defined database rolesModule 3: Authorizing Users to Access ResourcesAuthorizing user access to objectsAuthorizing users to execute codeConfiguring permissions at the schema levelLab : Authorizing users to access resourcesAfter completing this module, you will be able to:Describe how to authorize user access to objectsDescribe how to authorize users to execute codeDescribe how to configure permissions at the schema levelModule 4: Protecting Data with Encryption and AuditingOptions for auditing data access in SQL ServerImplementing SQL Server auditManaging SQL Server auditProtecting data with encryptionLab : Using Auditing and EncryptionAfter completing this module, you will be able to:Describe options for auditing data access.Implement SQL Server Audit.Manage SQL Server Audit.Describe how to use custom audit events.Implement encryptionModule 5: SQL Server Recovery ModelsBackup strategiesUnderstanding SQL Server transaction loginPlanning a SQL Server backup strategyLab : Understanding SQL Server recovery modelsAfter completing this module, you will be able to:Describe the various backup strategies.Describe how database transaction logs function.Plan a SQL Server backup strategy.Module 6: Backup of SQL Server DatabasesBacking up databases and transaction logsManaging database backupsWorking with backup optionsLab : Backing up SQL Server databasesAfter completing this module, you will be able to:Perform backups of SQL Server databases and transaction logs.Manage database backups.Describe the advanced backup options.Describe how to backup to the Azure Windows Blob Store.Module 7: Restoring SQL Server DatabasesUnderstanding the restore processRestoring databasesWorking with point-in-time recoveryRestoring system databases and individual filesLab : Restoring SQL Server User DatabasesAfter completing this module, you will be able to:Explain the database restore process.Describe the concept of point in time recovery.Describe the advanced concepts of restoring.Module 8: Automating SQL Server ManagementAutomating SQL Server managementWorking with SQL Server agentManaging SQL Server agent jobsMulti-server managementLab : Automating SQL Server ManagementAfter completing this module, you will be able to:Describe methods for automating SQL Server Management.Configure jobs, job step types, and schedules.Manage SQL Server Agent jobs.Configuremaster and target servers.Module 9: Configuring Security for SQL Server AgentUnderstanding SQL Server Agent SecurityConfiguring credentialsConfiguring proxy accountsLab : Configuring Security for SQL Server AgentAfter completing this module, you will be able to:Describe the security context for SQL Server Agent jobs.Configure credentials.Configure proxy accounts.Module 10: Monitoring SQL Server with Alerts and NotificationsConfiguration of database mailMonitoring SQL Server errorsConfiguring operators, alerts, and notificationsAlerts in Azure SQL databaseLab : Monitoring SQL Server with Alerts and NotificationsAfter completing this module, you will be able to:Configure database mail.Monitor SQL Server errors.Configure operators, alerts and notifications.Module 11: Introduction to Managing SQL Server by using PowerShellConfigure SQL Server using PowerShellAdminister SQL Server using PowerShellMaintain the SQL Server environment using PowerShellManaging Azure SQL Server databases using PowerShellLab : Administering SQL Server using PowerShellAfter completing this module, you will be able to:Configure SQL Server using PowerShellManage day-to-day SQL Server Administration with PowerShellMaintain the SQL Server environment using PowerShell.Module 12: Tracing Access to SQL ServerCapturing activity using SQL Server profilerImproving performance with the database engine tuning advisorWorking with tracing optionsDistributed replayMonitoring locksLab : Tracing Access to SQL ServerAfter completing this module, you will be able to:Configure SQL Profiler traces and review captured traces.Use the Database Engine Tuning Advisor.Understand SQL Server advanced tracing concepts.Use Distributed Replay.Monitor Locking.Module 13: Monitoring SQL ServerMonitoring activityCapturing and managing performance dataAnalyzing collected performance dataSQL Server utilityLab : Monitoring SQL ServerAfter completing this module, you will be able to:Monitor activity within SQL ServerConfigure data collection.View reports from data collection.Configure a SQL Server Utility (UCP)Module 14: Troubleshooting SQL ServerSQL Server troubleshooting methodologyResolving service related issuesResolving login and connectivity issuesTroubleshooting common issuesLab : Troubleshooting Common IssuesAfter completing this module, you will be able to:Explain the SQL Server troubleshooting methodology.Resolve service-related issues.Resolve login and connectivity issuesModule 15: Importing and Exporting DataTransferring data to/from SQL ServerImporting and exporting table dataUsing BCP and BULK INSERT to import dataDeploying and upgrading data-tier applicationsLab : Importing and Exporting DataAfter completing this module, you will be able to:Transfer data.Import and export table data.Use BCP and BULK INSERT to import data.Use DACs to import and export database applications