Microsoft Exam 70-433
2010 June 25
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!
5 Responses
leave one →
Hello,
Thanks for your blog. some of the links in your blog return “error page not found”. i am preparing for MS 70-433 and was going through your preparation material.
Thank you
Jay
I’m still working through the latest batch of broken links. I now have monitoring set up to scan all my links daily. Hopefully I can clear the last few up, and you can find all the articles you need on certification. Let me know if you need anything in particular, I’ll send you direct links, or send you copies of the content.
Thank you!!!
Shannon,
Is there any easy way to access the different Microsoft Exam 70-433 (part ?) articles on your website? I tried search for Microsoft Exam 70-433 (part 1) and nothing comes up, but it does work for Microsoft Exam 70-433 (part 3).
Thanks,
Mike
One of the quickest ways of finding posts on the different exams would be to use http://shannonlowder.com/tag/http://shannonlowder.com/tag/70433/.