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

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