Beginning T-SQL with Microsoft SQL Server 2005 and 2008

Beginning T-SQL Programming teaches beginners who have not yet programmed with Transact-SQL--more commonly referred to as T-SQL. Some familiarity with relational databases and basic SQL is expected, and some programming experience is helpful. The target audience includes database developers as well as business and data analysts, and power users.

The book begins with an overview of SQL Server query operations and tools used with T-SQL. (The authors will cover both the 2005 and 2008 releases of SQL Server query tools and the query editor.) After a quick review of basic query language commands and syntax, the author quickly moves to show how to design and build applications of increasing complexity. He covers such important tasks as:

• Full text indexing
• Optimizing query performance
• Programming techniques using views and stored procedures
• Application design and security considerations.

About the Authors

Paul Turley (Vancouver, WA) is a Manager of Specialized Services for Hitachi Consulting Education Services. Paul manages the Business Intelligence training team and teaches classes for companies throughout the world on Microsoft SQL Server technologies. He works with companies to architect and build BI and reporting solutions. He has been developing business database solutions since 1991 for companies like Microsoft, Disney, Nike, and Hewlett-Packard. He has been a Microsoft Certified Trainer since 1996 and holds several industry certifications, including MCTS and MCITP for BI, MCSD, MCDBA, MSF Practitioner, and IT Project+.

Paul has authored and co-authored several books and courses on database, business intelligence, and application development technologies. He is the lead courseware developer for the Hitachi Consulting courses: SQL Server 2008 Business Intelligence Solutions and SQL Server 2008 Reporting Services Solutions. Books include the prior edition of this book, the 2008, 2005 and 2000 editions of Professional SQL Server Reporting Services, Beginning SQL Server 2005 Administration, Beginning Access 2002 VBA, Data Warehousing with SQL Server 2000 Analysis Services, and Professional Access 2000 Programming—all from Wrox. He is also a contributing author for SQL Server 2005 Integration Services Step by Step from Microsoft Press.

Dan Wood (Silverdale, WA) is the senior database administrator for Avalara, a sales tax compliance company, where he both administers and develops database solutions for several enterprise applications that handle global address validation, tax rate calculation, and sales tax remittance for e-commerce and ERP clients. He has been working with SQL Server as a DBA, consultant, and trainer since 1999. Dan was a contributing author on Beginning Transact-SQL with SQL Server 2000 and 2005 and the lead author of Beginning SQL Server Administration, both from Wrox.