Overview
Course Instructor: Brian Alderman
Course Outline
01. Module 1: Introduction to SQL Server 2012 and Its Toolset
- Introduction to the SQL Server Platform
- Working with SQL Server Tools
- Configuring SQL Server Services
02. Module 2: Preparing Systems for SQL Server 2012
- Overview of SQL Server Architecture
- Planning Server Resource Requirements
- Pre-installation Testing for SQL Server
03. Module 3: Installing and Configuring SQL Server 2012
- Preparing to Install SQL Server
- Installing SQL Server
- Upgrading and Automating Installation
04. Module 4: Working with Databases
- Overview of SQL Server Databases
- Working with Files and File groups
- Moving Database Files
05. Module 5: Understanding SQL Server 2012 Recovery Models
- Backup Strategies
- Understanding SQL Server Transaction Logging
- Planning a SQL Server Backup Strategy
06. Module 6: Backup of SQL Server 2012 Databases
- Backing up Databases and Transaction Logs
- Managing Database Backups
- Working with Backup Options
07. Module 7: Restoring SQL Server 2012 Databases
- Understanding the Restore Process
- Restoring Databases
- Working with Point-in-time Recovery
- Restoring System Databases and Individual Files
08. Module 8: Importing and Exporting Data
- Transferring Data To/From SQL Server
- Importing & Exporting Table Data
- Inserting Data in Bulk
09. Module 9: Authenticating and Authorizing Users
- Authenticating Connections to SQL Server
- Authorizing Logins to Access Databases
- Authorization Across Servers
10. Module 10: Assigning Server and Database Roles
- Working with Server Roles
- Working with Fixed Database Roles
- Creating User-defined Database Roles
11. Module 11: Authorizing Users to Access Resources
- Authorizing User Access to Objects
- Authorizing Users to Execute Code
- Configuring Permissions at the Schema Level
12. Module 12: Auditing SQL Server 2012 Environments
- Options for Auditing Data Access in SQL Server
- Implementing SQL Server Audit
- Managing SQL Server Audit
13. Module 13: Automating SQL Server 2012 Management
- Options for Auditing Data Access in SQL Server
- Implementing SQL Server Audit
- Managing SQL Server Audit
14. Module 14: Configuring Security for SQL Server Agent
- Understanding SQL Server Agent Security
- Configuring Credentials
- Configuring Proxy Accounts
15. Module 15: Monitoring SQL Server 2012 with Alerts and Notifications
- Overview of Database Mail
- Database Mail Profiles
- Database Mail Security
- Database Mail Logs and Retention
16. Module 16: Performing Ongoing Database Maintenance
- Ensuring Database Integrity
- Maintaining Indexes
- Automating Routine Database Maintenance
17. Module 17: Tracing Access to SQL Server 2012
- Capturing Activity Using SQL Server Profiler and Extended Events Profiler
- Improving Performance with the Database Engine Tuning Advisor
- Working with Tracing Options
18. Module 18: Monitoring SQL Server 2012
- Monitoring Activity
- Capturing and Managing Performance Data
- Analyzing Collected Performance Data
19. Module 19: Managing Multiple Servers
- Working with Multiple Servers
- Virtualizing SQL Server
- Deploying and Upgrading Data-tier Applications
20. Module 20: Troubleshooting Common SQL Server 2012 Administrative Issues
- SQL Server Troubleshooting Methodology
- Resolving Service-related Issues
- Resolving Login and Connectivity Issues
- Resolving Concurrency Issues
Skills Learned
After completing this online training course, students will be able to:
- Plan, install, and troubleshoot SQL Server 2012 and SQL Server databases
- Working knowledge of SQL Databases, the concept of the transaction log, SQL Server 2012 database recovery, backup and restoration
- SQL Server 2012 security models, logins and users
- Fixed server roles, user-defined server roles, fixed database roles and permissions and the assignment of permissions, user-defined database roles
- Partial database containment option provided by SQL Server 2012
- SQL Profiler
- Virtualization of SQL Server 2012 and Data-Tier Applications, Central Management Servers and Multi-Server queries
- Auditing SQL Server 2012 environments
- Monitoring and maintaining SQL Server 2012 databases
- Managing and working with multiple servers including virtualizing SQL Server 2012and deploying and upgrading data-tier applications