Chapter 2: SQL Server 2005 Database Basics

Overview

In this chapter, you will learn about:

·         Tables

·         Data types such as the new large value data types and XML data types

·         User-defined data types (including both T-SQL and CLR user-defined data types)

·         Views

·         Data quality

·         Creating a database

·         Schemas and naming conventions

·         Database control, including change management