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

Chapter 3. Implementing Database Objects

Terms you’ll need to understand:

• ✓ SELECT command

• ✓ INSERT command

• ✓ UPDATE command

• ✓ DELETE command

• ✓ Transaction

• ✓ COMMIT statement

• ✓ ROLLBACK statement

• ✓ Index

• ✓ FROM clause and WHERE clause

• ✓ GROUP BY clause and HAVING clause

• ✓ LEFT JOIN or RIGHT JOIN

• ✓ INNER JOIN

• ✓ OUTER JOIN

• ✓ BETWEEN keyword

• ✓ ISNULL statement

• ✓ NULL value

• ✓ TABLESAMPLE clause

• ✓ Catalog

• ✓ CONTAINS command and CONTAINSTABLE command

• ✓ FREETEXT command and FREETEXTTABLE command

Techniques you’ll need to master:

• ✓ Performing queries to extract data and produce reports

• ✓ Inserting data, updating data, and disabling objects during insertion

• ✓ Writing procedures that utilize transactions

• ✓ Setting up and using full-text queries

Although it is important to get tables ...