O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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,” ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required