Sams teach yourself Microsoft SQL server T-SQL in 10 minutes

Format:

Book

Author/Creator:

Forta, Ben, Author.

Series:

Sams Teach Yourself

Sams teach yourself

Language:

English

Subjects (All):

SQL server.

SQL (Computer program language).

Relational databases.

Client/server computing.

Physical Description:

1 online resource (368 pages)

Edition:

1st edition

Place of Publication:

[Place of publication not identified] Sams Pub 2006

Language Note:

English

System Details:

text file

Summary:

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through 10-minute lessons, you’ll learn everything 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, and much more. You’ll learn what you need to know methodically, systematically, and simply–in highly focused lessons designed to make you immediately and effortlessly productive. Tips point out shortcuts and solutions Cautions help you avoid common pitfalls Notes explain additional concepts, and provide additional information 10 minutes is all you need to 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 Register your book at www.samspublishing.com/register to download examples and source code from this book.

Contents:

Intro

Title Page

Copyright Page

Table of Contents

About the Author

Acknowledgments

Introduction

Lesson 1. Understanding SQL

Lesson 2. Introducing SQL Server

Lesson 3. Working with SQL Server

Lesson 4. Retrieving Data

Lesson 5. Sorting Retrieved Data

Lesson 6. Filtering Data

Lesson 7. Advanced Data Filtering

Lesson 8. Using Wildcard Filtering

Lesson 9. Creating Calculated Fields

Lesson 10. Using Data Manipulation Functions

Lesson 11. Summarizing Data

Lesson 12. Grouping Data

Lesson 13. Working with Subqueries

Lesson 14. Joining Tables

Lesson 15. Creating Advanced Joins

Lesson 16. Combining Queries

Lesson 17. Full-Text Searching

Lesson 18. Inserting Data

Lesson 19. Updating and Deleting Data

Lesson 20. Creating and Manipulating Tables

Lesson 21. Using Views

Lesson 22. Programming with T-SQL

Lesson 23. Working with Stored Procedures

Lesson 24. Using Cursors

Lesson 25. Using Triggers

Lesson 26. Managing Transaction Processing

Lesson 27. Working with XML

Lesson 28. Globalization and Localization

Lesson 29. Managing Security

Lesson 30. Improving Performance

Appendix A. Getting Started with SQL Server and T-SQL

Appendix B. The Example Tables

Appendix C. T-SQL Statement Syntax

Appendix D. T-SQL Datatypes

Appendix E. T-SQL Reserved Words

Index.

Notes:

Bibliographic Level Mode of Issuance: Monograph

Description based on publisher supplied metadata and other sources.

ISBN:

9786612649356

9780768690002

0768690005

9781282649354

1282649353

9780768677782

0768677785

OCLC:

165114793