20764 - Administering a SQL Database Infrastructure (2016)


20764 - Administering a SQL Database Infrastructure (2016)


Price
Length : 5 days
$3,095.00

In this course, professionals who administer and maintain SQL Server databases and who develop applications that deliver content from SQL Server databases will gain the knowledge and skills to administer a SQL server database infrastructure.

What You'll Learn

• Authenticate and authorize users.
• Assign server and database roles.
• Authorize users to access resource.
• Protect data with encryption and auditing, recovery models and backup strategies.
• Back up SQL Server databases.
• Restore SQL Server databases.
• Automate database management.
• Configure security for the SQL Server agent.
• Manage alerts and notifications.
• Manage SQL Server using PowerShell.
• Trace access to SQL Server.
• Monitor a SQL Server infrastructure.
• Troubleshoot a SQL Server infrastructure.
• Import and export data.

Who Needs to Attend

• Individuals who administer and maintain SQL Server databases, performing database administration and maintenance as their primary area of responsibility, or who work in
environments where databases play a key role in their primary job.
• Individuals who develop applications that deliver content from SQL Server databases.

Prerequisites

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

Course Outline

1. Authenticating and Authorizing Users
• Authenticating connections to SQL Server
• Authorizing logins to access databases
• Authorization across servers
• Partially contained databases
2. Assigning Server and Database Roles
• Working with server roles
• Working with fixed database roles
• Creating user-defined database roles
3. Authorizing Users to Access Resources
• Authorizing user access to objects
• Authorizing users to execute code
• Configuring permissions at the schema level
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
5. SQL Server Recovery Models
• Backup strategies
• SQL Server transaction login
• Planning a SQL Server backup strategy
6. Backup of SQL Server Databases
• Backing up databases and transaction logs
• Managing database backups
• Working with backup options
7. Restoring SQL Server Databases
• The restore process
• Restoring databases
• Working with point-in-time recovery
• Restoring system databases and individual files
8. Automating SQL Server Management
• Working with SQL Server agent
• Managing SQL Server agent jobs
• Multiserver management
9. Configuring Security for SQL Server Agent
• SQL Server Agent Security
• Configuring credentials
• Configuring proxy accounts
10. Monitoring SQL Server with Alerts and Notifications
• Configuring database mail
• Monitoring SQL Server errors
• Configuring operators, alerts and notifications
• Alerts in Azure SQL database
11. Managing SQL Server by using PowerShell
• Configure SQL Server using PowerShell
• Administer SQL Server using PowerShell
• Maintain the SQL Server environment using PowerShell
• Managing Azure SQL Server databases using PowerShell
12. Tracing Access to SQL Server
• Capturing activity using SQL Server profiler
• Improving performance with the database engine tuning advisor
• Working with tracing options
• Distributed replay
• Monitoring locks
13. Monitoring SQL Server
• Monitoring activity
• Capturing and managing performance data
• Analyzing collected performance data
• SQL Server utility
14. Troubleshooting SQL Server
• SQL Server troubleshooting methodology
• Resolving service related issues
• Resolving login and connectivity issues
• Troubleshooting common issues
15. Importing and Exporting Data
• Transferring data to/from SQL Server
• Importing and exporting table data
• Using BCP and BULK INSERT to import data
• Deploying and upgrading data-tier applications

Labs

Lab 1: Authenticating Users
Lab 2: Assigning Server and Database Roles
Lab 3: Authorizing Users to Access Resources
Lab 4: Using Auditing and Encryption
Lab 5: SQL Server Recovery Models
Lab 6: Backing Up SQL Server Databases
Lab 7: Restoring SQL Server User Databases
Lab 8: Automating SQL Server Management
Lab 9: Configuring Security for SQL Server Agent
Lab 10: Monitoring SQL Server with Alerts and Notifications
Lab 11: Administering SQL Server using PowerShell
Lab 12: Tracing Access to SQL Server
Lab 13: Monitoring SQL Server
Lab 14: Troubleshooting Common Issues
Lab 15: Importing and Exporting Data

Class Dates:

Virtual

Jan 7, 2019 - Jan 11, 2019

Register Now...

Virtual

Jan 14, 2019 - Jan 18, 2019

Register Now...

Virtual

Jan 28, 2019 - Feb 1, 2019

Register Now...

Virtual

Feb 11, 2019 - Feb 15, 2019

Register Now...

Virtual

Feb 25, 2019 - Mar 1, 2019

Register Now...

Virtual

Mar 4, 2019 - Mar 8, 2019

Register Now...

Virtual

Mar 11, 2019 - Mar 15, 2019

Register Now...

Virtual

Mar 18, 2019 - Mar 22, 2019

Register Now...

Virtual

Apr 1, 2019 - Apr 5, 2019

Register Now...

On Site Class Available

ExpertONE Learning Solutions Provider Microsoft Certified Partner Logo GSA Advantage