9780672337925

Microsoft SQL Server T-SQL in 10 Minutes, Sams Teach Yourself

by
  • ISBN13:

    9780672337925

  • ISBN10:

    0672337924

  • Edition: 2nd
  • Format: Paperback
  • Copyright: 12/16/2016
  • Publisher: Sams Publishing
  • Purchase Benefits
  • Free Shipping On Orders Over $59!
    Your order must be $59 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
  • eCampus.com Device Compatibility Matrix

    Click the device icon to install or view instructions

    Apple iOS | iPad, iPhone, iPod
    Android Devices | Android Tables & Phones OS 2.2 or higher | *Kindle Fire
    Windows 10 / 8 / 7 / Vista / XP
    Mac OS X | **iMac / Macbook
    Enjoy offline reading with these devices
    Apple Devices
    Android Devices
    Windows Devices
    Mac Devices
    iPad, iPhone, iPod
    Our reader is compatible
     
     
     
    Android 2.2 +
     
    Our reader is compatible
     
     
    Kindle Fire
     
    Our reader is compatible
     
     
    Windows
    10 / 8 / 7 / Vista / XP
     
     
    Our reader is compatible
     
    Mac
     
     
     
    Our reader is compatible
List Price: $29.99 Save up to $11.66
  • Buy New
    $25.49

    NOT YET PRINTED. PLACE AN ORDER AND WE WILL SHIP IT AS SOON AS IT ARRIVES.

Supplemental Materials

What is included with this book?

  • The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
  • The eBook copy of this book is not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Summary

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through the book’s 30 lessons of 10 minutes or less, you’ll learn what you need to know to take advantage of Microsoft SQL Server’s T-SQL language.

 

This handy pocket guide starts with simple data retrieval and moves on to more complex topics, including the use of joins, subqueries, full text-based searches, functions and stored procedures, cursors, triggers, table constraints,

XML, JSON, and much more.

 

Tips point out shortcuts and solutions

Cautions help you avoid common pitfalls

Notes explain additional concepts, and provide additional information

 

10 minutes is all you need to learn how to…

 

  • Use T-SQL in the Microsoft SQL Server environment
  • Construct complex T-SQL statements using multiple clauses and operators
  • Filter data so you get the information you need quickly
  • Retrieve, sort, and format database contents
  • Join two or more related tables
  • Make SQL Server work for you with globalization and localization
  • Create subqueries to pinpoint your data
  • Automate your workload with triggers
  • Create and alter database tables
  • Work with views, stored procedures, and more

 

Author Biography

Ben Forta is Adobe Systems’ Senior Director of Education Initiatives and has more than three decades of experience in the computer industry in product development, support, training, and product marketing. He is the author of the best-selling Sams Teach Yourself SQL in 10 Minutes, spinoff titles (like this one), the ColdFusion Web Application Construction Kit series, Sams Teach Yourself Regular Expressions in 10 Minutes, as well as books on Flash, Java, Windows, and other subjects. He has extensive experience in database design and development, has implemented databases for several highly successful commercial software programs and websites, and is a frequent lecturer and columnist on Internet and database technologies. Ben lives in Oak Park, Michigan, with his wife Marcy and their children. Ben welcomes your e-mail at ben@forta.com and invites you to visit his website at http://forta.com/ and to follow him on Twitter at @benforta.

Table of Contents

1. Understanding SQL
2. Introducing SQL Server
3. Working with SQL Server
4. Retrieving Data
5. Sorting Retrieved Data
6. Filtering Data
7. Advanced Data Filtering
8. Using Wildcard Filtering
9. Creating Calculated Fields
10. Using Data Manipulation Functions
11. Summarizing Data
12. Grouping Data
13. Working with Subqueries
14. Joining Tables
15. Creating Advanced Joins
16. Combining Queries
17. Full Text Searching
18. Inserting Data
19. Updating and Deleting Data
20. Creating and Manipulating Tables
21. Using Views
22. Programming With T-SQL
23. Working with Stored Procedures
24. Using Cursors
25. Using Triggers
26. Managing Transaction Processing
27. Working with Internet Formats
28. Globalization and Localization
29. Managing Security
30. Improving Performance
Appendixes
A. Getting Started With SQL Server
B. The Example Tables
C. T-SQL Statement Syntax
D. T-SQL Datatypes
E. T-SQL Reserved Words

Rewards Program

Write a Review