Course Overview This course is currently in development and scheduled for release in late January 2012 CourseMonster tracks Microsoft training and can notify you when the next Microsoft SQL Server course is available in your area. Contact us for more details. Related Courses Skills Gained After completing this course, students will be able to: - Restore SQL Server databases.
- Work with SQL Server security models, logins and users.
- Implement SQL Server agent security, proxy accounts and credentials.
- Create database maintenance plans.
- Create SQL Server Backups.
- Use the import/export wizards and explain how they relate to SSIS.
- Configure database mail, alerts and notifications.
- Work with SQL Profiler and SQL Trace stored procedures.
- Plan and install SQL Server.
- Describes the system databases, the physical structure of databases and the most common configuration options related to them.
- Explain the concept of the transaction log and SQL Server recovery models and implement different backup strategies available with SQL Server.
- Introduce DMVs and the configuration of data collection.
- Work with Central Management Servers and Multi-Server queries, Virtualization of SQL Server and Data-Tier Applications.
- Troubleshoot SQL Server databases.
- Work with fixed server roles, user-defined server roles, fixed database roles and user-defined database roles.
- Work with permissions and the assignment of permissions.
- Work with SQL Server Audit.
- Work with SQL Server Agent, jobs and job history.
Prerequisites In addition to their professional experience, students who attend this training should already have the following technical knowledge: - Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of Transact-SQL.
- Working knowledge of relational databases.
- Some experience with database design.
If you would prefer the flexibility of online training, use the link(s) below: More Online Training>>
How to make a booking for the M10775 course
|
 |
Request availability or enquire by clicking a date:
London Region
| London (Central) (GT) |
|
£ |
1,545 |
| London (Central) (GT) |
|
£ |
1,545 |
| South West England |
|
£ |
1,795 |
| London Region (GT) |
|
£ |
1,545 |
| South East England |
|
£ |
1,395 |
| South West England |
|
£ |
1,450 |
| South West England |
|
£ |
1,795 |
| London Region (GT) |
|
£ |
1,545 |
No Suitable Dates?
Please click above and we will take care of the rest.
Please click above and we will be happy to discuss the benefits of onsite and bespoke courses with you.
|
