Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes View Larger Image | Ben Forta
Sams, Paperback, Published August 2007, 352 pages, ISBN 0672328674 | List Price: $19.99
Our Price: $13.50
You Save: $6.49 (32% Off)
| | | Availability: Out-Of-Stock |
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: - Head First SQL; Lynn Beighley, $26.95, 40% Off!
- CSS Mastery: Advanced Web Standards Solutions; Andy Budd, et al, $21.50, 39% Off!
- Inside Microsoft SQL Server 2005: T-SQL Programming; Dejan Sarka, et al, $26.95, 40% Off!
- SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach; Joseph Sack, $36.50, 39% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
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
Introduction
Who Is This Book For?
Companion Website.
Conventions Used in This Book.
1 Understanding SQL
Database Basics.
What Is SQL?.
Try It Yourself
Summary
2 Introducing SQL Server
What Is SQL Server?.
SQL Server Tools
Summary
3 Working with SQL Server
Making the Connection.
Selecting a Database.
Learning About Databases and Tables
Summary
4 Retrieving Data
The SELECT Statement.
Retrieving Individual Columns
Retrieving Multiple Columns.
Retrieving All Columns.
Retrieving Distinct Rows
Limiting Results
Using Fully Qualified Table Names
Summary
5 Sorting Retrieved Data
Sorting Data.
Sorting by Multiple Columns
Specifying Sort Direction
Summary
6 Filtering Data
Using the WHERE Clause
The WHERE Clause Operators
Summary
7 Advanced Data Filtering
Combining WHERE Clauses.
Using the IN Operator.
Using the NOT Operator
Summary
8 Using Wildcard Filtering
Using the LIKE Operator
Tips for Using Wildcards
Summary
9 Creating Calculated Fields
Understanding Calculated Fields
Concatenating Fields.
Performing Mathematical Calculations.
Summary
10 Using Data Manipulation Functions
Understanding Functions.
Using Functions
Summary
11 Summarizing Data
Using Aggregate Functions.
Aggregates on Distinct Values.
Combining Aggregate Functions
Summary.
12 Grouping Data
Understanding Data Grouping
Creating Groups
Filtering Groups
Grouping and Sorting.
SELECT Clause Ordering.
Summary.
13 Working with Subqueries
Understanding Subqueries
Filtering by Subquery
Using Subqueries as Calculated Fields
Checking for Existence with Subqueries
Summary.
14 Joining Tables
Understanding Joins.
Creating a Join.
Summary.
15 Creating Advanced Joins
Using Table Aliases
Using Different Join Types
Using Joins with Aggregate Functions.
Using Joins and Join Conditions.
Summary.
16 Combining Queries
Understanding Combined Queries.
Creating Combined Queries
Summary.
17 Full-Text Searching
Understanding Full-Text Searching.
Setting Up Full-Text Searching
Performing Full-Text Searches
Summary.
18 Inserting Data
Understanding Data Insertion.
Inserting Complete Rows.
Inserting Multiple Rows.
Inserting Retrieved Data
Summary.
19 Updating and Deleting Data
Updating Data.
Deleting Data.
Guidelines for Updating and Deleting
Data
Summary.
20 Creating and Manipulating Tables
Creating Tables.
Updating Tables
Deleting Tables.
Renaming Tables.
Summary.
21 Using Views
Understanding Views.
Using Views
Summary.
22 Programming with T-SQL
Understanding T-SQL Programming
Using Variables.
Using Conditional Processing
Grouping Statements.
Using Looping.
Summary.
23 Working with Stored Procedures
Understanding Stored Procedures
Why Use Stored Procedures
Using Stored Procedures.
Summary.
24 Using Cursors
Understanding Cursors
Working with Cursors
Summary.
25 Using Triggers
Understanding Triggers
Using Triggers
Summary
26 Managing Transaction Processing
Understanding Transaction Processing
Controlling Transactions
Summary
27 Working with XML
Understanding SQL Server XML Support
Retrieving Data as XML
Storing XML Data
Searching for XML Data
Summary
28 Globalization and Localization
Understanding Character Sets and
Collation Sequences
Working with Collation Sequences
Managing Case Sensitivity
Working with Unicode
Summary
29 Managing Security
Understanding Access Control
Managing Users.
Managing Access Rights
Summary
30 Improving Performance
Improving Performance
Summary
Appendixes
A Getting Started with SQL Server and T-SQL
B The Example Tables
C T-SQL Statement Syntax
D T-SQL Datatypes
E T-SQL Reserved Words
|
