M20764 Administering a SQL Database Infrastructure - Seminar / Kurs von brainymotion AG

Inhalte

This course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure.

Lernziele

Module 1: Authenticating and Authorizing UsersAuthenticating connections to SQL ServerAuthorizing logins to access databasesAuthorization across serversPartially contained databasesLab : Authenticating UsersModule 2: Assigning Server and Database RolesWorking with server rolesWorking with Fixed database rolesCreating user-defined database rolesLab : Assigning server and 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 resourcesModule 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 EncryptionModule 5: SQL Server Recovery ModelsBackup strategiesUnderstanding SQL Server transaction loginPlanning a SQL Server backup strategyLab : Understanding SQL Server recovery modelsModule 6: Backup of SQL Server DatabasesBacking up databases and transaction logsManaging database backupsWorking with backup optionsLab : Backing up SQL Server databasesModule 7: Restoring SQL Server DatabasesUnderstanding the restore processRestoring databasesWorking with point-in-time recoveryRestoring system databases and individual filesLab : Restoring SQL Server User DatabasesModule 8: Automating SQL Server ManagementAutomating SQL Server managementWorking with SQL Server agentManaging SQL Server agent jobsMulti-server managementLab : Automating SQL Server ManagementModule 9: Configuring Security for SQL Server AgentUnderstanding SQL Server Agent SecurityConfiguring credentialsConfiguring proxy accountsLab : Configuring Security for SQL Server AgentModule 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 NotificationsModule 11: Introduction to Managing SQL Server by using PowerShellThis module introduces PowerShell for SQL Server.Configure SQL Server using PowerShellAdminister SQL Server using PowerShellMaintain the SQL Server environment using PowerShellManaging Azure SQL Server databases using PowerShellLab : Administering SQL Server using PowerShellModule 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 ServerModule 13: Monitoring SQL ServerMonitoring activityCapturing and managing performance dataAnalyzing collected performance dataSQL Server utilityModule 14: Troubleshooting SQL ServerSQL Server troubleshooting methodologyResolving service related issuesResolving login and connectivity issuesTroubleshooting common issuesLab : Troubleshooting Common 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 Data;

SG-Seminar-Nr.: 5150573

Anbieter-Seminar-Nr.: 855707765

Preis jetzt anfragen

Seminar merken ›

Semigator berücksichtigt

  • Frühbucher-Preise
  • Last-Minute-Preise
  • Gruppenkonditionen

und verfügt über Sonderkonditionen mit einigen Anbietern.

Der Anbieter ist für den Inhalt verantwortlich.

Über Semigator mehr erfahren

  • Anbietervergleich von über 1.500 Seminaranbietern
  • Vollständige Veranstaltungsinformationen
  • Schnellbuchung
  • Persönlicher Service