SQL Admin Essentials
Become familiar with SQL server administration by discovering the new features in SQL Server 2008-17 and the important capabilities across the SQL server data platform.
No prior product knowledge needed.
Course length: 2 days, Delivery: Online or In-class.
Please call (475) 328-2227 with questions.
Upcoming Classes
Course Overview
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
-
Understanding 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
-
Understanding 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
-
Multi-Server Management
9. Configuring Security for SQL Server Agent
-
Understanding SQL Server Agent Security
-
Configuring credentials
-
Configuring proxy accounts
10. Monitoring SQL Server with Alerts and Notifications
-
Configuration of database mail
-
Monitoring SQL Server errors
-
Configuring operators, alerts, and notifications
-
Alerts in Azure SQL database
11. Introduction to 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
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