Home > Store > Operating Systems, Server > Microsoft Servers

Microsoft SQL Server T-SQL in 10 Minutes Web Edition, Sams Teach Yourself, 2nd Edition

Microsoft SQL Server T-SQL in 10 Minutes Web Edition, Sams Teach Yourself, 2nd Edition

Web Edition

  • Your Price: $19.19
  • List Price: $23.99
  • About this Web Edition
  • A Web Edition is an online learning product that you view in your web browser while connected to the Internet. Some Web Editions include additional interactive features, such as videos, quizzes, or live code editing. Read the product description for more details. A Web Edition will be accessible from your Account page after purchase.

    Viewing a Web Edition requires a web browser that fully supports HTML5. Supported platforms are:

    • Windows XP (Firefox only)
    • Windows 7, 8, or 10 (IE10, IE11, Chrome, or Firefox)
    • Mac OS X (Safari, Firefox, or Chrome)
    • Linux (Chrome or Firefox)
    • iOS 6, 7, or 8 (Mobile Safari)

Also available in other formats.

Register your product to gain access to bonus material or receive a coupon.

Description

  • Copyright 2017
  • Edition: 2nd
  • Web Edition
  • ISBN-10: 0-13-467053-1
  • ISBN-13: 978-0-13-467053-9

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.


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
Contents at a Glance   1 Understanding SQL2 Introducing SQL Server3 Working with SQL Server4 Retrieving Data5 Sorting Retrieved Data6 Filtering Data7 Advanced Data Filtering8 Using Wildcard Filtering9 Creating Calculated Fields10 Using Data Manipulation Functions11 Summarizing Data12 Grouping Data13 Working with Subqueries14 Joining Tables15 Creating Advanced Joins16 Combining Queries17 Full-Text Searching18 Inserting Data19 Updating and Deleting Data20 Creating and Manipulating Tables21 Using Views22 Programming with T-SQL23 Working with Stored Procedures24 Using Cursors25 Using Triggers26 Managing Transaction Processing27 Working with XML and JSON28 Globalization and Localization29 Managing Security30 Improving PerformanceA The Example TablesB T-SQL Statement SyntaxC T-SQL DatatypesD T-SQL Reserved Words


Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership