Creating and Maintaining Databases Overview
A client/server database system comprises 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™ 2000 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, allowing 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 ensure that your database performs optimally.
|Databases||Describes how databases are used to represent, manage, and access data.|
|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 the data in the table.|
|Views||Describes views and their usefulness in providing an alternative way of looking at the data in one or more tables.|
|Stored Procedures||Describes how these Transact-SQL programs centralize business rules, tasks, and processes within the server.|
|Enforcing Business Rules with Triggers||Describes the function of triggers as special types of stored procedures executed only when data in a table is modified.|
|Full-Text Indexes||Describes how full-text indexes facilitate the querying of data stored in character-based columns, such as varchar and text.|