MCTS Microsoft SQL Server 2008, Database Development – 70-433 – Objectives List Part 1

This is the first in another collection of posts that have links to the different objectives covered in the 70-433 exam.

Implementing Tables and Views (14 percent)

• Create and alter tables
  • CREATE TABLE command
  • ALTER TABLE command
  • Understanding Tables
  • Creating and Modifying Tables 
• Computed Columns
  • Computed Columns
  • COLUMNPROPERTY
  • How to: Specify Computed Columns (Visual Database Tools)
• Persisted Columns
  • PERSISTED keyword
• Schemas
  • CREATE SCHEMA
  • ALTER SCHEMA
  • DROP SCHEMA
  • GRANT Schema permissions
  • REVOKE Schema Permissions
  • DENY Schema Permissions
  • User-Schema Separation
  • How to: Create a Database Schema
• Scripts to deploy changes to multiple environments
  • An Overview of Database Build and Deployment – VS2008 Database Edition
  • How to: Prepare Database Build Scripts
  • How to: Deploy Changes to New or Existing Databases
  • Troubleshooting Database Project, Build, and Deployment Issues
• GRANT Permissions on
  • GRANT
  • Application Role
  • Assembly
  • Asymmetric Key
  • Certificate
  • Contract
  • Database
  • Endpoint
  • Full-text Catalog
  • Full-text Stoplist
  • Function
  • Login
  • Message Type
  • Object
  • Queue
  • Remote Service Binding
  • Role
  • Route
  • Schema
  • Server
  • Service
  • Stored Procedure
  • Symmetric Key
  • Synonym
  • System Objects
  • Table
  • Type
  • User
  • View
  • XML Schema Collection 
• DENY
  • DENY
  • Application Role
  • Assembly
  • Asymmetric Key
  • Certificate
  • Contract
  • Database
  • Endpoint
  • Full-text Catalog
  • Full-text Stoplist
  • Function
  • Login
  • Message Type
  • Object
  • Queue
  • Remote Service Binding
  • Role
  • Route
  • Schema
  • Server
  • Service
  • Stored Procedure
  • Symmetric Key
  • Synonym
  • System Objects
  • Table
  • Type
  • User
  • View
  • XML Schema Collection 
• REVOKE
  • REVOKE
  • Application Role
  • Assembly
  • Asymmetric Key
  • Certificate
  • Contract
  • Database
  • Endpoint
  • Full-text Catalog
  • Full-text Stoplist
  • Function
  • Login
  • Message Type
  • Object
  • Queue
  • Remote Service Binding
  • Role
  • Route
  • Schema
  • Server
  • Service
  • Stored Procedure
  • Symmetric Key
  • Synonym
  • System Objects
  • Table
  • Type
  • User
  • View
  • XML Schema Collection
• Create and alter views
  • CREATE VIEW
  • ALTER VIEW
  • DROP VIEW 
  • ENCRYPTION
    • sys.syscomments
  • SCHEMABINDING
  • CHECK OPTION
  • GRANT View Permissions
  • DENY View Permissions
  • REVOKE View Permissions
• Create and alter indexes
  • Tables and index data structures architecture
  • General index design guidelines
  • Determining index disk space requirements
  • CREATE INDEX
  • ALTER INDEX
  • DROP INDEX
  • CREATE SPATIAL INDEX
  • CREATE XML INDEX
  • Filtered
    • Filtered index design guidelines
  • Included columns
  • UNIQUE
  • CLUSTERED
    • Clustered index structures
  • NONCLUSTERED
    • Nonclustered index structures
  • FILL FACTOR
  • CREATE STATISTICS
  • Indexed Views
• Create and modify constraints
  • Constraints
  • Enforcing Data Integrity
  • PRIMARY KEY
  • FOREIGN KEY
  • UNIQUE Constraints
  • CHECK Constraints
  • DEFAULT Definitions
  • Allowing Null Values
  • Creating and Modifying PRIMARY KEY Constraints
  • Creating and Modifying FOREIGN KEY Constraints
  • Creating and Modifying UNIQUE Constraints
  • Creating and Modifying CHECK Constraints
  • Creating and Modifying DEFAULT Definitions
  • Cascading Referential Integrity Constraints
  • Guidelines for enabling and disabling constraints
  • SET IDENTITY_INSERT
• Implement data types
  • FILESTREAM Overview
  • Getting Started with FILESTREAM Storage
  • Using FILESTREAM with Other SQL Server Features
  • Working with Spatial Data
  • Getting Started with the geography Data Type
  • Getting Started with the geometry Data Type
  • Spatial Reference Identifiers (SRIDs)
  • Types of Spatial Data
    • Point
    • MultiPoint
    • LineString
    • MultiLineString
    • Polygon
    • MultiPolygon
    • GeometryCollection
    • geometry Data Type Method Reference
    • geography Data Type Method Reference
  • Structure Storage
  • Semi structured storage
  • Using Collations
  • Selecting a SQL Server collation
• Implement partitioning solutions
  • Table and Index Organization
  • Partitioned tables and indexes
  • Understanding Partitioning
  • Partitioned Table and Index Concepts
  • Designing Partitions to Improve Query Performance
  • Designing Partitioned Tables and Indexes
  • Planning Guidelines for Partitioned Tables and Indexes
  • Designing Partitions to Manage Subsets of Data
  • Special Guidelines for Partitioned Indexes
  • Implementing Partitioned Tables and Indexes
  • Creating Partitioned Tables and Indexes
  • CREATE PARTITION FUNCTION (Transact-SQL)
  • CREATE PARTITION SCHEME (Transact-SQL)
  • Modifying Partitioned Tables and Indexes
  • ALTER PARTITION FUNCTION (Transact-SQL)
  • ALTER PARTITION SCHEME (Transact-SQL)
  • Querying Data and Metadata from Partitioned Tables and Indexes
  • Partitioned Table and Index Strategies Whitepaper
  • MERGE (Transact-SQL)
  • Creating Distributed Partitioned Views
  • Modifying Data in Partitioned Views
  • Resolving Distributed Partitioned Views.
  • Using Partitioned Views
  • Linked Servers

You can also find some information on preparing for your exams here, in the actual exam for 70-433. Also errata for the MS Press training kit