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 and other objects in place, all that is really just the beginning of a database. With database applications, you put raw data in and attempt to gain information in return. Although every system is different, there are five basic functions that every system must support:

  • Adding new data to the system

  • Changing the existing data

  • Removing obsolete or unwanted data

  • Allowing user viewing of queries and data

  • Reporting the data in a meaningful and useful manner

The server side does not necessarily perform the implementation of all these processes. In fact, most front-end applications provide the basics of these operations. The 70-431 exam does not focus a great deal on the actual writing of complete processes; its focus is more on individual situations where, as an administrator, you might perform the activities using some form of scripting.

This chapter is organized into individual scenarios that you may see on the exam and the operations you would perform to accommodate each situation.




MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net