I’m putting together a new series to cover the materials you’ll need to know in order to pass the 70-433. Microsoft’s exam that covers Database Development using Microsoft SQL Server 2008. I’m going to list the topics covered in several posts, each one will include links to details to those topics. If you have any questions, let me know!
Working with Additional SQL Server Components (11 percent)
-
Integrate Database Mail.
-
Implement full-text search.
This objective may include but is not limited to: CONTAINS, CONTAINSTABLE, FREETEXT, FREETEXTTABLE, STOPLIST -
Implement scripts by using Windows PowerShell and SQL Server Management Objects (SMOs).
This objective may include but is not limited to: cmdlets -
Implement Service Broker solutions.
This objective may include but is not limited to: services, queues, messages, message types, message validation, contracts, activation procedures -
Track data changes.
This objective may include but is not limited to: change tracking; database audit specification; CHANGETABLE