Designing and Creating Databases

A client/server database system is made up of two components:

  • Programs that provide an interface for client-based users to access data.
  • The database structure that manages and stores the data on the server.

For example, if you use Microsoft 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.

Topic Description

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.

Stored Procedures

Describes how these Transact-SQL programs centralize business rules, tasks, and processes within the server.

DML Triggers

Describes the function of DML triggers as special types of stored procedures executed only when data in a table is modified.

DDL Triggers

Describes the function of DDL Triggers as a special kind of trigger that fires in response to Data Definition Language (DDL) statements.

Logon Triggers

Describes logon triggers, which fire in response to the LOGON event.

Event Notifications

Describes event notifications as a special kind of database object that can send information about server and database events to a service broker.

User-Defined Functions

Describes how functions are used to centralize tasks and processes within the server

Assemblies

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.

See Also

Concepts

SQL Server Database Engine

Help and Information

Getting SQL Server 2005 Assistance