What you'll Learn
- Introduction to SQL Server
- Preparing, Installing & Configuring SQL Server DB
- Database Backup & Restore
- User Authorization & Authentication
- Assign Server & User Roles
- Monitoring SQL Server Database
SQL Server Administration
The course is best suit for anyone who would like to get in-depth knowledge of managing an RDBMS either in on-premise or in cloud. With this course you will be capable of managing database in enterprise level.
Duration : 30 Hrs
SQL Server Administration course content
- Introduction to SQL Server 2012 and its Toolset
- Preparing Systems for SQL Server 2012
- Installing and Configuring SQL Server 2012
- Working with Databases
- Understanding SQL Server 2012 Recovery Models
- Backup of SQL Server 2012 Databases
- Restoring SQL Server 2012 Databases
- Importing and Exporting Data
- Authenticating and Authorizing Users
- Assigning Server and Database Roles
- Authorizing Users to Access Resources
- Auditing SQL Server Environments
- Automating SQL Server 2012 Management
- Configuring Security for SQL Server Agent
- Monitoring SQL Server 2012 with Alerts and Notifications
- Performing Ongoing Database Maintenance
- Tracing Access to SQL Server 2012
- Monitoring SQL Server 2012
- Managing Multiple Servers
- Troubleshooting Common SQL Server 2012 Administrative Issues
