O'Reilly logo

All-In-One MCITP SQL Server 2005 Database Developer 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 2SQL Server 2005 Database Basics

In this chapter, you will learn about:

• Tables

• Traditional data types

• New large value data types

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

• Views

• Creating a database

• Schemas and naming conventions

Einstein argued that there must be simplified explanations of nature, because God is not capricious or arbitrary. No such faith comforts the software engineer.

—Fred Brooks in No Silver Bullet

Before we can get into the heavy topics of database development, we need to explain some of the basics for a database—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 ...

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