Chapter 7

Designing a Database Data Management Strategy

MICROSOFT EXAM OBJECTIVES COVERED IN THIS CHAPTER:

  • Enforce data quality according to business requirements.
    • Establish the business requirements for quality.
    • Create queries to inspect the data.
    • Use checksum.
    • Clean the data.
  • Design data integrity.
    • Reconcile data conflicts.
    • Make implicit constraints explicit.
    • Assign data types to control characteristics of data stored in a column.

images Strategies recently have been developed to connect distributed systems. With the user interface at the helm, users have choices of workflow and business processes to support and leverage their data needs. Services ...

Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial