Beginning SQL Server 2005 for Developers: From Novice to Professional

Author:   Robin Dewson
Publisher:   APress
Edition:   2nd ed.
ISBN:  

9781590595886


Pages:   536
Publication Date:   02 February 2006
Format:   Paperback
Availability:   Manufactured on demand   Availability explained
We will order this item for you from a manufactured on demand supplier.

Our Price $69.99 Quantity:  
Add to Cart

Share |

Beginning SQL Server 2005 for Developers: From Novice to Professional


Add your own review!

Overview

Purchase this book and you'll get the free, fully searchable eBook—a $25 value! (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. You'll learn to use SQL for querying, inserting, updating, and deleting data. You'll also learn how to back up and restore databases for basic administration in SQL Server. Further, you'll cover how to build a complete database, from the fundamentals of relational database design to table and index creation. Additionally, you'll start to program in T-SQL, SQL Servers implementation (and extension) of the SQL programming language, and you'll come away with effective programming techniques using stored procedures and triggers.

Full Product Details

Author:   Robin Dewson
Publisher:   APress
Imprint:   APress
Edition:   2nd ed.
Dimensions:   Width: 17.80cm , Height: 2.70cm , Length: 23.50cm
Weight:   0.943kg
ISBN:  

9781590595886


ISBN 10:   1590595882
Pages:   536
Publication Date:   02 February 2006
Audience:   General/trade ,  General
Format:   Paperback
Publisher's Status:   Active
Availability:   Manufactured on demand   Availability explained
We will order this item for you from a manufactured on demand supplier.

Table of Contents

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.

Reviews

Author Information

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.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions
Latest Reading Guide

MRG2025CC

 

Shopping Cart
Your cart is empty
Shopping cart
Mailing List