Copyright ©1998-2010 Glenn Fleishman. Send in your comments. Bibliographic information on isbn.nu licensed from Baker & Taylor. Contact them for corrections and licensing, or read more about our data.
Tables of Contents for Teach Yourself Transact-SQL in 21 Days
Chapter/Section Title
Page #
Page Count
Introduction
xxiv
Week 1 at a Glance
1
148
Day 1 Introduction to Transact-SQL
3
14
2 Retrieving Data
17
32
3 Selecting Rows with the WHERE Clause
49
20
4 All About Columns
69
24
5 Aggregates
93
12
6 Totals and Subtotals
105
18
7 Joining Tables
123
22
Week 1 in Review
145
4
Week 2 at a Glance
149
148
Day 8 Subqueries
151
18
9 INSERT, UPDATE, and DELETE
169
38
10 Temporary Tables and Views
207
20
11 Databases, Object Naming, and Batches
227
12
12 Batch Programming Structures
239
18
13 Transactions
257
20
14 Cursors
277
16
Week 2 in Review
293
4
Week 3 at a Glance
297
186
Day 15 How the Server Uses Indexes
299
28
16 Stored Procedures
327
26
17 Procedures and Performance
353
24
18 Advanced Stored Procedure Issues
377
22
19 Triggers
399
28
20 Advanced Topics: Single-Table Queries
427
30
21 Advanced Topics: Joins and Subqueries
457
22
Week 3 in Review
479
4
Appendix
483
Answers to Quizzes and Exercises
483
44
Index
527