A one day course

ABOUT THE COURSE

This DataShed SQL Server Administration course provides an introduction to performing various administrative tasks with Microsoft SQL Server 2005, along with practical examples. The course covers most aspects of SQL Server administration, including backup and recovery, the security model, and database maintenance. The course also covers several methods of accessing and manipulating data in the database using integration services, plus a rundown of the capabilities of the SQL Server Management Studio tool.

At the conclusion of this course, participants should be able to:

• Customise and use the Management Studio administration tool
• Understand database components and SQL Server operations
• Back up and restore databases
• Choose an appropriate database recovery model and backup methodology
• Automate administrative, maintenance and other tasks
• Create and manipulate SQL objects, including tables and views
• Create and modify constraints, triggers, and indexes
• Understand the SQL security model and the relationships between logins, users, roles and permissions
• Create and automate custom data import/export processes

WHO SHOULD ATTEND

Users of Microsoft SQL Server who have been given the task of maintaining one or more SQL Server instances.

TRAINER

Our course leaders are selected from our team of highly skilled data consultants.