Beginning SQL Server 2005 Express for Developers: From Novice to Professional - Brossura

Dewson, Robin

Brossura

ISBN 10: 1590597206 ISBN 13: 9781590597200

Casa editrice: Apress, 2008

Riassunto

Assuming neither database nor programming background, Beginning SQL Server 2005 Express for Developers introduces all the fundamental database administration and SQL programming features of SQL Server 2005 Express Edition, the free relational database management system from Microsoft that provides a major subset of full SQL Server 2005 functionality.

This book is a comprehensive guide that covers installing and configuring SQL Server 2005 Express, creating, backing up, and restoring databases, creating tables, then querying and manipulating them with T-SQL, coding stored procedures and triggers, and using Reporting Services to deliver information to end users. Detailed, clear, and highly readable, this book will make you a competent and confident database administrator and programmer.

• This is the clearest and most comprehensive introduction to SQL Server 2005 Express.
• The book assumes no prior experience with databases, SQL, or programming.
• Youll learn about both database administration and T-SQL programming.
• The book covers SQL Server Management Studio and Reporting Services.

Su questo libro

L'autore

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.

Contenuti

Chapter 1: SQL Server 2005 Express Overview and Installation
Chapter 2: SQL Server Management Studio Express
Chapter 3: Database Design and Creation
Chapter 4: Security
Chapter 5: Defining Tables
Chapter 6: Creating Indexes and Database Diagramming
Chapter 7: Database Backup, Recovery and Maintenance
Chapter 8: Working with the Data
Chapter 9: Building a View
Chapter 10: Stored Procedures
Chapter 11: T-SQL Essentials
Chapter 12: Advanced T-SQL
Chapter 13: Triggers
Chapter 14: SQL Server 2005 Reporting Services
Appendix
Index

Dettagli dell?edizione

• Editore: Apress
• Data di pubblicazione: 2008
• ISBN 10: 1590597206
• ISBN 13: 9781590597200
• Rilegatura: Copertina flessibile
• Lingua: Inglese
• Numero edizione: 1
• Numero di pagine: 464