Computers & Internet Books:

Murach's SQL Server 2008

Sorry, this product is not currently available to order

Here are some other products you might consider...

Murach's SQL Server 2008

Format

Paperback

Customer rating

Click to share your rating 0 ratings (0.0/5.0 average) Thanks for your vote!

Share this product

Murach's SQL Server 2008 by Bryan Syverson
Unavailable
Sorry, this product is not currently available to order

Description

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.

Table of Contents

An introduction to SQL; An introduction to relational databases and SQL; How to use the Management Studio; How to retrieve data from a single table; How to retrieve data from two or more tables; How to code summary queries; How to code subqueries; How to insert, update, and delete data; How to work with data types and functions; How to design a database; How to create and maintain databases and tables with SQL statements; How to use the Management Studio for database design; How to work with views; How to code scripts; How to code stored procedures, functions, and triggers; How to work with cursors; How to manage transactions and locking; How to manage database security; How to work with XML; How to work with BLOBs; An introduction to CLR integration; How to code CLR stored procedures, functions, and triggers; How to code aggregate functions and user-defined types; Index.
Release date NZ
January 1st, 2009
Country of Publication
United States
Illustrations
316 b/w illus
Imprint
Mike Murach & Associates Inc.
Pages
780
Dimensions
250x200x36
ISBN-13
9781890774516
Product ID
2967577

Customer reviews

Nobody has reviewed this product yet. You could be the first!

Write a Review

Marketplace listings

There are no Marketplace listings available for this product currently.
Already own it? Create a free listing and pay just 9% commission when it sells!

Sell Yours Here

Help & options

  • If you think we've made a mistake or omitted details, please send us your feedback. Send Feedback
  • If you have a question or problem with this product, visit our Help section. Get Help
Filed under...

Buy this and earn 673 Banana Points