Microsoft MCTS SQL Server 2005

The Technology Specialist certifications enable professionals to target specific technologies and distinguish themselves by demonstrating in-depth knowledge of and expertise in the technologies with which they work. Microsoft Technology Specialists are consistently capable of implementing, building, troubleshooting, and debugging a particular Microsoft technology..

The goal of our 5 day accelerated Microsoft SQL Server 2005 certification is to provide IT professionals with the knowledge and skills necessary to design, implement and administer Microsoft SQL Server 2005 databases. This is an accelerated, fully immersed course, designed upon the job-related tasks of a DBA.

The course is appropriate for individuals who derive physical database designs, develop logical data models, create physical databases, create data services by using Transact-SQL, manage and maintain databases, configure and manage security, monitor and optimize databases, and install and configure SQL Server.

The SQL Server 2005 Course is Appropriate for:

• Database administrator
• Database analysts
• Database developers

Firebrand Training is unlike any other "boot camp". With Firebrand Training, you will learn more. We offer accelerated training courses that ensure professionals will emerge with thorough knowledge of the products in the shortest possible time.

Instructors are available at all times to provide individual and group attention, lead lab exercises and practice sessions, and ensure the students' success. Our attention to detail shows in our unsurpassed instruction and customer service, our classroom and testing facilities, and our individual and corporate success stories.

From the skilful crafting of our unique curriculum and careful selection of courseware to every detail of your training comfort, Firebrand Training is the best way to obtain SQL 2005 skills. Other training providers cannot match our commitment to quality instruction-led training and top-notch educational facilities.

Firebrand Training provides thorough instructor-led training to ensure that you learn the fundamentals and obtain hands-on skills. You will emerge able to immediately apply your new knowledge in your career environment.

Firebrand Training has an aggressive educational schedule that thoroughly covers all essential elements necessary to become skilled as an SQL Server 2005 professional.

• Day 1 Using Transact-SQL to retrieve data from SQL Server 2005
• Day 2 Implementing a Microsoft SQL Server 2005 Database
• Day 3 Maintaining a Microsoft SQL Server 2005 Database
• Day 4 Introduction to SQL Server Services
• Day 5 Exam - 70-431
• Microsoft SQL Server 2005 - Implementation and Maintenance

Firebrand Training is a Microsoft Certified Partner : Learning Solutions (formerly CTEC). We specially select Microsoft Press or MOC Courseware for the highest-standard training of SQL Server 2005.

Through lecture, group discussion and hands-on lab work, you will learn how to:

• Use the Development Tools provided with SQL Server 2005
• Use Transact-SQL enhancements to perform database development tasks
• Develop XML-based Solutions using SQL Server 2005
• Build Message-Based Services with the Service Broker
• Implement Web Services using Native HTTP Endpoints
• Build Notification Services Applications
• Implement Database Functionality with Managed (.NET) Code
• Build Client Applications with the .NET Framework
• Build Administrative Applications with SQL Management Objects (SMO)
• Describe the components of SQL Server 2005
• Describe new and enhanced features for administrators in SQL Server 2005
• Plan a SQL Server 2005 installation
• Install SQL Server 2005
• Maintain a SQL Server 2005 installation
• Choose the appropriate tool or utility to perform an administrative task
• Use SQL Server Management Studio to manage databases
• Use SQL Server Computer Manager to manage a server
• Use the sqlcmd utility to execute Transact-SQL from the command prompt
• Use SQL Management Objects to script common administrative tasks
• Use SQL Profiler to monitor SQL Server 2005
• Use DDL triggers to respond to DDL events
• Use event notifications to respond to database events
• Query SQL Server metadata
• Maintain indexes in a SQL Server 2005 database
• Use the Database Tuning Advisor to assist with database design
• Maintain SQL Server 2005 databases
• Describe the security architecture of SQL Server 2005
• Manage securables and principals
• Manage permissions
• Use certificates in SQL Server 2005
• Describe common disaster recovery enhancements in SQL Server 2005
• Use database snapshots
• Perform backup and restore operations
• Describe the data availability technologies included in SQL Server 2005
• Describe the concepts of database mirroring
• Configure database mirroring
• Describe the enhancements to replication functionality in SQL Server 2005
• Describe the new types of replication available in SQL Server 2005
• Configure replication using SQL Server 2005.

Students who are successful in accelerated SQL 2005 certification training may possess

• Basic knowledge of the Microsoft Windows operating system and its core functionality
• Working knowledge of Transact-SQL
• Working knowledge of relational databases
• Experience with database design

Microsoft Certified Technology Specialist on SQL Server 2005 candidates are required to pass Exam 70-431.

Skills Being Measured

The 70-431 certification exam measures your ability to implement and maintain a SQL Server 2005 database. This program shall prepare students in the job skills listed in the following matrix:

• Installing and Configuring SQL Server 2005
• Configure SQL Server 2005 instances and databases
• Configure SQL Server security
• Configure linked servers by using SQL Server Management Studio (SSMS)
• Implementing High Availability and Disaster Recovery
• Implement database mirroring
• Implement log shipping
• Manage database snapshots
• Supporting Data Consumers
• Retrieve data to support ad hoc and recurring queries
• Manipulate relational data
• Manage XML data
• Implement an HTTP endpoint
• Implement Service Broker components
• Import and export data from a file
• Manage replication
• Maintaining Databases
• Implement and maintain SQL Server Agent jobs
• Manage databases by using Transact-SQL
• Back up a database
• Restore a database
• Move a database between servers
• Monitoring and Troubleshooting SQL Server Performance
• Gather performance and optimization data by using the SQL Server Profiler
• Gather performance and optimization data by using the Database Engine Tuning Advisor.
• Monitor and resolve blocks and deadlocks
• Diagnose and resolve database server errors
• Monitor SQL Server Agent job history
• Gather performance and optimization data by using DMVs
• Creating and Implementing Database Objects
• Implement a table
• Implement a view
• Implement triggers
• Implement functions
• Implement stored procedures
• Implement constraints
• Implement indexes
• Create user-defined types
• Implement a full-text search
• Implement partitions.