Wiley Publishers Since 1807   Shopping Cart  Shopping Cart  My Account  Help  Contact Us  
Home Technology Solutions Who's My Rep About Wiley
 
Product Search
Home > Business > Information Systems & Technology > Server + Certification
Beginning T-SQL with Microsoft SQL Server 2005 and 2008
Beginning T-SQL with Microsoft SQL Server 2005 and 2008
Paul Turley
Dan Wood
ISBN: 978-0-470-25703-6
©2008
750 pages
INSTRUCTORS
STUDENTS
TITLE INFORMATION
Description
Description
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.

The companion website provides all of the code examples from the book, which programmers can use to jump-start their own applications.   


Printer-ready version of this page E-mail a friend about this product