Administering a SQL Database 2016 Infrastructure

الحاسب الآلي وتقنية المعلومات

مجانا

Module 1: SQL Server Security

Lessons

o Authenticating  Connections to SQL Server

o Authorizing Logins to Connect to databases

o Authorization Across Servers

Lab : Authenticating Users

o Create Logins

o Create Database Users

 

Module 2: Assigning Server and Database Roles

Lessons

o Working with server roles

o Working with Fixed Database Roles

o Assigning User-De ned  Database Roles

Lab : Assigning server and database roles

o Assigning Server Roles

o Assigning Fixed Database Roles

o Assigning User-De ned  Database Roles

 

Module 3: Authorizing Users to Access Resources

Lessons

o Authorizing User Access to Objects o Authorizing Users to Execute Code

o Con  guring Permissions at the Schema Level

Lab : Authorizing users to access resources

o Granting, Denying, and Revoking Permissions on Objects o Granting EXECUTE Permissions on Code

o Granting Permissions at the Schema Level

Module 4: Protecting Data with Encryption and Auditing

Lessons

o Options for auditing data access in SQL Server o Implementing  SQL Server Audit

o Managing SQL Server Audit

o Protecting Data with Encryption

Lab : Using Auditing and Encryption

o Working with SQL Server Audit

o Encrypt a Column as Always Encrypted

 

 

 

 

 

o Encrypt a Database using TDE

 

 

Module 5: Recovery Models and Backup Strategies

Lessons

o Understanding  Backup Strategies o SQL Server Transaction Logs

o Planning Backup Strategies

Lab : Understanding SQL Server recovery models

o Plan a Backup Strategy

o Con  gure Database Recovery Models

 

Module 6: Backing Up SQL Server Databases

Lessons

o Backing Up Databases and Transaction Logs o Managing Database Backups

o Advanced Database Options

Lab : Backing Up Databases

o Backing Up Databases

o Performing Database, Di erential, and Transaction Log Backups

o Performing a Partial Backup

Module 7: Restoring SQL Server 2016 Databases

Lessons

o Understanding  the Restore Process o Restoring Databases

o Advanced Restore Scenarios o Point-in-Time Recovery

Lab : Restoring SQL Server Databases

o Restoring a Database Backup

o Restring Database, Di erential, and Transaction Log Backups

o Performing a Piecemeal Restore

Module 8: Automating SQL Server Management

Lessons

o Automating SQL Server management o Working with SQL Server Agent

o Managing SQL Server Agent Jobs

Lab : Automating SQL Server Management

o Create a SQL Server Agent Job o Test a Job

 

 

 

 

 

o Schedule a Job

 

 

Module 9: Con guring Security for SQL Server Agent

Lessons

o Understanding  SQL Server Agent Security o Con  guring Credentials

Lab : Con guring Security for SQL Server Agent

o Analyzing Problems in SQL Server Agent o Con  guring a Credential

Module 10: Monitoring SQL Server with Alerts and Noti cations

Lessons

o Monitoring SQL Server Errors o Con  guring Database Mail

o Operators, Alerts, and Noti  cations

Lab : Monitoring SQL Server with Alerts and Noti cations

o Con  guring Database Mail o Con  guring Operators

o Con  guring Alerts and Noti  cations

Module 11: Introduction to Managing SQL Server by using PowerShell

Lessons

o Getting Started with Windows PowerShell o Con  gure SQL Server using PowerShell

o Administer and Maintain SQL Server with PowerShell

Lab : Using PowerShell to Manage SQL Server

o Getting Started with PowerShell

o Using PowerShell to Change SQL Server settings

Module 12: Monitoring SQL Server

Lessons

o Monitoring activity

o Capturing and Managing Performance Data

o Analyzing Collected Performance Data

Lab : Monitoring SQL Server

Module 13: Troubleshooting SQL Server

Lessons

o A Trouble Shooting Methodology for SQL Server o Resolving Service Related Issues

Lab : Troubleshooting Common Issues

o Troubleshoot and Resolve a SQL Login Issue o  Troubleshoot and Resolve a Service Issue Module 14: Importing  and Exporting Data Lessons

o Transferring Data to and from SQL Server o Importing and Exporting Table Data

Lab : Importing  and Exporting Data

لا يوجد دورات مجدولة

سجل في قائمة الانتظار

النشرة الإخبارية

الاشتراك للحصول على التحديثات الحق في صندوق البريد الوارد. نحن نعد بعدم إرسال رسائل غير مرغوب فيها لك.