MOC 20462 - Administering Microsoft SQL Server Databases

Vecomp Software - PCSNET Nordest
A Villafranca di Verona
  • Vecomp Software - PCSNET Nordest

1.700 
+IVA
Chiedi informazioni a un consulente Emagister
Chiedi informazioni a un consulente Emagister

Informazioni importanti

Tipologia Corso
Inizio Villafranca di verona
Ore di lezione 35 ore di lezione
Durata 5 Giorni
Inizio lezioni Flessible
  • Corso
  • Villafranca di verona
  • 35 ore di lezione
  • Durata:
    5 Giorni
  • Inizio lezioni:
    Flessible
Descrizione

Obiettivi:
-Descrivere le attività e gli strumenti di amministrazione di base del database.
-Installare e configurare SQL Server 2014.
-Configurare i database di SQL Server e lo storage.
-Pianificare e implementare una strategia di backup.
-Ripristinare i database dai backup.
-Importare ed esportare i dati.
-Monitorare SQL Server.
Tracciare l'attività di SQL Server.
-Gestire la protezione di SQL Server.
-Effettuare l'auditing degli accessi e crittografare i dati.
-Eseguire la manutenzione ordinaria del database.
-Automatizzare la manutenzione di SQL Server con l'agente Jobs SQL Server.
-Configurare la Posta elettronica, gli avvisi e le notifiche.

Informazioni importanti
Sedi

Dove e quando

Inizio Luogo
Flessible
Villafranca di Verona
37069, Verona, Italia
Visualizza mappa
Inizio Flessible
Luogo
Villafranca di Verona
37069, Verona, Italia
Visualizza mappa

Cosa impari in questo corso?

Administering Microsoft
SQL Server Databases
SQL
Server
Windows
Wireless
PC
Informatica
Account synchronizing
Panel using
Network
Configuring

Professori

Francesco Pandiscia
Francesco Pandiscia
Senior Consultant, MCT, MCPIT, MCTS e VMware VCP

Programma

Module 1: Introduction to SQL Server 2014 Database AdministrationDatabase Administration OverviewIntroduction to the SQL Server PlatformDatabase Management Tools and TechniquesLab : Using SQL Server Administrative ToolsUsing SQL Server Management StudioUsing the sqlcmd UtilityUsing Windows PowerShell with SQL ServerModule 2: Installing and Configuring SQL Server 2014Planning SQL Server InstallationInstalling SQL Server 2014Post-Installation ConfigurationLab : Installing SQL Server 2014Preparing to Install SQL ServerInstalling SQL ServerPerforming Post-Installation ConfigurationModule 3: Working with Databases and StorageIntroduction to Data Storage with SQL ServerManaging Storage for System DatabasesManaging Storage for User DatabasesMoving Database FilesConfiguring the Buffer Pool ExtensionLab : Managing Database StorageConfiguring tempdb StorageCreating DatabasesAttaching a DatabaseModule 4: Planning and Implementing a Backup StrategyUnderstanding SQL Server Recovery ModelsPlanning a Backup StrategyBacking up Databases and Transaction LogsUsing Backup OptionsEnsuring Backup ReliabilityLab : Backing Up SQL Server DatabasesBacking Up DatabasePerforming Database, Differential, and Transaction Log BackupsPerforming a Partial BackupModule 5: Restoring SQL Server 2014 DatabasesUnderstanding the Restore ProcessRestoring DatabasesAdvanced Restore ScenariosWorking with Point-in-Time RecoveryLab : Restoring SQL Server DatabasesRestoring a Database BackupRestoring Database, Differential, and Transaction Log BackupsPerforming a Piecemeal RestoreModule 6: Importing and Exporting DataIntroduction to Transferring DataImporting and Exporting Table DataCopying or Moving a DatabaseLab : Importing and Exporting DataUsing the SQL Server Import and Export WizardUsing the bcp UtilityUsing the BULK INSERT StatementUsing the OPENROWSET FunctionModule 7: Monitoring SQL Server 2014Introduction to Monitoring SQL ServerDynamic Management Views and FunctionsPerformance MonitorLab : Monitoring SQL Server 2014Collecting Baseline MetricsMonitoring a WorkloadModule 8: Tracing SQL Server ActivityTracing SQL Server Workload ActivityUsing TracesLab : Tracing SQL Server Workload ActivityCapturing a Trace in SQL Server ProfilerGenerating Database Tuning RecommendationsUsing SQL TraceModule 9: Managing SQL Server SecurityIntroduction to SQL Server SecurityManaging Server-Level SecurityManaging Database-Level PrincipalsManaging Database PermissionsLab : Managing SQL Server SecurityManaging Server-Level SecurityManaging Database-Level SecurityTesting Database AccessModule 10: Auditing Data Access and Encrypting DataAuditing Data Access in SQL ServerImplementing SQL Server AuditEncrypting DatabasesLab : Auditing Data Access and Encrypting DataImplementing AuditingImplementing Transparent Database EncryptionModule 11: Performing Ongoing Database MaintenanceEnsuring Database IntegrityMaintaining IndexesAutomating Routine Database MaintenanceLab : Performing Ongoing Database MaintenanceManaging Database IntegrityManaging Index FragmentationImplementing a Maintenance PlanModule 12: Automating SQL Server 2014 ManagementAutomating SQL Server ManagementImplementing SQL Server Agent JobsManaging SQL Server Agent JobsManaging Job Step Security ContextsManaging Jobs on Multiple ServersLab : Automating SQL Server ManagementCreating a JobScheduling a JobConfiguring Job Step Security ContextsModule 13: Monitoring SQL Server 2014 by Using Alerts and NotificationsMonitoring SQL Server ErrorsConfiguring Database MailConfiguring Operators, Alerts, and NotificationsLab : Monitoring SQL Server by Using Alerts and NotificationsConfiguring Database MailImplementing Operators and NotificationsImplementing Alerts

Successi del Centro