Beginning SQL Server 2005 for Developers
From Novice to Professional
2nd Edition
Published on 2. February 2006
Book
Paperback/Softback
XXIV, 536 pages
978-1-59059-588-6 (ISBN)
Description
SQL Server 2005 is the next generation of the SQL Server database. It is the number one relational database for the Windows platform and represents a great leap forward for SQL server developers in terms of programming options, productivity, database management, and analysis. So if you have some basic knowledge of relational databases, and are looking to start a development career using SQL Server, then this book is the ideal first step.
This book also provides practical advice, answers typical questions that you'll encounter from managers and DBAs, and offers practical steps to overcome issues with which beginners traditionally struggle. At every stage, it establishes a range of tried-and-tested practices and techniques that mark you out as a competent developer from the very start.
More details
Edition
2nd ed.
Language
English
Place of publication
Berkeley
United States
Target group
Popular/general
Edition type
Revised edition
Product notice
Paperback (trade)
Unsewn / adhesive bound
Illustrations
XXIV, 536 p.
Dimensions
Height: 236 mm
Width: 179 mm
Thickness: 27 mm
Weight
826 gr
ISBN-13
978-1-59059-588-6 (9781590595886)
DOI
10.1007/978-1-4302-0124-3
Schweitzer Classification
Other editions
Additional editions
E-Book
11/2006
2nd Edition
APress
€46.00
Available for download
Previous edition
Robin Dewson
Beginning SQL Server 2000 Programming
Book
09/2003
Apress
€41.72
Article exhausted; check for reprint
Person
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.
Content
SQL Server 2005 Overview and Installation.- SQL Server Management Studio.- Database Design and Creation.- Security.- Defining Tables.- Creating Indexes and Database Diagramming.- Database Backups, Recovery, and Maintenance.- Working with the Data.- Building a View.- Stored Procedures.- T-SQL Essentials.- Advanced T-SQL.- Triggers.- SQL Server 2005 Reporting Services.