Administering a SQL Database Infrastructure
This 5-day course equips students who administer and maintain SQL Server with the right knowledge and skills to successfully administer SQL Server. Furthermore, it is also suitable for those who develop applications that will need to interoperate with SQL server.
SKU : MOC 20764
Categories : Microsoft
Teaching methodology
The course includes educational laboratories in which each student will be able to work in order to complete training exercises that will provide practical experience in using the instrument, for each of the topics covered during the course.
Who should participate
This course is designed for people who administer and maintain SQL Server databases. These people perform SQL server administration and maintenance as their primary responsibility.
Additionally, this course is also designed for those developing applications that will need to interoperate with SQL server.
Prerequisites
In addition to their professional experience, students who will take this course will have to have the following technical requirements:
- Basic knowledge of the Windows operating system.
- Medium knowledge of Transact-SQL.
- Average knowledge of relational databases.
- Database design experience
Outgoing knowledge/skills
By the end of the course, you should be able to achieve the following objectives:
- Authenticate and authorize users
- Assign servers and databases to users
- Authorize users to access resources
- Protect data with encryption and auditing
- Describe the various recovery models and backup strategies
- Backup SQL Server databases
- Restore SQL Server databases
- Automate database management
- Configure security rules for SQL Server agent
- Manage alerts and notifications
- Manage SQL Server using PowerShell
- Trace SQL Server logins
- Monitor SQL Server infrastructure
- SQL Server troubleshooting
- Import and export data
Educational program
This 5-day course equips students who administer and maintain SQL Server with the right knowledge and skills to successfully administer SQL Server. Furthermore, it is also suitable for those who develop applications that will need to interoperate with SQL server
Duration – 5 days
Delivery – in Classroom, On Site, Remote
PC and SW requirements:
- Internet connection
- Web browser, Google Chrome
- Zoom
Language
Instructor: English
Workshop: English
Slides: English
