- ホーム
- > 洋書
- > 英文書
- > Computer / Databases
Full Description
* This comprehensive introduction to SQL Server begins with an overview of database design basics and the SQL query language along with an in-depth look at SQL Server itself* Progresses on to a clear explanation of how to implement fundamental concepts with the new 2008 version of SQL Server* Discusses creating and changing tables, managing keys, writing scripts, working with stored procedures, programming with XML, using SQL Server Reporting and Integration Services, and more* Features updated and new material, including new examples using Microsoft's AdventureWorks sample database
Contents
Introduction. Chapter 1Database? Chapter 2: Tools of the Trade. Chapter 3: The Foundation Statements of T-. Chapter 4: JOINs. Chapter 5: Creating and Altering Tables. Chapter 6: Constraints. Chapter 7: Adding More to Our Queries. Chapter 8: Being Normal: Normalization and Other Basic Design Issues. Chapter 9: 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: System Functions. Appendix B: Very Simple Connectivity Examples. Index.
