O'Reilly logo

MCITP SQL Server 2005 Database Administration All-in-One exam Guide by Darril Gibson

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 2 SQL Server 2005 Database Basics

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

I will prepare and some day my chance will come.

—Abraham Lincoln

Before we can start talking about database design, we need to explain the concepts of what there is to design—things like tables, data types, and views. Tables and data types are the basics of any database. SQL Server also has views, which allow you to view any portion of a table or combination of tables. Last, we'll ...

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