Microsoft SQL Server T-SQL in 10 Minutes, Sams Teach Yourself (2nd Edition)Microsoft SQL Server T-SQL in 10 Minutes, Sams Teach Yourself
Author: Ben Forta
Publisher: Sams Publishing; 2 edition
Publication Date: 2016-12-22
ISBN-10: 0672337924
ISBN-13: 9780672337925
Paperback: 368 Pages
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 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 Sams Teach Yourself Microsoft SQL Server T SQL in 10 Minutes Second Edition is the only compact hands on intr