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 ...
Get MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444) 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.
