Curs 20764 Administering a SQL Database Infrastructure

Curs Administering a SQL Database Infrastructure – Curs 20764

Inregistrati-va

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
  • Create Logins
  • Create Database Users
  • Correct Application Login Issues
  • Configure Security for Restored Databases

After completing this module, you will be able to:

  • SQL Server basic concepts.
  • SQL Server connection authentication.
  • User login authorization to databases.
  • Partially contained databases.
  • Authorization across servers.

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
  • Assigning Server Roles
  • Assigning Fixed Database Roles
  • Assigning User-Defined Database Roles
  • Verifying Security

After completing this module, you will be able to:

  • 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.

Module 3: Authorizing Users to Access Resources

  • Authorizing User Access to Objects
  • Authorizing Users to Execute Code
  • Configuring Permissions at the Schema Level
Lab : Authorizing users to access resources
  • Granting, Denying, and Revoking Permissions on Objects
  • Granting EXECUTE Permissions on Code
  • Granting Permissions at the Schema Level

After completing this module, you will be able to:

  • Authorize user access to objects.
  • Authorize users to execute code.
  • Configure permissions at the schema level.

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
  • Working with SQL Server Audit
  • Encrypt a Column as Always Encrypted
  • Encrypt a Database using TDE

After completing this module, you will be able to:

  • Describe the options for auditing data access.
  • Implement SQL Server Audit.
  • Manage SQL Server Audit.
  • Describe and implement methods of encrypting data in SQL Server.
  • Implement encryption

Module 5: Recovery Models and Backup Strategies

  • Understanding Backup Strategies
  • SQL Server Transaction Logs
  • Planning Backup Strategies
Lab : Understanding SQL Server recovery models
  • Plan a Backup Strategy
  • Configure Database Recovery Models

After completing this module, you will be able to:

  • Describe various backup strategies.
  • Describe how database transaction logs function.
  • Plan SQL Server backup strategies.

Module 6: Backing Up SQL Server Databases

  • Backing Up Databases and Transaction Logs
  • Managing Database Backups
  • Advanced Database Options
Lab : Backing Up Databases
  • Backing Up Databases
  • Performing Database, Differential, and Transaction Log Backups
  • Performing a Partial Backup

After completing this module, you will be able to:

  • Perform backups of SQL Server databases and transaction logs.
  • Manage database backups.
  • Describe advanced backup options.

Module 7: Restoring SQL Server 2016 Databases

  • Understanding the Restore Process
  • Restoring Databases
  • Advanced Restore Scenarios
  • Point-in-Time Recovery
Lab : Restoring SQL Server Databases
  • Restoring a Database Backup
  • Restring Database, Differential, and Transaction Log Backups
  • Performing a Piecemeal Restore

After completing this module, you will be able to:

  • Explain the restore process.
  • Restore databases.
  • Perform advanced restore operations.
  • Perform a point-in-time recovery.

Module 8: Automating SQL Server ManagementT

  • Automating SQL Server management
  • Working with SQL Server Agent
  • Managing SQL Server Agent Jobs
  • Multi-server Management
Lab : Automating SQL Server Management
  • Create a SQL Server Agent Job
  • Test a Job
  • Schedule a Job
  • Configure Master and Target Servers

After 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.
  • Configure master and target servers.

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
  • Analyzing Problems in SQL Server Agent
  • Configuring a Credential
  • Configuring a Proxy Account
  • Configuring and testing the Security Context of a Job

After completing this module, you will be able to:

  • Explain SQL Server Agent security.
  • Configure credentials.
  • Configure proxy accounts.

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
  • Configuring Database Mail
  • Configuring Operators
  • Configuring Alerts and Notifications
  • Testing Alerts and Notifications

After completing this module, you will be able to:

  • Monitor SQL Server errors.
  • Configure database mail.
  • Configure operators, alerts, and notifications.
  • Work with alerts in Azure SQL Database.

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
  • Getting Started with PowerShell
  • Using PowerShell to Change SQL Server settings

After completing this module, you will be able to:

  • Describe the benefits of PowerShell and its fundamental concepts.
  • Configure SQL Server by using PowerShell.
  • Administer and maintain SQL Server by using PowerShell.
  • Manage an Azure SQL Database by using PowerShell.

Module 12: Tracing Access to SQL Server with Extended events

  • Extended Events Core Concepts
  • Working with Extended Events
Lab : Extended Events
  • Using the System_Health Extended Events Session
  • Tracking Page Splits Using Extended Events

After completing this module, you will be able to:

  • Describe Extended Events core concepts.
  • Create and query Extended Events sessions.

Module 13: Monitoring SQL Server

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

After completing this module, you will be able to:

  • Monitor current activity.
  • Capture and manage performance data.
  • Analyze collected performance data.
  • Configure SQL Server Utility.

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
  • Troubleshoot and Resolve a SQL Login Issue
  • Troubleshoot and Resolve a Service Issue
  • Troubleshoot and Resolve a Windows Login Issue
  • Troubleshoot and Resolve a Job Execution Issue
  • Troubleshoot and Resolve a Performance Issue

After completing this module, you will be able to:

  • Describe a troubleshooting methodology for SQL Server.
  • Resolve service-related issues.
  • Resolve login and connectivity 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
  • Import and Excel Data Using the Import Wizard
  • Import a Delimited Text File Using bcp
  • Import a Delimited Text File using BULK INSERT
  • Create and Test an SSIS Package to Extract Data
  • Deploy a Data-Tier Application

After completing this module, you will be able to:

  • Describe tools and techniques for transferring data.
  • Import and export table data.
  • Use bcp and BULK INSERT to import data.
  • Use data-tier applications to import and export database applications.

 

Inregistrati-va

Locatia de desfasurare a cursului:

Sediul Learning Solution: Str. Transilvaniei nr. 24, Sector 1, Bucuresti
Cine susține cursul?
Florin Florea

Durata Curs
5 zile: 9:00 – 17:00

Cunostinte prealabile

Basic knowledge of the Microsoft Windows operating system and its core functionality.
Working knowledge of Transact-SQL.
Working knowledge of relational databases.
Some experience with database design..

Cursuri Conexe

Curs Updating Your Skills to SQL Server 2016 – Curs 10986
Curs 10990 Analyzing Data with SQL Server Reporting Services
Curs 20761 Querying Data with Transact-SQL
Curs 20762 Developing SQL Databases
Curs 20765 Provisioning SQL Databases
Curs 20767 Implementing a SQL Data Warehouse
Curs 20768 Developing SQL Data Models
Curs 55170 Writing Reports with Report Designer and SSRS 2016 Level 2
Curs 55069 PowerShell for SQL Server Administrators

Abonați-vă la newsletter

Ne găsiți la
Telefon/Fax: 021 367 0092
Telefon: 0748.11.23.23
Str. Transilavaniei, nr. 24, Sector 1, Bucuresti,
Cod Postal 010798, ROMANIA