Beginning T-sql With Microsoft Sql Server
2005 And 2008

Opis książki: 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.
The companion website provides all of the code examples from the book, which programmers can use to jump-start their own applications.