or
Sign in to turn on 1-Click ordering.
 
 
More Buying Choices
15 used & new from £25.52
Have one to sell? Sell yours here
 
   
Murach's SQL Server 2005 for Developers
 
 
Share your own customer images
Search inside this book

Murach's SQL Server 2005 for Developers (Paperback)

by Bryan Syverson (Author), Joel Murach (Author)
5.0 out of 5 stars  See all reviews (2 customer reviews)
RRP: £43.99
Price: £25.52 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £18.47 (42%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

Only 3 left in stock--order soon (more on the way).

Want guaranteed delivery by Friday, November 13? Choose Express delivery at checkout. See Details
11 new from £25.52 4 used from £28.30

Frequently Bought Together

Murach's SQL Server 2005 for Developers + Murach's ADO.NET 3.5 LINQ & the Entity Framework with VB 2008 (Murach: Training & Reference) + Murach's Visual Basic 2005
Price For All Three: £89.79

Show availability and delivery details

Customers Who Bought This Item Also Bought

Murach's C# 2008 (Training & Reference)

Murach's C# 2008 (Training & Reference)

by Joel Murach
5.0 out of 5 stars (2)  £26.91
Murach's ADO.NET 3.5 LINQ & the Entity Framework with VB 2008 (Murach: Training & Reference)

Murach's ADO.NET 3.5 LINQ & the Entity Framework with VB 2008 (Murach: Training & Reference)

by Anne Boehm
4.5 out of 5 stars (2)  £26.88
Murach's Visual Basic 2005

Murach's Visual Basic 2005

by Anne Boehm
£37.39
Murach's Visual Basic 2008 (Murach: Training & Reference)

Murach's Visual Basic 2008 (Murach: Training & Reference)

by Anne Boehm
3.5 out of 5 stars (2)  £26.26
Murach's ASP.NET 3.5 Web Programming with C# 2008

Murach's ASP.NET 3.5 Web Programming with C# 2008

by Anne Boehm
£27.95
› Explore similar items

Product details

  • Paperback: 702 pages
  • Publisher: Mike Murach & Associates Inc. (14 Mar 2007)
  • Language English
  • ISBN-10: 1890774391
  • ISBN-13: 978-1890774394
  • Product Dimensions: 25.2 x 20 x 4 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon.co.uk Sales Rank: 227,213 in Books (See Bestsellers in Books)

    Popular in these categories:

    #31 in  Books > Computing & Internet > Microsoft Windows > Programming > SQL Server
    #86 in  Books > Computing & Internet > Databases > Applications > Microsoft SQL Server

    •  Would you like to update product info or give feedback on images?

  • See Complete Table of Contents

Customers Viewing This Page May Be Interested in These Sponsored Links

  (What is this?)
   SQL Server Development UK opens new browser window
www.pulsion.co.uk  -  Fixed price projects delivered. In-house experts.Competitive rates. 
   Rackspace SQL Hosting opens new browser window
www.rackspace.co.uk/databasehosting  -  Fast, secure SQL hosting. Award winning support 24/7. 
   SQL Server opens new browser window
www.technicaldirect.co.uk  -  Microsoft SQL Server Experts Microsoft Gold Partner 
  
 

Product Description

Product Description

Every application developer who uses SQL Server 2005 should own this book. To start, the book presents the essential SQL statements for retrieving and updating the data in a database, because that's what every application developer needs to know. Then, it shows you how to design and create a database, because application developers often end up in the role of database designer and DBA. Next, it shows how to work with views, scripts, stored procedures, functions, triggers, cursors, transactions, locking, security, and XML integration so you can create database applications that are thoroughly professional. Finally, it shows how to use the new CLR integration feature, so you can use C# or Visual Basic to code stored procedures, functions, triggers, aggregate functions, and user-defined types.


From the Publisher

The SQL book that most developers don't even know they need - that's how I
think of this book.

To be an effective application developer, you need to master SQL for the
database you're going to be using. But many developers get by with the SQL
they know, never realizing how much they're missing out on.

So this is first a book for developers who use Microsoft SQL Server as
their DBMS (though it can help you if you want to master standard SQL,
too). No matter how much SQL experience you have, you'll find new features
that you haven't been taking advantage of.

In section 1, you'll learn the concepts and terms you need for working with
any database. You'll also learn how to use the Microsoft SQL Server 2005
Management Studio to work with queries and databases. At that point, you'll
be prepared for rapid progress as you learn SQL.

In section 2, you'll learn all the skills for retrieving data from a
database and for adding, updating, and deleting that data. These skills
move from the simple to the complex so you won't have any trouble if you're
a SQL novice. And they present skills like using outer joins, summary
queries, and subqueries that will raise your SQL expertise if you do have
SQL experience.

In section 3, you'll learn how to design a database and how to implement
that design by using either SQL DDL (Data Definition Language) statements
or the Management Studio. When you're done, you'll be able to design and
implement your own databases. But even if you're never called upon to do
that, this section will give you perspective that will make you a better
SQL developer.

Section 4 presents the skills for working with database features like
views, stored procedures, functions, triggers, cursors, transactions, and
security. It also teaches you how to use the enhanced SQL features for
working with XML data. These are the features that give a database
management system much of its power and that give you an extra edge in your
SQL skills.

To complete your SQL Server skills, section 5 shows you how to use the CLR
integration feature that's new in SQL Server 2005. This feature allows you
to create database objects like stored procedures and user-defined types
using any .NET language, like C# or Visual Basic.

Inside This Book (Learn More)
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 
(1)
(1)
(1)
See all 6 tags...

Your tags: Add your first tag
 
See most popular tags

What Do Customers Ultimately Buy After Viewing This Item?

Murach's SQL Server 2005 for Developers
78% buy the item featured on this page:
Murach's SQL Server 2005 for Developers 5.0 out of 5 stars (2)
£25.52
Murach's SQL Server 2008 for Developers
9% buy
Murach's SQL Server 2008 for Developers
£26.54
SQL Server 2005 Bible
5% buy
SQL Server 2005 Bible 4.5 out of 5 stars (2)
£19.79
Murach's ASP.NET 3.5 Web Programming with C# 2008
5% buy
Murach's ASP.NET 3.5 Web Programming with C# 2008
£27.95
Explore similar items
 

Customer Reviews

2 Reviews
5 star:
 (2)
4 star:    (0)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
5.0 out of 5 stars (2 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
1 of 1 people found the following review helpful:
5.0 out of 5 stars Everything about SQL Server you need to know, 20 Jan 2008
By Michael Ayers (United Kingdom) - See all my reviews
(REAL NAME)   
This is my first look at the Murach series of computer books and I am well impressed.

As a .NET developer I have always used SQL Server, but only used the basics to store and update data, I thought it was about time I began using and understand SQL Server more.

I was not dissapointed, the contents are well laid out and covered comprehensively.

I particually liked the style of the subject being explained on the left page and an example on the right page.

The book can be read from start to finish or simply as a reference because each subject is clearly laid out, so if you have a paticular problem, simply find the area covered in the book and there is a quick working example.

The contents cover database design, scripts, views, stored procedures, Joins, Transaction processing and so much more.

Well worth the money
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
5.0 out of 5 stars Great to learn SQL not only for SQL Server, 1 Dec 2008
By Martin Holzke - See all my reviews
(REAL NAME)   
If you're looking for a great book to learn all the twists and turns of SQL - the query language..here you go. While of course somewhat tailored to SQL Server, the vast majority of the book is standard compliant and hence applicable to almost any database out.
The wealth of examples and a database and scripts to download makes it a superb book for (self) trainings.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Only search this product's reviews


Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

   

Look for similar items by category

Look for similar items by subject













i.e., each product must be in subject 1 AND subject 2 AND ...

Feedback

Ad

Your Recent History

 (What's this?)

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.