SQL Server 2008 Database Management
This course is included in our On-demand training solution.
Database maintenance is an ongoing task for SQL Server 2008 administrators. This requires the integrity of the database to be checked, the database size to be kept to a minimum by ensuring the files are the correct sizes, and maintenance tasks to be run regularly. SQL Server 2008 Transact-SQL provides DBCC statements, which in turn provide statements to maintain the database and database files. An administrator can also use maintenance plans to run a series of tasks on specific databases using a schedule or on demand. This course demonstrates how to confirm the integrity of a database, manage database files, and how to create maintenance plans using a wizard or the designer. The course also addresses how to move data between SQL Server instances using detach and attach methods and the Copy Database Wizard, and how to move database files within the same SQL Server instance. This course is one of a series in the SkillSoft learning path that covers the objectives for Microsoft SQL Server 2008 exam number 70-432. Passing this exam will earn the learner the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance certification.
Professionals typically pursuing a career as a Database Administrator; individuals who don’t work directly with SQL Server as part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators.
One to two years of experience using SQL Server 2008 or two to three years of experience using a previous version of SQL Server
SQL Server 2008 Database Integrity and File Management
Moving Database Files in SQL Server 2008
Using Database Maintenance Plans in SQL Server 2008
Managing Database Integrity and Using Maintenance Plans
SQL Server Agent Security and Operator Configuration
Configuring SQL Server Agent Jobs and Alerts
Policy-Based Management in SQL Server 2008
Using SQL Server Agent and Policy-Based Management