0
17 years of experience17 years of Excellence
SUBJECTS
ADV. SEARCH
Indian Books on Discounts
  MURACH`S SQL SERVER 2008 FOR DEVELOPERS
 

Murach`S Sql Server 2008 For Developers

by Syverson

  Price : Rs 900.00
  Your Price : Rs 765.00
Discount
15
In Stock
  When we published the first edition of this book, we heard from plenty of developers who were just starting out using Microsoft SQL Server and found this to be a great book for training.
But we also heard from a lot of experienced developers who read it and were amazed to discover how much they didn`t know about SQL. That`s why we`ve dubbed this book `the SQL book that most developers don`t even know they need.`
So whether you`re new to SQL...or whether you`ve been squeaking by with the SQL you know, never realizing how much you`re missing out on...this is the book for you.
For example, you`ll learn:How to create complex inner and outer joins, summary queries, and subqueries that do more of the database processing for you so that your applications can do less

What the different data types are and how to handle the common problems you run into with various types of data

How to work with XML data

How to take advantage of powerful backend database features like views, scripts, stored procedures, and triggers

How to deal with database control features like cursors, transactions, and locking

The basics of database design and implementation using the Management Studio or SQL DDL statements (you can write more efficient queries when you know something about how databases are set up…and you can start to see what your DBA has to think about, if that`s a career path that interests you)

How to use the CLR integration feature to create database objects using C# or Visual Basic code What`s NEW in this 2008 editionThis new edition now covers the 2008 features that make a developer`s job easier:The FILESTREAM storage feature allows you to work more efficiently with binary large objects (BLOBs) such as image, sound, and video files.
The MERGE statement allows you to use a single statement to make multiple updates and insertions.

The date, time, datetime2, and datetimeoffset data types give you more flexibility and precision for working with dates and times.

The user-defined table type allows you to pass a table as a parameter to a stored procedure or a function - a feat that previously required custom coding and often resulted in code that was difficult to maintain.

In terms of database design, the SPARSE attribute can help you work with NULL values more efficiently, and filtered indexes can allow you to retrieve data more quickly.Beyond that, this book covers many other 2008 features that you`ll find useful in specific situations. And, of course, the code presented in this book has been thoroughly updated and tested against SQL Server 2008.
About the Author
Joel Murach has been writing and editing for more than 10 years. During that time, he sharpened his programming skills as a contract programmer in San Francisco and his instructional skills as a trainer for HarperCollins Publishing. He always brings a vision to his projects that leads to improved effectiveness for his readers.
ISBN - 9788184046533
 


Pages : 802
Credit Cards
Payment accepted by All Major Credit and Debit Cards, Net Banking, Cash Cards, Paytm, UPI, Paypal. Our payment gateways are 100% secure.
Check Delivery
Books by Same Author
15%
Murach`s SQL Server 2005 for Developers
by Bryan Syverson, Joel Murach
15%
MURACH`S SQL SERVER 2008 FOR DEVELOPERS
by SYVERSON
Brand About : A Seriously Playful Approach for Passionate Brand-Builders and Merchants
by Andrea Syverson
15%
Murach`s SQL Server 2012 for Developers
by Joel Murach, Bryan Syverson
15%
Murach`s SQL For SQL Server
by Syverson
Books of Similar Interest
10%
Overhead Line Practice
by Krishna Pillai
18%
Understanding English II
by Want
15%
Operations Research: A Systems Engineering Approach - Edition 01
by Dahe
22%
Truly Devious
by Maureen Johnson
10%
Genome Mapping and Molecular Breeding in Plants: Vegetables (HB)
by Chittaranjan Kole
Best Book Mart
Support

Call Us Phone : +91-9266663909
Email Us Email : support [at] bestbookmart.com
Working Hours Timing : 10:00 AM to 6:00 PM (Mon-Fri)
Powered By
CCAvenue
SSL Protection