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!
Implementing Programming Objects (16 percent)
-
Create and alter stored procedures.
This objective may include but is not limited to: table-valued parameters (TVPs), EXECUTE AS, RECOMPILE, parameter direction (output); WITH ENCRYPTION; manage permissions (GRANT, DENY, REVOKE) -
Create and alter user-defined functions (UDFs).
This objective may include but is not limited to: WITH SCHEMABINDING, EXECUTE AS; manage permissions(GRANT, DENY, REVOKE) -
Create and alter DML triggers.
This objective may include but is not limited to: INSERTED, DELETED, INSTEAD OF, EXECUTE AS -
Create and alter DDL triggers.
This objective may include but is not limited to: enabling/disabling; return event data -
Create and deploy CLR-based objects.
This objective may include but is not limited to: permission sets (SAFE, UNSAFE, EXTERNAL_ACCESS), SET TRUSTWORTHY -
Manage transactions.
This objective may include but is not limited to: BEGIN TRANSACTION, COMMIT, ROLLBACK, SET TRANSACTION ISOLATION LEVEL