Autoryzowane szkolenia MicrosoftMS 55353 Verwalten Einer SQL-Datenbankinfrastruktur

ATTENTION! Training withdrawn from the offer.

To get updated information about Microsoft trainings, please contact our consultant: szkolenia@dagma.pl or 800 080 322.

ÜBER DIESEN KURS


Dieser fünftägige, von einem Kursleiter geleitete Kurs vermittelt Teilnehmern, die SQL Server-Datenbanken verwalten und pflegen, die Kenntnisse und Fähigkeiten zur Verwaltung einer SQL Server-Datenbankinfrastruktur. Darüber hinaus ist es für Personen von Nutzen, die Anwendungen entwickeln, die Inhalte aus SQL Server-Datenbanken bereitstellen.

VORAUSSETZUNGEN:

  • Grundlegende Kenntnisse des Betriebssystems Microsoft Windows und seiner Kernfunktionalität
  • Grundkenntnisse in Transact-SQL
  • Grundkenntnisse in relationalen Datenbanken
  • Etwas Erfahrung mit Datenbankdesign

Trainingsprogramm

Module 1: SQL Server Security

  • Authenticating Connections to SQL Server
  • Authorizing Logins to Connect to databases
  • Authorization Across Servers
  • Partially Contained Databases
  • Lab: Authenticating Users

Module 2: Assigning Server and Database Roles

  • Working with server roles
  • Working with Fixed Database Roles
  • Assigning User-Defined Database Roles
  • Lab: Assigning server and database roles

Module 3: Authorizing Users to Access Resources

  • Describe and use server roles to manage server-level security
  • Describe and use fixed database roles
  • Use custom database roles and application roles to manage database-level security
  • Lab: Authorizing users to access resources

Module 4: Protecting Data with Encryption and Auditing

  • Options for auditing data access in SQL Server
  • Implementing SQL Server Audit
  • Managing SQL Server Audit
  • Protecting Data with Encryption
  • Lab: Using Auditing and Encryption

Module 5: Recovery Models and Backup Strategies

  • Understanding Backup Strategies
  • SQL Server Transaction Logs
  • Planning Backup Strategies
  • Lab: Understanding SQL Server recovery models

Module 6: Backing Up SQL Server Databases

  • Backing Up Databases and Transaction Logs
  • Managing Database Backups
  • Advanced Database Options
  • Lab: Backing Up Databases

Module 7: Restoring SQL Server Databases

  • Understanding the Restore Process
  • Restoring Databases
  • Advanced Restore Scenarios
  • Point-in-Time Recovery
  • Lab: Restoring SQL Server Databases

Module 8: Automating SQL Server Management

  • Automating SQL Server management
  • Working with SQL Server Agent
  • Managing SQL Server Agent Jobs
  • Multi-server Management
  • Lab 1: Automating SQL Server Management

Module 9: Configuring Security for SQL Server Agent

  • Understanding SQL Server Agent Security
  • Configuring Credentials
  • Configuring Proxy Accounts
  • Lab: Configuring Security for SQL Server Agent

Module 10: Monitoring SQL Server with Alerts and Notifications

  • Monitoring SQL Server Errors
  • Configuring Database Mail
  • Operators, Alerts, and Notifications
  • Alerts in Azure SQL Database
  • Lab: Monitoring SQL Server with Alerts and Notifications

Module 11: Introduction to Managing SQL Server by using PowerShell

  • Getting Started with Windows PowerShell
  • Configure SQL Server using PowerShell
  • Administer and Maintain SQL Server with PowerShell
  • Managing Azure SQL Databases using PowerShell
  • Lab: Using PowerShell to Manage SQL Server

Module 12: Tracing Access to SQL Server with Extended events

  • Extended Events Core Concepts
  • Working with Extended Events
  • Lab: Extended Events

Module 13: Monitoring SQL Server

  • Monitoring activity
  • Capturing and Managing Performance Data
  • Analyzing Collected Performance Data
  • SQL Server Utility
  • Lab: Monitoring SQL Server

Module 14: Troubleshooting SQL Server

  • A Trouble Shooting Methodology for SQL Server
  • Resolving Service Related Issues
  • Resolving Connectivity and Log-in issues
  • Lab: Troubleshooting Common Issues

Module 15: Importing and Exporting Data

  • Transferring Data to and from SQL Server
  • Importing and Exporting Table Data
  • Using bcp and BULK INSERT to Import Data
  • Deploying and Upgrading Data-Tier Application
  • Lab: Importing and Exporting Data

NÄCHSTMÖGLICHE TERMINE:

Ruf uns an: +48 800 080 322

Hast du Fragen?
Benötigst du zusätzliche Informationen
Möchtest du einen Platz vorreservieren?

Rufen Sie uns an!
+48 32 259 11 80