Wanneer u het examen 70-431 succesvol afrondt, beschikt u over de MCTS certificering SQL Server 2005. Daarnaast maakt dit examen onderdeel uit van de certificeringen MCITP, MCSA en MCSE.
Doelgroep
Candidates for this exam are professionals who typically pursue careers as database administrators, database developers, or business intelligence developers. Additionally, they can be people who do not work with Microsoft SQL Server as a part of their primary job functions but who want to show their breadth of technology experience, such as developers, systems administrators, and others. Candidates have sought out knowledge and experience with Microsoft SQL Server 2005 to enhance their technical expertise, and they can implement and maintain databases by using specific instructions and specifications.
Categorie
Microsoft SQL Server 2005
Tarief
€ 150,00 *
Exclusief € 28,00 administratiekosten indien u wel bij ons uw examen boekt, maar niet de bijbehorende training bij ons volgt.
Certificering / traject
Microsoft MCTS certificering
Microsoft MCITP certificering
Microsoft MCSA certificering
Microsoft MCSE certificering
Inschrijven
Inschrijven voor examen 70-431 doet u via het online examenformulier.
Installing and Configuring SQL Server 2005
- Install 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.
- 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.
Zie ook de Learning Catalog van Microsoft voor eventuele aanvullingen op de inhoud van dit examen.
Categorie
Microsoft SQL Server 2005
Tarief
€ 150,00 *
Exclusief € 28,00 administratiekosten indien u wel bij ons uw examen boekt, maar niet de bijbehorende training bij ons volgt.
Certificering / traject
Microsoft MCTS certificering
Microsoft MCITP certificering
Microsoft MCSA certificering
Microsoft MCSE certificering
Inschrijven
Inschrijven voor examen 70-431 doet u via het online examenformulier.
