Beginning SQL Server 2005 Programming

SQLServer 2005 represents the 2 major revision to SQLServer since that time, and, as we did the planning for this cycle of books, we realized that we once again had a problem — it was too big. The new features of SQLServer 2005 created a situation where there was simply too much content to squeeze into one book, and so we made the choice to split the old Professional series title into a Beginning and a more targeted Professional pair of titles. You are now holding the first half of that effort. My hope is that you find something that covers all of the core elements of SQLServer with the same success that we had in the previous Professional SQLServer Programming titles. When we’re done, you should be set to be a highly functional SQLServer 2005 programmer, and, when you need it, be ready to move on to the more advanced Professional title. Who This Book Is For It is almost sad that the word “Beginner” is in the title of this book. Don’t get me wrong; if you are a beginner, then this title is for you. But it is designed to last you well beyond your beginning days. What is covered in this book is necessary for the beginner, but there is simply too much information for you to remember all of it all the time, and so it is laid out in a fashion that should make a solid review and reference item even for the more intermediate, and, yes, even advanced user. The beginning user will want to start right at the beginning. Things are designed such that just about everything in this book is a genuine “need to know” sort of thing. With the possible exception of the chapters on XML, Reporting Services and Integration Services, every item in this book is a fundamental item to you having the breadth of understanding you need to make well-informed choices on how you approach your SQLServer problems. TABLE OF CONTENT: Chapter 01 - RDBMS Basics - What Makes Up a SQL Server Database? Chapter 02 - Tools of the Trade Chapter 03 - The Foundation Statements of T-SQL Chapter 04 - JOINs Chapter 05 - Creating and Altering Tables Chapter 06 - Constraints Chapter 07 - Adding More to Our Queries Chapter 08 - Being Normal - Normalization and Other Basic Design Issues Chapter 09 - SQL Server Storage and Index Structures Chapter 10 - Views Chapter 11 - Writing Scripts and Batches Chapter 12 - Stored Procedures Chapter 13 - User Defined Functions Chapter 14 - Transactions and Locks Chapter 15 - Triggers Chapter 16 - A Brief XML Primer Chapter 17 - Reporting for Duty, Sir! - A Look At Reporting Services Chapter 18 - Getting Integrated With Integration Services Chapter 19 - Playing Administrator Appendix A - Exercise Solutions 577 Appendix B - System Functions 587 Appendix C - Finding the Right Tool 639 Appendix D - Very Simple Connectivity Examples 647 Appendix E - Installing and Using the Samples 651 Download Here Password: ganelon