Beginning T-SQL 2012

5.0 stars
1 review ratings
Q&A
Walmart #: 9781430237044
$45.99
FREE shipping available on $50 + orders
If your order totals $50 or more and you select Value shipping, this item and any other qualifying items ship for free!
FREE pickup
Sold by Walmart.com

Click on these options to see if you can get it by Christmas

 
Showing options for 07095
Type
Value
Data unavailable
$4.97
Standard
Data unavailable
$6.97
Expedited
Data unavailable
$8.97
Rush
Data unavailable
$10.97
 
Showing options for 07095
Paperback, Springer-Verlag New York Inc, 2011, ISBN13 9781430237044, ISBN10 143023704X

About this item

Beginning T-SQL 2012 is the first step toward learning the T-SQL language that underlies Microsofts SQL Server database engine. T-SQL is essential in writing SQL statements to get data into and out of a database. T-SQL is the foundation for business logic embedded in the database in the form of stored procedures and functions. Beginning T-SQL 2012 starts you on the path to mastering T-SQL, with an emphasis on best practices and sound coding techniques.

Beginning T-SQL 2012 begins with an introduction to databases, normalization, and to SQL Server Management Studio. Each subsequent chapter teaches an aspect of T-SQL, building on the skills learned in previous chapters. Exercises in each chapter give readers an opportunity for the hands-on practice that leads to true learning and distinguishes the competent professional.

  • Imparts best practices for writing T-SQL
  • Helps you avoid common errors
  • Shows how to write scalable code for good performance

What youll learn

  • The fundamentals of relational theory, upon which Transact-SQL is based
  • How to write accurate queries that are scalable and perform well
  • How to combine set-based and procedural processing, obtaining the best from both worlds
  • How to embed business logic in your database through stored procedures and functions
  • How to simplify your work with new and advanced features, such as common table expressions and virtual tables
  • How to enhance performance by knowing when to apply features such table value parameters, and when not to

Who this book is for

Beginning T-SQL 2012 is for developers and database administrators who will be writing database applications against SQL Server databases.

Table of Contents

  • Getting Started
  • Writing Simple SELECT Queries
  • Using Functions and Expressions
  • Querying Multiple Tables
  • Grouping and Summarizing Data
  • Manipulating Data
  • Understanding T-SQL Programming Logic
  • Working with XML
  • Moving Logic to the Database
  • Working with Data Types
  • Writing Advanced Queries
  • Where to Go Next?
  • Specifications

    Publisher: Apress L. P.
    Publish Date: Jul 04, 2012
    ISBN-13: 9781430237044
    ISBN-10: 143023704X
    Format: Paperback
    Number of Pages: 433
    Written in: ENG
    Shipping Weight (in pounds): 1.75
    Product in Inches (L x W x H): 7.75 x 9.5 x 1.0
    Walmart No.: 9781430237044
    Show

    Customer reviews

    Customer Reviews | 1 review | 5 out of 5

    5.0 stars

    1 review | 5 out of 5

    5 stars
    1
    4 stars
    0
    3 stars
    0
    2 stars
    0
    1 stars
    0
    100%
    Would recommend to a friend

    Age

    Gender

    Great Book
    6/26/2014

    Customer review by ibeetb

    5.0 stars by ibeetb

    The book is easy to follow with great examples

    Was this review helpful? (0) (0)
    Thank you! You have successfully submitted feedback for this review.
    ibeetb
    Would recommend to a friend? Yes
    Verified purchaser
    Verified purchaser
    Customer has been confirmed to have purchased the item from Walmart.

    Customer Q&A

    Have questions? Get answers from experts and customers who own this product.

    Ask a question

    If you would like to share feedback with us about pricing, delivery or other customer service issues, please contact customer service directly.


    Q&A tips and guidelines

    Q&A Exchange Guidelines

    When writing your question or answer, please follow these guidelines:

    • Do: Make sure your question is directly related to the product
    • Do: Be specific and provide as many details as possible
    • Do: Include the model number (if applicable)
    • Do: Write your question in English
    • Do Not: Include personal information (such as your full name)
    • All submitted questions and answers are subject to the terms set forth in our Terms and Conditions

    We reserve the right not to post your question or answer if it contains any of the following:

    • Any information not related to the actual merchandise or topic
    • Obscenities, discriminatory language or other language not suitable for a public forum
    • Advertisements or “spam” content
    • Email addresses, physical addresses or other forms of contact information
    • Critical or spiteful comments on other questions or answers posted on the page or their authors
    • Any imagery that demonstrates incorrect use of the merchandise
    • Anything that Walmart deems to be inappropriate, at Walmart's discretion

    Provide as many details as possible, including the model number (if applicable).

    Remember: Don’t include personal information (such as your full name).


    Preview Question

    Walmart does not sponsor, recommend or endorse any third party product or service, or any customer ideas or advice.

    Thank you.

    Questions will be checked against our question guidelines and posted within five to seven business days.

    Product Recommendations

    Your recently viewed items

    Clear this list