MCTS 70-431: Implementing and Maintaining Microsoft SQL Server 2005

Chapter 2. Creating Database Objects

Terms you’ll need to understand:

• ✓ Table

• ✓ View

• ✓ Trigger

• ✓ Function

• ✓ User-defined function (UDF)

• ✓ Table-valued function

• ✓ Scalar-valued function

• ✓ Aggregate

• ✓ Stored procedure

• ✓ Constraint

• ✓ Index

• ✓ Clustered index

• ✓ Nonclustered index

• ✓ Type and user-defined type (UDT)

• ✓ Full-text search

• ✓ Full-text index

• ✓ Full-text catalog

• ✓ Cascading action

• ✓ Data Manipulation Language (DML)

• ✓ Data Definition Language (DDL)

• ✓ Common language runtime (CLR)

• ✓ Partitioning

• ✓ Unique index

• ✓ Identity column

• ✓ Assembly

• ✓ Rule

• ✓ Default

Techniques you’ll need to master:

• ✓ Defining database objects

• ✓ Viewing and creating objects using SQL Server Management Studio

• ✓ Creating objects using Transact-SQL

Chapter 1, “Installing and Configuring SQL Server 2005,” ...