Items related to Murach's SQL Server 2005 for Developers

Murach's SQL Server 2005 for Developers - Softcover

 
9781890774394: Murach's SQL Server 2005 for Developers

Synopsis

Appropriate for beginners or experienced developers who want to build their SQL skills, this tutorial introduces SQL statements for querying a database, maintaining data, creating a table, processing scripts, and managing transactions. The information is presented in paired pages, with all of the example code, syntax and tips on the right-hand page, and detailed explanation on the left. The second edition covers common table expressions, error handling features, database schema statements, XML integration, and CLR integration new to SQL Server 2005. Annotation ©2007 Book News, Inc., Portland, OR (booknews.com)

"synopsis" may belong to another edition of this title.

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.

Synopsis

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.

"About this title" may belong to another edition of this title.

  • PublisherMike Murach & Associates Inc.
  • Publication date2006
  • ISBN 10 1890774391
  • ISBN 13 9781890774394
  • BindingPaperback
  • LanguageEnglish
  • Number of pages688

Buy Used

Condition: Good
Most items will be dispatched the...
View this item

£ 2.20 shipping within United Kingdom

Destination, rates & speeds

Buy New

View this item

£ 33.17 shipping from U.S.A. to United Kingdom

Destination, rates & speeds

Search results for Murach's SQL Server 2005 for Developers

Seller Image

Syverson, Bryan
Published by Mike Murach & Associates Inc., 2006
ISBN 10: 1890774391 ISBN 13: 9781890774394
Used Softcover

Seller: WeBuyBooks, Rossendale, LANCS, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: Good. Most items will be dispatched the same or the next working day. A copy that has been read but remains in clean condition. All of the pages are intact and the cover is intact and the spine may show signs of wear. The book may have minor markings which are not specifically mentioned. Seller Inventory # wbs5592395733

Contact seller

Buy Used

£ 35.09
Convert currency
Shipping: £ 2.20
Within United Kingdom
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Syverson, Bryan; Murach, Joel
Published by Mike Murach & Associates, 2006
ISBN 10: 1890774391 ISBN 13: 9781890774394
Used Paperback

Seller: ThriftBooks-Dallas, Dallas, TX, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback. Condition: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less 3.15. Seller Inventory # G1890774391I3N00

Contact seller

Buy Used

£ 16.39
Convert currency
Shipping: £ 21.14
From U.S.A. to United Kingdom
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Bryan Syverson, Joel Murach
Published by Mike Murach & Associates, 2006
ISBN 10: 1890774391 ISBN 13: 9781890774394
New Paperback

Seller: The Book Spot, Sioux Falls, MN, U.S.A.

Seller rating 4 out of 5 stars 4-star rating, Learn more about seller ratings

Paperback. Condition: New. Seller Inventory # Abebooks511193

Contact seller

Buy New

£ 44.80
Convert currency
Shipping: £ 33.17
From U.S.A. to United Kingdom
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Syverson, Bryan,Murach, Joel
Published by Mike Murach & Associates Inc, 2006
ISBN 10: 1890774391 ISBN 13: 9781890774394
Used paperback

Seller: HPB-Emerald, Dallas, TX, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

paperback. Condition: Very Good. Connecting readers with great books since 1972! Used books may not include companion materials, and may have some shelf wear or limited writing. We ship orders daily and Customer Service is our top priority! Seller Inventory # S_420669023

Contact seller

Buy Used

£ 13.37
Convert currency
Shipping: £ 84.78
From U.S.A. to United Kingdom
Destination, rates & speeds

Quantity: 1 available

Add to basket