Microsoft^? SQL Server^TM 2005 Express Edition For Dummies^?

by Robert D. Schneider (San Carlos, CA )

• ISBN13: 9780470044087
• ISBN10: 047004408X
• Format: eBook
• Copyright: 2006-06-01
• Publisher: For Dummies

Summary

Delivers the know-how that novice database developers, enthusiasts, and independent software vendors need in order to use the SSE database Written in the typical nonintimidating For Dummies style, the book's emphasis is on installing SSE and using it to create simple database applications with other tools in Microsoft's Express product line Covers how to use SQL Server Express Manager, an easy-to-use management tool that comes with SSE, and the Application XCopy feature, which provides SSE with the ability to treat databases like files Addresses topics unique to SSE and not covered in standard SQL Server books, including network and security features, migrating and connecting from Access and MSDE to SSE, and migrating from SSE to the full-blown SQL Server database The CD-ROM contains SQL Server Express trial version and the Web site has the code from applications featured in the book Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Table of Contents

Introduction

Welcome to SQL Server 2005 Express

SQL Server 2005 Express Overview

Downloading and Installing SQL Server 2005 Express on Your Computer

Setting Up SQL Server Express

Administering a SQL Server 2005 Express System

Putting SQL Server 2005 Express to Work

Maintaining a SQL Server 2005 Express System

Distributing Your Data with Replication

Adding and Accessing a SQL Server 2005 Express Database

Planning Your Database

Creating Databases, Tables, and Relationships

Talking to a SQL Server

Transact-SQL: Beyond the Basics

Keeping Your Data Safe from Harm

Securing Your Data

Keeping It Together: Using Transactions to Maintain Data Integrity

Preventing Data Loss

Putting the Tools to Work: Programming with SQL Server 2005 Express

Using Stored Procedures and Functions

Understanding Triggers

Going Beyond Transact-SQL: Using the SQL Common Language Runtime (SQLCLR)

Sorry, I'll Try That Again: Adding Error Handling to Your Code

Full-Text Searching and Reporting Services

Creating SQL Server 2005 Express Applications

Building a Simple Desktop Application with Visual Basic Express

Building a Simple Web Application with Visual Web Developer Express

Using XML with SQL Server 2005 Express

The Part of Tens

Ten Sources of Information on SQL Server 2005 Express

Ten SQL Server 2005 Express Troubleshooting Tips

Appendixes

Upgrading to SQL Server 2005

Migrating to SQL Server 2005 Express

Glossary

About the CD-ROM

Index

Table of Contents provided by Publisher. All Rights Reserved.