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

by Ben Forta

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… Contents at a Glance 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 XML and JSON 28 Globalization and Localization 29 Managing Security 30 Improving Performance A The Example Tables B T-SQL Statement Syntax C T-SQL Datatypes D T-SQL Reserved Words

366 pages, Paperback

Published January 17, 2017

About the author

Ben Forta is an author and Senior Technical Evangelist for Adobe Systems, particularly ColdFusion and Flex, and the owner of EmTek Systems. He previously worked in a similar capacity for Macromedia and Allaire Corporation, the two previous owners of ColdFusion.

In addition to writing numerous technical books on ColdFusion, SQL, and Regular Expressions, Forta co-authored Adobe's official ColdFusion training materials and certification tests and lectures on application development around the world. Many of his books have been translated into over a dozen languages worldwide.

Before working for Allaire, he founded the website Car.com, which was later purchased by Auto-By-Tel. Born in London, England, Forta lives in Oak Park, Michigan with his wife and their children.

- from Wikipedia

Reviews

[John Kramer · Rating 4 out of 5]

Gets right to the point and plenty of examples to work through.

[Joshua Rex · Rating 4 out of 5]

Fairly helpful, I’m surprised my course only used like 3 lessons from this book. (They still made me buy it though, lol)