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

4.5 avg rating
( 2 ratings by Goodreads )
 
9780672337925: Microsoft SQL Server T-SQL in 10 Minutes, Sams Teach Yourself (2nd Edition)

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

 

"synopsis" may belong to another edition of this title.

About the Author:

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. 

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Forta, Ben
ISBN 10: 0672337924 ISBN 13: 9780672337925
New Quantity Available: 5
Seller:
GreatBookPrices
(Columbia, MD, U.S.A.)
Rating
[?]

Book Description Book Condition: New. Bookseller Inventory # 26847486-n

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 16.75
Convert Currency

Add to Basket

Shipping: US$ 2.64
Within U.S.A.
Destination, Rates & Speeds

2.

Forta, Ben
Published by Sams (2016)
ISBN 10: 0672337924 ISBN 13: 9780672337925
New Quantity Available: 1
Seller:
Paperbackshop-US
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description Sams, 2016. PAP. Book Condition: New. New Book. Shipped from US within 10 to 14 business days. Established seller since 2000. Bookseller Inventory # KB-9780672337925

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 15.41
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

3.

Forta, Ben
Published by Prentice Hall
ISBN 10: 0672337924 ISBN 13: 9780672337925
New Quantity Available: > 20
Seller:
INDOO
(Avenel, NJ, U.S.A.)
Rating
[?]

Book Description Prentice Hall. Book Condition: New. Brand New. Bookseller Inventory # 0672337924

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 17.78
Convert Currency

Add to Basket

Shipping: US$ 3.50
Within U.S.A.
Destination, Rates & Speeds

4.

Ben Forta
Published by Pearson Education (US), United States (2016)
ISBN 10: 0672337924 ISBN 13: 9780672337925
New Paperback Quantity Available: 1
Seller:
The Book Depository US
(London, United Kingdom)
Rating
[?]

Book Description Pearson Education (US), United States, 2016. Paperback. Book Condition: New. 2nd edition. Language: English . Brand New Book. 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 environmentConstruct complex T-SQL statements using multiple clauses and operatorsFilter data so you get the information you need quicklyRetrieve, sort, and format database contentsJoin two or more related tablesMake SQL Server work for you with globalization and localizationCreate subqueries to pinpoint your dataAutomate your workload with triggersCreate and alter database tablesWork with views, stored procedures, and moreContents 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. Bookseller Inventory # AAS9780672337925

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 23.05
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

5.

Ben Forta
Published by Pearson Education (US), United States (2016)
ISBN 10: 0672337924 ISBN 13: 9780672337925
New Paperback Quantity Available: 1
Seller:
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description Pearson Education (US), United States, 2016. Paperback. Book Condition: New. 2nd edition. Language: English . Brand New Book. 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 environmentConstruct complex T-SQL statements using multiple clauses and operatorsFilter data so you get the information you need quicklyRetrieve, sort, and format database contentsJoin two or more related tablesMake SQL Server work for you with globalization and localizationCreate subqueries to pinpoint your dataAutomate your workload with triggersCreate and alter database tablesWork with views, stored procedures, and moreContents 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. Bookseller Inventory # AAS9780672337925

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 23.79
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

6.

Ben Forta
Published by Sams 2016-12-12 (2016)
ISBN 10: 0672337924 ISBN 13: 9780672337925
New Quantity Available: 5
Seller:
Chiron Media
(Wallingford, United Kingdom)
Rating
[?]

Book Description Sams 2016-12-12, 2016. Book Condition: New. Brand new book, sourced directly from publisher. Dispatch time is 24-48 hours from our warehouse. Book will be sent in robust, secure packaging to ensure it reaches you securely. Bookseller Inventory # NU-GRD-05555096

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 21.59
Convert Currency

Add to Basket

Shipping: US$ 3.96
From United Kingdom to U.S.A.
Destination, Rates & Speeds

7.

Ben Forta
Published by Pearson Education (US), United States (2016)
ISBN 10: 0672337924 ISBN 13: 9780672337925
New Paperback Quantity Available: 10
Seller:
Book Depository hard to find
(London, United Kingdom)
Rating
[?]

Book Description Pearson Education (US), United States, 2016. Paperback. Book Condition: New. 2nd edition. Language: English . This book usually ship within 10-15 business days and we will endeavor to dispatch orders quicker than this where possible. Brand New Book. 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 environmentConstruct complex T-SQL statements using multiple clauses and operatorsFilter data so you get the information you need quicklyRetrieve, sort, and format database contentsJoin two or more related tablesMake SQL Server work for you with globalization and localizationCreate subqueries to pinpoint your dataAutomate your workload with triggersCreate and alter database tablesWork with views, stored procedures, and moreContents 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. Bookseller Inventory # BTE9780672337925

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 25.65
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

8.

Forta, Ben
Published by Sams Publishing (2016)
ISBN 10: 0672337924 ISBN 13: 9780672337925
New Softcover Quantity Available: 9
Rating
[?]

Book Description Sams Publishing, 2016. Book Condition: New. Num Pages: 368 pages. BIC Classification: UNK. Category: (P) Professional & Vocational. Dimension: 142 x 209 x 20. Weight in Grams: 408. . 2016. 2nd Edition. Paperback. . . . . . Bookseller Inventory # V9780672337925

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 28.65
Convert Currency

Add to Basket

Shipping: FREE
From Ireland to U.S.A.
Destination, Rates & Speeds

9.

Forta, Ben
Published by Sams Publishing
ISBN 10: 0672337924 ISBN 13: 9780672337925
New Softcover Quantity Available: 9
Seller:
Kennys Bookstore
(Olney, MD, U.S.A.)
Rating
[?]

Book Description Sams Publishing. Book Condition: New. Num Pages: 368 pages. BIC Classification: UNK. Category: (P) Professional & Vocational. Dimension: 142 x 209 x 20. Weight in Grams: 408. . 2016. 2nd Edition. Paperback. . . . . Books ship from the US and Ireland. Bookseller Inventory # V9780672337925

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 28.83
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

10.

Ben Forta
Published by Pearson Education (US) (2016)
ISBN 10: 0672337924 ISBN 13: 9780672337925
New Quantity Available: 14
Seller:
Books2Anywhere
(Fairford, GLOS, United Kingdom)
Rating
[?]

Book Description Pearson Education (US), 2016. PAP. Book Condition: New. New Book. Shipped from UK in 4 to 14 days. Established seller since 2000. Bookseller Inventory # GB-9780672337925

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 18.14
Convert Currency

Add to Basket

Shipping: US$ 11.92
From United Kingdom to U.S.A.
Destination, Rates & Speeds

There are more copies of this book

View all search results for this book