Saturday, May 12, 2007

Beginning SQL Server 2005 Programming

book cover

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.

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

No comments:

Post a Comment