Items related to Murach's SQL Server 2008 for Developers

Murach's SQL Server 2008 for Developers - Softcover

 
9781890774516: Murach's SQL Server 2008 for Developers

Synopsis

Every application developer who uses SQL Server 2008 should own this book. To start, this 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, XML data, and BLOB data with FILESTREAM storage. These features allow you to create database applications that are thoroughly professional. Finally, this book shows how to use the CLR integration feature, so you can use C# or Visual Basic to code stored procedures, functions, triggers, aggregate functions, and user-defined types.

"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 of all 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 2008 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, merging, 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 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 teaches you how to use SQL features to work with XML data. And it shows you how to use the 2008 FILESTREAM storage feature to work with binary large objects (BLOBs) such as image, sound, and video files. These are the features that give a DBMS 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. This feature allows you to create database objects like stored procedures and user-defined types using a .NET language like C# or Visual Basic.

About the Author

Joel Murach has been writing and editing books about computer programming for over 10 years. During that time, he has written extensively on a wide range of Java, .NET, web, and database technologies. When he's not programming or writing books about programming, he can be found surfing or writing music.

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

  • PublisherMike Murach & Associates Inc.
  • Publication date2008
  • ISBN 10 1890774510
  • ISBN 13 9781890774516
  • BindingPaperback
  • LanguageEnglish
  • Edition number3
  • Number of pages780

Buy Used

Condition: Good
Used book that is in clean, average...
View this item

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

Destination, rates & speeds

Other Popular Editions of the Same Title

9788184046533: Murach's SQL Server 2008 for Developers

Featured Edition

ISBN 10:  8184046537 ISBN 13:  9788184046533
Publisher: Shroff Publishers & Distribu..., 2008
Softcover

Search results for Murach's SQL Server 2008 for Developers

Stock Image

Murach, Joel, Syverson, Bryan
Published by Mike Murach & Associates, Inc., 2008
ISBN 10: 1890774510 ISBN 13: 9781890774516
Used Softcover

Seller: Better World Books, Mishawaka, IN, U.S.A.

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

Condition: Good. 3rd. Used book that is in clean, average condition without any missing pages. Seller Inventory # GRP97562586

Contact seller

Buy Used

£ 4.40
Convert currency
Shipping: £ 9.32
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, 2008
ISBN 10: 1890774510 ISBN 13: 9781890774516
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: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 3.5. Seller Inventory # G1890774510I4N00

Contact seller

Buy Used

£ 5.45
Convert currency
Shipping: £ 23.57
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, 2008
ISBN 10: 1890774510 ISBN 13: 9781890774516
Used Paperback

Seller: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.

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

Paperback. Condition: As New. No Jacket. Pages are clean and are not marred by notes or folds of any kind. ~ ThriftBooks: Read More, Spend Less 3.5. Seller Inventory # G1890774510I2N00

Contact seller

Buy Used

£ 5.45
Convert currency
Shipping: £ 23.57
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, 2008
ISBN 10: 1890774510 ISBN 13: 9781890774516
Used Paperback

Seller: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.

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

Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 3.5. Seller Inventory # G1890774510I4N00

Contact seller

Buy Used

£ 5.45
Convert currency
Shipping: £ 23.57
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, 2008
ISBN 10: 1890774510 ISBN 13: 9781890774516
Used Softcover

Seller: Hawking Books, Edgewood, TX, U.S.A.

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

Condition: Very Good. Very Good Condition. Five star seller - Buy with confidence! Seller Inventory # X1890774510X2

Contact seller

Buy Used

£ 5.29
Convert currency
Shipping: £ 49.58
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, 2008
ISBN 10: 1890774510 ISBN 13: 9781890774516
Used paperback

Seller: Half Price Books Inc., 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_425679057

Contact seller

Buy Used

£ 10
Convert currency
Shipping: £ 85.10
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, 2008
ISBN 10: 1890774510 ISBN 13: 9781890774516
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_436803925

Contact seller

Buy Used

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

Quantity: 1 available

Add to basket