Beginning SQL Server 2005 for Developers: From Novice to Professional / Edition 2

Beginning SQL Server 2005 for Developers: From Novice to Professional / Edition 2

by Robin Dewson
     
 

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

See more details below

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.

Read More

Product Details

ISBN-13:
9781590595886
Publisher:
Apress
Publication date:
02/02/2006
Series:
Expert's Voice Series
Pages:
536
Product dimensions:
9.25(w) x 7.50(h) x 1.08(d)

Related Subjects

Table of Contents

1SQL Server 2005 overview and installation1
2SQL Server management studio25
3Database design and creation53
4Security95
5Defining tables119
6Creating indexes and database diagramming153
7Database backups, recovery, and maintenance185
8Working with the data245
9Building a view309
10Stored procedures335
11T-SQL essentials359
12Advanced T-SQL403
13Triggers427
14SQL Server 2005 reporting services451

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >