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.

Sams Teach Yourself More Visual Basic.NET in 21 Days provides step-by-step coverage of the most important new features of Visual Basic.NET and .NET that will allow programmers to begin creating rich Web applications and Web Services. Intermediate programmers gain the knowledge and skills to be able to design professional Windows applications and Web services. See how to use previous VB skills in this new environment. Covered topics include:

• The .NET Framework; Classes and how to work with them;
• Databases--the types available and how to pick the right one;
• Review SQL and how to use it;
• Application design process including developing a working prototype;
• Create control objects that enhance applications;
• How to use Crystal Reports; error-handling, performance, testing, and debugging;
• How to get a product to market;
• How to make use of XML in VB.NET.