Kurser

5 dages kursus 
Læring inden for et specifikt emne

Administering a SQL Database [55316]

31. maj til 13. juni 2023 Taastrup
20. september til 3. oktober 2023 Taastrup
6. - 21. november 2023 Aarhus
DKK  21.499
ekskl. moms
Nr. 91211 A
Tilmeld dig

Få den nødvendige viden til at administrere, konfigurere og vedligeholde en Microsoft SQL Server database. Kurset er også relevant, hvis du udvikler databaseløsninger, som anvender en SQL Server Database.

Dette kursus afløser Microsoft 20764 Administering a SQL Database Infrastructure.

Deltagerprofil

Kurset er for dig, der administrerer og vedligeholder en SQL Server Database eller udvikler databaseløsninger med indhold herfra.

Forudsætninger

Du forventes at have praktiske erfaring med SQL Server eller andet Relational Database Management System (RDMS) samt erfaring med applikationer på Windows Server.

Udbytte

  • Godkendelse af brugere og tilladelser samt tildeling af roller og ressourcer, og hvordan du kan spore adgange
  • Viden om sikkerhed og hvordan du benytter krypterings- og overvågningsfunktioner til at beskytte data, backupstrategier, sikkerhedskopiering og gendannelse af database
  • Få styr på databaseadministration og hvordan du kan automatisere opgaver ved hjælp af PowerShell
  • Lær at overvåge en SQL Server-infrastruktur og hvordan du fejlfinder
  • Administrer advarsler og meddelelser
  • Import og eksport af data

Det får du på kurset

Vi sørger for at rammerne er i orden, så du kan fokusere på at lære

Efter du har fuldendt kurset, vil du modtage et kursusbevis.

Kursusbevis

Hos Teknologisk Institut bruger vi kun erfarne undervisere.

Erfaren underviser

På kurset får du morgenmad, frokost, snacks og drikkevarer.

Fuld forplejning

På kurset er der indtænkt øvelser og deltagerinddragelse.

Øvelser og inddragelse

Materiale på engelsk

Materiale på engelsk

Undervisning på dansk

Undervisning på dansk

Tæt på kursusstedet er der gratis parkering.

Gratis parkering

Module 1: SQL Server Security
  • This module describes SQL Server security models, logins, users, partially contained databases, and cross-server authorization.

    - Authenticating Connections to SQL Server
    - Authorizing Logins to Connect to databases
    - Authorization Across Servers
    - Partially Contained Databases
Module 2: Assigning Server and Database Roles
  • This module explains how to use roles at the server and database level to manage user permissions.

    - Working with Server Roles
    - Working with Fixed Database Roles
    - User-Defined Database Roles
Module 3: Authorizing Users to Access Resources
  • This module explains how to authorize users to access server and database roles. It also describes how to manage permissions at different levels in a SQL Server instance.

    - Authorizing User Access to Objects
    - Authorizing Users to Execute Code
    - Configuring Permissions at the Schema Level
Module 4: Protecting Data with Encryption and Auditing
  • This module describes the available options for auditing and how to manage audit features. It also describes how to configure and implement data encryption.

    - Options for auditing data access in SQL Server
    - Implementing SQL Server Audit
    - Managing SQL Server Audit
    - Protecting Data with Encryption
Module 5: Recovery Models and Backup Strategies
  • In this module, you will learn how to use the available backup features for databases and transaction logs to create backup strategies.

    - Understanding Backup Strategies
    - SQL Server Transaction Logs
    - Planning Backup Strategies
Module 6: Backing Up SQL Server Databases
  • In this module, you will learn how to apply various backup strategies.

    - Backing Up Databases and Transaction Logs
    - Managing Database Backups
    - Advanced Database Options
Module 7: Restoring SQL Server Databases
  • In this module, you will see how to restore user and system databases and how to implement point-in-time recovery.

    - Understanding the Restore Process
    - Restoring Databases
    - Advanced Restore Scenarios
    - Point-in-Time Recovery
Module 8: Automating SQL Server Management
  • This module describes how to use SQL Server Agent to automate jobs, how to configure security contexts for jobs, and how to implement multi-server jobs.

    - Automating SQL Server management
    - Working with SQL Server Agent
    - Managing SQL Server Agent Jobs
    - Multi-server Management
Module 9: Configuring Security for SQL Server Agent
  • This module explains how to configure SQL Server Agent to use a minimal privilege security environment and how to use credentials and proxy accounts to run jobs securely.

    - Understanding SQL Server Agent Security
    - Configuring Credentials
    - Configuring Proxy Accounts
Module 10: Monitoring SQL Server with Alerts and Notifications
  • This module covers the configuration of Database Mail, alerts, and notifications for a SQL Server instance, and the configuration of alerts for Microsoft Azure SQL Database.

    - Monitoring SQL Server Errors
    - Configuring Database Mail
    - Operators, Alerts, and Notifications
    - Alerts in Azure SQL Database
Module 11: : Introduction to Managing SQL Server by using PowerShell
  • This module explains how to use Windows PowerShell with Microsoft SQL Server and Azure SQL Database. It also describes how to improve efficiency and reliability by scripting tasks and jobs.

    - Getting Started with Windows PowerShell
    - Configure SQL Server using PowerShell
    - Administer and Maintain SQL Server with PowerShell
    - Managing Azure SQL Databases using PowerShell
Module 12: Tracing Access to SQL Server with Extended Events
  • This module explains how to monitor performance metrics for SQL Server and Azure SQL Database. It also describes troubleshooting strategies and usage scenarios for working with Extended Events.

    - Extended Events Core Concepts
    - Working with Extended Events
Module 13: Monitoring SQL Server
  • This module explains how to monitor databases with the goal of proactively dealing with potential issues. It also describes how to use the built-in tools provided to analyze instance and server activity.

    - Monitoring activity
    - Capturing and Managing Performance Data
    - Analyzing Collected Performance Data
Module 14: Troubleshooting SQL Server
  • This module explains how to resolve common issues that may arise when working with SQL Server systems. It also describes a methodology for resolving general database server issues.

    - Applying a Troubleshooting Methodology
    - Resolving Service-Related Issues
    - Resolving Connectivity and Login issues
Module 15: Importing and Exporting Data
  • This module explains how to use SQL Server native tools to import and export data to and from SQL Server and Azure SQL Databases.

    - Transferring Data to and from SQL Server
    - Importing and Exporting Table Data
    - Using bcp and BULK INSERT to Import Data
    - Deploying Data-Tier Applications
 
25656
Underviser

Teknologisk Institut benytter erfarne undervisere fra et bredt netværk af dygtige specialister.

Vælg dato

Taastrup
31. maj til 13. juni 2023
Taastrup
20. september til 3. oktober 2023
Aarhus
6. - 21. november 2023
Billede der illustrerer kurset

Firmakurser - få et tilbud

Er i flere, der har samme behov for kompetenceudvikling, så er et firmakursus ofte den rette løsning, der kan skabe fælles fundament og økonomisk besparelse.