Beginning SQL Server 2008 Express for Developers: From Novice to Professional takes a developer, and even a DBA, from knowing nothing about SQL Server 2008 Express Edition to being ready to design and build a fully functioning system that is secure, reliable, maintainable, and robust. The Express Edition of SQL Server is a free resource commonly used by students, developers of small systems, and those transferring skills from other databases. This book focuses on the features within the Express Edition and therefore will not confuse readers with coverage of features found only in the Development Edition. By the end of the book, readers will be ready to move on to Accelerated SQL Server 2008 as well as other books within the Apress SQL Server lineup such as Pro SQL Server 2008 Reporting Services . Covers using the free Express Edition of SQL Server Describes creating a database from scratch and builds on this Provides an understanding of SQL Server Express 2008, allowing you to build future solutions for you and your business What yours"ll learn Learn what features exist within SQL Server 2008 Express Edition and how to install and upgrade the product and set up security. Design and create a database. Build database objects, such as tables and stored produres, graphically as well as programmatically. Work with data-inserting, updating, deleting, and retrieving-using simple and complex queries, programs, and data views. Generate reports from data. Implement a solid database maintenance strategy that includes backing up and restoring your data when necessary. Take advantage of advanced TransactSQL techniques to get the most out of your data. Ensure good performance by building the right indexes, defining the right relationships between tables, and joining tables in the most optimal manner. Who is this book for?Anyone interested in working with SQL Server as a database, and particularly those who wish for a nocost database platform that plays well in the .NET environment. Ideal for those starting out in IT or who have to prior database experience. About the Apress Beginning SeriesThe Beginning series from Apress is the right choice to get the information you need to land that crucial entrylevel job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from "novice to professional." Yours"ll start your journey by seeing what you need to know-but without needless theory and filler. Yours"ll build your skill set by learning how to put together realworld projects step by step. So whether your goal is your next career challenge or a new learning opportunity, the Beginning series from Apress will take you there-it is your trusted guide through unfamiliar territory!

SQL Server 2008 Express Overview and Installation	p. 1
SQL Server Management Studio Express	p. 23
Database Design and Creation	p. 53
Security and Compliance	p. 99
Defining Tables	p. 131
Creating Indexes and Database Diagramming	p. 167
Database Backup and Recovery	p. 201
Inserting Data and Transactions	p. 249
Selecting, Updating, and Deleting Data	p. 277
Building a View	p. 321
Stored Procedures and Functions	p. 349
T-Sql	p. 423
Advanced T-SQL	p. 423
Triggers	p. 453
SQL Server 2008 Reporting Services	p. 479
Index	p. 499
Table of Contents provided by Blackwell. All Rights Reserved.

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.