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

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

Description

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

Similar Books

ISBN 10: 150930200X
ISBN 13: 9781509302000

04 Oct 2016
Itzik Ben-Gan

ISBN 10: 1945051752
ISBN 13: 9781945051753

19 Nov 2019
Walter Shields

ISBN 10: 1260458873
ISBN 13: 9781260458879

28 Jan 2020
Dusan Petkovic

ISBN 10: 1492032646
ISBN 13: 9781492032649

22 Oct 2019
Aurélien Géron

ISBN 10: 0135182794
ISBN 13: 9780135182796

18 Aug 2020
Ben Forta

ISBN 10: 1943872570
ISBN 13: 9781943872572

10 Apr 2020
Bryan Syverson

ISBN 10: 1484266056
ISBN 13: 9781484266052

25 Apr 2021
Kathi Kellenberger

ISBN 10: 180056810X
ISBN 13: 9781800568105

10 Nov 2020
Mark J. Price

ISBN 10: 1789348811
ISBN 13: 9781789348811

03 May 2019
Pedro Lopes

ISBN 10: 1119569613
ISBN 13: 9781119569619

28 May 2019
Allen G. Taylor

ISBN 10: 194505123X
ISBN 13: 9781945051234

19 Nov 2019
Walter Shields

ISBN 10: 1423241886
ISBN 13: 9781423241881

01 May 2019
Berajah Jayne