Beginning T-SQL with Microsoft SQL Server 2005 and 2008

Name: Beginning T-SQL with Microsoft SQL Server 2005 and 2008
Price: 9.81 USD
Availability: InStock
ISBN: 9780470257036

ISBN-10: 0470257032

ISBN-13: 9780470257036

Edition: 2009

Authors: Paul Turley, Dan Wood

List price: $39.99

30 day, 100% satisfaction guarantee!

Marketplace

2 new & used from $9.81

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

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…

Book details

List price: $39.99
Copyright year: 2009
Publisher: John Wiley & Sons, Incorporated
Publication date: 12/10/2008
Binding: Paperback
Pages: 676
Size: 7.50" wide x 9.25" long x 1.50" tall
Weight: 2.244
Language: English



Introduction



Introducing T-SQL and Data Management Systems



SQL Server Fundamentals



SQL Server Tools



Introducing the T-SQL Language



Data Retrieval



SQL Functions



Aggregation and Grouping



Multi-Table Queries



Advanced Queries and Scripting



Transactions



Advanced Capabilities



T-SQL Programming Objects



Creating and Managing Database Objects



Analyzing and Optimizing Query Performance



T-SQL in Applications and Reporting



Command Syntax Reference



System Variables and Functions Reference



System Stored Procedure Reference



Information Schema Views Reference



FileStream Objects and Syntax



Answers to Exercises


Index