Beginning SQL Server 2008 Express for Developers: From Novice to Professional

Paperback
from $0.00

Author: Robin Dewson

ISBN-10: 1430210907

ISBN-13: 9781430210900

Category: Applications & Languages - Databases

Beginning SQL Server 2008 Express for Developers: From Novice to Professional takes a developer, and even a database administrator, 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...

Search in google:

Express Edition is a free version of SQL Server 2008 that is an excellent choice for those with modest database needs. Robin Dewson’s book on the 2005 edition—according to current sales velocities—is one of the top three best-selling titles on Express Edition. Apress is releasing the 2008 edition of Dewson’s book very early in the SQL Server 2008 life-cycle, from where it should go on to capture significant market-share.

Ch. 1 SQL Server 2008 Express Overview and Installation 1 Ch. 2 SQL Server Management Studio Express 23 Ch. 3 Database Design and Creation 53 Ch. 4 Security and Compliance 99 Ch. 5 Defining Tables 131 Ch. 6 Creating Indexes and Database Diagramming 167 Ch. 7 Database Backup and Recovery 201 Ch. 8 Inserting Data and Transactions 249 Ch. 9 Selecting, Updating, and Deleting Data 277 Ch. 10 Building a View 321 Ch. 11 Stored Procedures and Functions 349 Ch. 12 T-Sql 423 Ch. 13 Advanced T-SQL 423 Ch. 14 Triggers 453 Ch. 15 SQL Server 2008 Reporting Services 479 Index 499