Beginning SQL Server 2008 Express for Developers: From Novice to Professional (Expert's Voice in SQL Server) - Softcover

Dewson, Robin

Softcover

ISBN 10: 1430210907 ISBN 13: 9781430210900

Publisher: Apress, 2008

Synopsis

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 you'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 Transact-SQL 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 no-cost

About this title

About the Author

Robin Dewson has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He has been working with SQL Server since version 6.5 and Visual Basic since version 5. Robin is a consultant mainly in the city of London, where he has been for nearly eight years. He also has been developing a rugby-related website as well as maintaining his own site at Fat-Belly.com.

Edition details

• Publisher: Apress
• Publication date: 2008
• Language: English
• ISBN 10: 1430210907
• ISBN 13: 9781430210900
• Binding: Paperback
• Edition number: 1
• Number of pages: 536