Features
- Cover Type: Paperback with 536 pages
- Published by: Apress
- Edition: 1st Edition January 30, 2006
- Written in: English
- ISBN 10 Number: 1590595882
- ISBN 13 Number: 978-1590595886
-
Book Dimensions:
9.2 x 7 x 1.2 inches
- Weighs: 1.8 pounds
Product Description
Purchase this book and you'll get the free, fully searchable eBooka $25value! (Details are printed inside the book.)
SQL Server 2005 will increase your programming options, productivity, analysis, and database management. If you have some basic knowledge of relational databases and want to start a career as a developer using SQL Server, then this book is your ideal first step. It explains the core jobs and roles for developing a database in both SQL Server 2000 and 2005.
This book features practical steps to help you overcome issues youre likely to encounter. Youll learn to use SQL for querying, inserting, updating, and deleting data. Youll also learn how to back up and restore databases for basic administration in SQL Server. Further, youll cover how to build a complete database, from the basics of relational database design to table and index creation.
Additionally, youll start to program in T-SQL, SQL Servers implementation (and extension) of the SQL programming language, and youll come away with effective programming techniques using stored procedures and triggers.
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 www.fat-belly.com.
Reader ReviewsThis book is not bad for browsing to see if anything has changed from sql server 2000 to 2005. I like the book since it is clean and quick to go through. It would have helped if the author ziped up a detached version of the apressFinancial database since for a beginner this book can be a real pain in the neck to go through since no data to work with. the other problem I have with the book is that it is misleading to say novice to professional. This book does not have even midlevel skills we need to do most database work with sql server 2005 let alone not introduce you to a majority of the new features of the sql server 2005 we need to do our jobs