-
Module 1: Introduction to SQL Server and its Toolset
- Introduction to the SQL Server Platform
- Working with SQL Server Tools
- Configuring SQL Server Services
- Introduction to SQL Server and its Toolset
- Verifying SQL Server Component Installation
- Altering Service Accounts for New Instance
- Enabling Named Pipes Protocol for Both Instances
- Ensuring SQL Browser is Disabled and Configure a Fixed TCP/IP Port
-
Module 2: Preparing Systems for SQL Server
-
Module 3: Installing and Configuring SQL Server
-
Module 4: Working with Databases
-
Module 5: Understanding SQL Server Recovery Models
-
Module 6: Backup of SQL Server Databases
-
Module 7: Restoring SQL Server Databases
-
Module 8: Importing and Exporting Data
-
Module 9: Authenticating and Authorizing Users
-
Module 10: Assigning Server and Database Roles
-
Module 11: Authorizing Users to Access Resources
-
Module 12: Auditing SQL Server Environments
-
Module 13: Automating SQL Server Management
-
Module 14: Configuring Security for SQL Server Agent
-
Module 15: Monitoring SQL Server with Alerts and Notifications
-
Module 16: Performing Ongoing Database Maintenance
-
Module 17: Tracing Access to SQL Server 2012
-
Module 18: Monitoring SQL Server
-
Module 19: Troubleshooting Common SQL Server Administrative Issues
