After a quick primer on database design basics and the SQL query language (for those programmers who may be building their first database application), this book provides an overview of SQL Server itself, which has been dramatically redesigned with the 2005 release. Once readers have grasped the fundamentals of database design and SQL concepts, they will then learn how to implement those concepts with Microsoft SQL Server 2005. Addresses creating and changing tables, managing keys, database normalization, writing scripts, working with stored procedures, programming with XML, and using SQL Server reporting and data transformation services. The companion Web site provides all of the code found in the book.
- ISBN10 1280311584
- ISBN13 9781280311581
- Publish Date 1 January 2006 (first published 1 October 2005)
- Publish Status Active
- Out of Print 4 March 2015
- Publish Country US
- Publisher John Wiley & Sons Inc
- Imprint Wrox Press
- Format eBook
- Pages 550
- Language English