|
Teach Yourself Transact SQL in 21 Days
Sams Teach Yourself Transact-SQL in 21 Days, 2E will teach programmers how to develop Transact-SQL queries. There will be a focus on providing methods for improving productivity without a reducing performance. Specifically, the reader will:Learn Transact-SQL syntax Learn how to add, delete, and modifying data using Transact-SQL Understand coding standards
Review variations from ANSI-standard SQL Be presented with basic server operations. Recognize performance issues with queries. This book will also include:Constructs such as CUBE, ROLLUP, CASE, and JOIN. Techniques to solve complex problems How the server uses indexes Methods to write (correctly) stored procedures and triggers. Templates of procedures and triggers (reference) Advanced Topics such as: Outer and self joins Temporary tables Sub-queries.
Table of Contents
Introduction
Week 1 - Working with Rows and Columns
Day 1 - Introduction to SQL and the Query Analyzer
Day 2 - Filtering and Sorting Data
Day 3 - Working with Columns
Day 4 - Working with Row Aggregates and Grouping
Day 5 - Joining Tables
Day 6 - Using Subqueries
Day 7 - Adding, Changing, and Deleting Rows
Week 1 - In Review
Week 2 - Programming with T-SQL
Day 8 - Defining Data
Day 9 - Indexes and Performance
Day 10 - Views and Temporary Tables
Day 11 - T-SQL Programming Fundamentals
Day 12 - Understanding Database Locking
Day 13 - Programming with Transactions
Day 14 - Using Cursors
Week 2 - In Review
Week 3 - Procedures and Triggers
Day 15 - Writing and Executing Stored Procedures
Day 16 - Optimizing Stored Procedures
Day 17 - Debugging Stored Procedures
Day 18 - Writing and Testing Triggers
Day 19 - Solving Special Trigger Problems
Day 20 - User-Defined Functions in SQL
Day 21 - Handling BLOBs in T-SQL
Week 3 - In Review
Appendix
Appendix A - Answers to Quizzes and Exercises
Index
|
