The most advanced book of its kind on the market, this book shows how to use SQL Server 2005 to solve real-world business problems by emphasizing development best practices and building skills as a developer. The books goal is to help developers recognize similar real-life work problems and analogize effectively to solve them.
This book offers a unique perspective on database development issues. It first presents and explains advanced techniques then demonstrates their use in various business scenarios. The goal is expert mastery of both concepts and their application.§The focus throughout is on expert development of real-world database applications.
Introduction: Applying Software Development Methodologies to the Database World.- Advanced SQL Server 2005 Development Topics:Testing and debugging database objects.- Exception handling.- Security Considerations for T-SQL Development.- Dynamic T-SQL.- Working with SQLCLR.- Working with SQL Service Broker.- SQL Server 2005 Development Techniques: Designing systems for application concurrency.- Working with geographical data.- Working with temporal data.- Trees, hierarchies, and graphs.- Business case scenarios: Technical recruiting firm.- Retailer.- Shipping company.- Stock brokerage.- Appendixes: Answers to exercises.- Notes for classroom instructors.
€ 36,10