To manage and maintain SQL Server 2005 databases
Target Audience
Professionals typically pursuing a career as a Database Administrator, Database Developer or Business Intelligence Developer; individuals who do not work with SQL Server as a part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators among others
Prerequisites
This is a high-level technical path and candidates for the exam, and hence learners should be expert in the following areas: Tools usage UI navigation Wizards usage Writing code in the appropriate language (Transact-SQL, CLR Language, other scripting languages, etc.) Code debugging or syntactic issue resolution Troubleshooting Accomplishing specific focused tasks through the use of code or UI navigation
Lesson Objectives
Exporting Data
- export bulk data in SQL Server 2005 in a given scenario.
Importing Data
- import bulk data into SQL Server 2005 in a given scenario.
Performing Bulk Imports and Exports
- import and export bulk data in SQL Server 2005.
Creating and Configuring Jobs
- create and manage jobs using SQL Server Agent.
Configuring Alerts
- configure alerts using SQL Server Agent in a given scenario.
Configuring Operators
- configure operators using SQL Server Agent in a given scenario.
Working with Jobs and Events
- perform management and monitoring tasks using the SQL Server Agent service.
Managing Database Indexes
- perform database management tasks in SQL Server 2005, given a scenario.
Managing Database Files
- perform the steps required to shrink a database in a given scenario.
Maintaining Database Integrity
- check and maintain database integrity in SQL Server 2005.
|
Key Concepts:
|
|
IT Professional Certifications, Microsoft, Microsoft Certified Technology Specialist (MCTS): SQL Server 2005, 70-431 TS: Microsoft SQL Server 2005: Implementation and Maintenance, MCSE Windows Server 2003 Track, Microsoft Certified IT Professional (MCITP): Database Administrator, Microsoft Certified IT Professional (MCITP): Database Developer, IT Professional Curricula, Enterprise Database Systems Solution Area, Microsoft SQL Server 2005, Microsoft SQL Server 2005: Implementation and Maintenance, MCSA on Windows Server 2003 Track, MCSE Windows 2000 Track
|
|
|
Course Appears in these Categories:
|
• IT Professional Certifications >> Microsoft >> MCSA on Windows Server 2003 Track
• IT Professional Certifications >> Microsoft >> MCSE Windows 2000 Track
• IT Professional Certifications >> Microsoft >> MCSE Windows Server 2003 Track
• IT Professional Certifications >> Microsoft >> Microsoft Certified IT Professional (MCITP): Database Administrator
• IT Professional Certifications >> Microsoft >> Microsoft Certified IT Professional (MCITP): Database Developer
• IT Professional Certifications >> Microsoft >> Microsoft Certified Technology Specialist (MCTS): SQL Server 2005
• IT Professional Skills >> Enterprise Database Systems >> Microsoft SQL Server 2005
|
|
|
Courses you might be interested in:
|
• Windows 2000 - New Features and Architecture
• Windows 2000 - Installation
• Windows 2000 - Administration
• Windows 2000 - Users
• Windows 2000 - Groups and Terminal Services
• Windows 2000 - Files and Folders
• Windows 2000 - Advanced File and Folder Management
• Windows 2000 - Hardware Configuration and Optimization
• Windows 2000 - Storage and Printing
• Windows 2000 - Events
• Windows 2000 - Backup and Recovery
|