Microsoft MCTS MCITP Certification Training Course for SQL 2005 Exam 70-431
 Our Microsoft MCTS certification training course for Implementing and Maintaining a Microsoft SQL Server
2005 Database Exam 70-431 will help you to target specific technologies and distinguish yourself by demonstrating in-depth knowledge and expertise in your
SQL specialization. This course is also the foundation course for the MCITP Certification.MCTS Information
Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 (MCTS: SQL Server 2005) 70-431 training will teach you how to implement and maintain
databases using specific instructions. You will have extensive knowledge of the product, understand how to use the tools and Transact-SQL language, and know
how to explore the user interface. Technology Specialists generally become database administrators MCITP Certified developers, or business intelligence developers.
Training Audience
This course will greatly benefits people who do not work with Microsoft SQL Server as part of their primary job
role, but want to show their depth of technology experience, such as systems administrators, developers and
many others. This will show that an experience user has sought out training for Microsoft SQL Server 2005 to
enhance their technical expertise, and can implement and maintain databases by using specific instructions and specifications.
Implementing and Maintaining a Microsoft SQL Server 2005 Database Exam 70-431 Course
Pre-requisite
Knowledge in programming with SQL
Knowledge of SQL-Transact
Our Training Includes
- Full multi-media interactive training lessons
- Available in CD-ROM or Online formats
- Learn at your own pace, anytime or anywhere
- Course time: 25 Hours
- Hands on interactive exercises
- 24 x 7 Online Mentoring to instructors
- Practice Certification Exams
|
Online MCTS Microsoft SQL 70-431 Course One Year Access
|
$245.00
|
sp431cd
|
|
|
CD-ROM MCTS Microsoft SQL 70-431 Course
|
$295.00
|
sp431on
|
|
|
Online MCITP Certification Track Microsoft SQL 70-431, 70-443and 70-444 courses
|
$595.00
|
spmcipton
|
|
|
CD-ROM MCITP Certification Track Microsoft SQL 70-431, 70-443 and 70-444 courses
|
$695.00
|
spmcipton
|
|
After completing this course, students will be able to:
- Install SQL Server 2005.
- Configuring the Server.
- Creating and Implementing Database Objects.
- Retrieving Data and Running Queries.
- Messaging and Querying Tools
- Managing and Maintaining Databases
- Database Performance and Optimization
- Monitoring and Diagnosing Database Problems.
- High Availability and Disaster Recovery.
- Backup and Restores
MCTS Training Content
Installing
- How SQL Server 2005 can help improve enterprise data management, developer productivity, and business intelligence.
- Differentiate between the components and services provided.
- Distinguish between management tools.
- The requirements and considerations for installing the Server.
- Install and Configure the Server.
- Select the appropriate upgrade path.
- Perform the steps to upgrade a 2005 Server.
Configuring SQL Server 2005
- Use SQL Server Surface Area Configuration to configure an installation.
- Create a SQL Server database training.
- The security functionality.
- Create logins, users, and schemas.
- The security mechanisms provided by encryption, the TRUSTWORTHY database property, and execution context.
- Recognize how to access data from OLE DB data sources on remote servers using a linked server configuration.
- Use SQL Server Management Studio to configure a linked server in a given scenario.
Creating and Implementing Database Object
- Create a database table.
- Create a database view.
- Recommended guidelines for designing indexes.
- Create a database index.
- Create an online index in SQL Server 2005.
- Create functions and triggers.
- Ceate stored procedures.
- Create, Implement and Manage stored procedures.
Retrieving Data and Running Queries
- Retrieve data from a database.
- Modify data from a relational database.
- Use queries to retrieve and modify data.
- Retrieve, insert, and convert XML data.
- Ceate and secure an HTTP endpoint.
- Work with XML data .
- Create and modify an assembly.
- Control SQL Server transactions.
- Manage transactions.
SQL Server 2005 Messaging and Querying Tools
- create Service Broker components in a given scenario.
- create a Service Broker service.
- recognize the routing, networking, and security features provided by Security Broker.
- identify the features of Full-Text Searches and recognize considerations for implementing them.
- create and troubleshoot full-text queries in a given scenario.
- use full-text search to query SQL Server 2005.
Managing and Maintaining
- Export bulk data.
- Import bulk data.
- Create and manage jobs using SQL Server Agent.
- Configure alerts using SQL Server Agent.
- Configure operators using SQL Server Agent.
- Perform management and monitoring tasks.
- Perform database management tasks.
- Perform the steps required to shrink a databaseo.
- Check and maintain database integrity.
Database Performance and Optimization
- Configure SQL Server Profiler Trace files in a given scenario training.
- Configure System Monitor to monitor performance in a given scenario.
- Use SQL Server Profiler and System Monitor to monitor an instance.
- The features and functionality of Database Engine Tuning Advisor.
- Use Database Engine Tuning Advisor to tune a Server database in a given scenario.
- Using Database Engine Tuning Advisor.
- Retrieve SQL Server state information using dynamic management views (DMVs) in a given scenario.
- Query dynamic management views and functions.
Monitoring and Diagnosing Database Problems
- How locking is used to secure data integrity in a SQL Server database.
- Detect and end deadlocks and blocking connections.
- Detect and terminate a transaction lock.
- Connect to the server using the dedicated administrator connection (DAC) in a given scenario.
- Connect to a non-responsive database using the dedicated administrator connection (DAC).
High Availability and Disaster Recovery
- The features and functionality of database mirroring.
- Configure database mirroring .
- Configure and monitor log shipping in a given scenario.
- Configure log shipping options.
- Configure database snapshots in a given scenario.
- Configure data replication in a given scenario.
- Manage replication.
- Set up data replication.
Backup and Restores
- Determine the appropriate recovery model and backup strategy for a given scenario.
- Perform database backups in a given scenario.
- Back up a SQL Server database.
- Restore a SQL Server backup in a given scenario.
- Move a database in a given scenario.
- Perform a database restore.
|
