Overview of a Database

Before you use a database, you must first understand how it works. Furthermore, to work with Microsoft SQL Server 2005 Express Edition (SQL Server Express) you need to understand how a relational database management system (RDBMS) works. This section covers database concepts, how to accomplish the basic database tasks, how to use Transact-SQL (the RDBMS language for SQL Server), and how to secure your databases.

In This Section

Topic Description

Performing Database Tasks

Provides links to topics in SQL Server 2005 Books Online about database concepts and database tasks.

Using Transact-SQL

Provides links to topics in SQL Server 2005 Books Online about Transact-SQL and how to use Transact-SQL to perform database tasks.

Performing Security Tasks

Provides links to topics in SQL Server 2005 Books Online about database security and how to use Transact-SQL to perform security tasks.