Murach's SQL Server 2012
Murach's SQL Server 2012


Book summary

Table of contents

Who this book is for

What people say about this book

Related books

FREE download of chapter 3

FREE download of the book examples

What software you need

Instructor's CD

FAQs

Book corrections

      Home | Books | Downloads | Trainers | Instructors | Customer Service

view cart

Murach's SQL Server 2012 for Developers
by Bryan Syverson and Joel Murach
23 chapters, 794 pages, 341 illustrations
Published August 2012
ISBN: 978-1-890774-69-1

Book price: $54.50; SAVE 30%, now just $38.15
eBook price: $44.50; SAVE 30%, now just $31.15
Book + eBook: $64.50; Best Value! SAVE 30%, now just $45.15

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 use built-in functions to handle everyday challenges like manipulating character data, rounding numbers, and working with date/time values
  • 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
  • How to use the FILESTREAM storage feature to work efficiently with binary large objects (BLOBs), such as image, sound, and video files
  • 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 database design...and you'll 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 by using SSDT (SQL Server Data Tools) with C# or Visual Basic

Ready to master all of this?

Then let SQL Server 2012 for Developers quickly boost you to a new level of competence and professionalism.


More about the eBook



      To contact us, call us at (800) 221-5528 or email us at murachbooks@murach.com

      Home | Books | Downloads | Trainers | Instructors | Customer Service

view cart