Book description
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.
Table of contents
- 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
Product information
- Title: Sams Teach Yourself Microsoft
- Author(s):
- Release date: August 2007
- Publisher(s): Sams
- ISBN: 9780672328671
You might also like
book
Sams Teach Yourself Microsoft® SQL Server T-SQL in 10 Minutes, Second Edition
Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes offers straightforward, practical answers when you …
book
Microsoft® SQL Server® 2012 T-SQL Fundamentals
Gain a solid understanding of T-SQL—and write better queries Master the fundamentals of Transact-SQL—and develop your …
book
Learn SQL Database Programming
Learn everything you need to know to build efficient SQL queries using this easy-to-follow beginner's guide …
video
Developing SQL Databases - Exam 70-762 Certification
Microsoft exam 70-762 is one of two exams you must pass to earn a Microsoft Certified …