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!
The first topic covered is Implementing Tables and Views and makes up approximately 14 percent of the exam.
-
Create and alter tables.
This objective may include but is not limited to: computed and persisted columns; schemas; scripts to deploy changes to multiple environments (for example: development, test, production); manage permissions (GRANT, DENY, REVOKE) -
Create and alter views.
This objective may include but is not limited to: WITH ENCRYPTION; WITH SCHEMABINDING; WITH CHECK OPTION; manage permissions (GRANT, DENY, REVOKE) -
Create and alter indexes.
This objective may include but is not limited to: filtered, included columns, unique, clustered, non-clustered, FILL FACTOR; CREATE STATISTICS; indexing views -
Create and modify constraints.
This objective may include but is not limited to: PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, cascading referential integrity, enabling/disabling, NOCHECK; SET IDENTITY_INSERT -
Implement data types.
This objective may include but is not limited to: FILESTREAM; spatial, structured, and semi-structured; collations -
Implement partitioning solutions.
This objective may include but is not limited to: partitioned tables and indexes (constraints, partition functions, partition schemes, MERGE, SPLIT, SWITCH); distributed partitioned views (constraints, linked servers)
If you have questions on any of these topics, please let me know. I’ll build more articles around the questions I receive. That way, as I prepare to finally take my Certification Exams, you’ll be able to learn from it! It’s win-win!