A client/server database system is made up of two components:
For example, if you use SQL Server 2005 to create a checking account application, you must set up a database structure to manage the account transaction data and an application that acts as the user interface to the database. This allows users to access checking account information.
Creating a database to serve your business needs requires an understanding of how to design, create, and maintain each of these components to make sure that your database performs optimally.
- Databases
Describes how databases are used to represent, manage, and access data. Includes designing, implementing, and maintaining databases.
- Federated Database Servers
Describes design guidelines and considerations for implementing a federated database tier.
- Tables
Describes how tables are used to store rows of data and define the relationships between multiple tables.
- Indexes
Describes how indexes are used to increase the speed of accessing data in the table.
- Partitioned Tables and Indexes
Describes how partitioning can make large tables and indexes more manageable and scalable.
- Views
Describes views and their usefulness in providing an alternative way of looking at data in one or more tables.
- Assemblies (Database Engine)
Describes how assemblies are used in SQL Server to deploy functions, stored procedures, triggers, user-defined aggregates, and user-defined types that are written in one of the managed code languages hosted by the Microsoft .NET Framework common language runtime (CLR), and not written in Transact-SQL.
- Synonyms
Describes how a synonym can be used to reference a base object. A synonym is another name for a schema-contained object.
- Designing and Implementing Structured Storage How-to Topics
Contains procedure topics for various database tasks.
