This topic has not yet been rated - Rate this topic

Database Tasks (SQL Server Express)

SQL Server 2008 R2

The major tasks associated with working with a database are planning, designing, implementing, optimizing and maintaining. The following table lists topics in SQL Server 2008 Books Online that describe how to understand and perform these tasks, giving novice users a conceptual grounding in how databases work.

Important
The topics listed below might refer to user interface elements or features that are not supported by SQL Server Express. For more information about feature support, see Overview of SQL Server Express.

Database task	SQL Server Books Online topic
Plan a database	Database Basics System Databases Understanding Files and Filegroups Transaction Log Overview Developing a Database Plan Table Basics Table Planning Guidelines Index Basics Types of Indexes Transactions (Database Engine) Stored Procedure Basics User-Defined Function Basics Types of Functions Types of Stored Procedures PRIMARY KEY Constraints FOREIGN KEY Constraints
Design a database	Designing Databases Online Transaction Processing vs. Decision Support Normalization Data Integrity Data Integrity Basics Database Performance Estimating the Size of a Database Designing Files and Filegroups Designing Stored Procedures (Database Engine)
Implement a database	Creating a Database (Database Engine) Modifying a Database Setting Database Options Renaming a Database Changing the Database Owner Inserting Data into a Table Adding Rows by Using INSERT and SELECT Changing Data by Using UPDATE Deleting Rows by Using DELETE Creating and Modifying PRIMARY KEY Constraints Creating and Modifying FOREIGN KEY Constraints
Optimize a database	Optimizing Databases Index Design Basics Types of Indexes Understanding Views
Maintain a database	Maintaining Databases (Database Engine) Backing Up and Restoring Databases in SQL Server Considerations for Backing Up and Restoring System Databases Monitoring and Tuning for Performance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD