
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
Course Features
- Course Duration : 40 Hours
- Life Time Access to Recordings
- Resume preparation / Mock Interviews
- Real time Assignments and projects
- On Job Support for the 1st Project