Supporting Microsoft SQL server course description
A concise hands on course enabling delegates to
manage and administer a Microsoft SQL server
database.
What will you learn
Install SQL server.
Backup SQL server databases.
Recover SQL server databases.
Secure SQL server databases.
Perform routine maintenance.
Automate tasks.
Supporting Microsoft SQL server course details
Who will benefit:
Anyone working with Microsoft SQL server
Prerequisites:
Supporting Windows server.
Duration
3 days
Supporting Microsoft SQL server course contents
SQL server introduction
Platform, Tools, services. Installation. Creating databases.
Backups
Back up types, transaction logging, restoring from a backup: Full database, individual files.
Security
Users, server roles, database roles. Permissions.
Monitoring
Routine database maintenance. Performance data.
Jobs and alerts
The SQL server agent, database mail, alerts, jobs.