Tài liệu Beginning SQL Server 2005 for Developers - From Novice to Professional

About the Author xvii
About the Technical Reviewer xix
Acknowledgments . xxi
Introduction xxiii
■CHAPTER 1 SQL Server 2005 Overview and Installation . 1
■CHAPTER 2 SQL Server Management Studio 25
■CHAPTER 3 Database Design and Creation . 53
■CHAPTER 4 Security 95
■CHAPTER 5 Defining Tables 119
■CHAPTER 6 Creating Indexes and Database Diagramming 153
■CHAPTER 7 Database Backups, Recovery, and Maintenance 185
■CHAPTER 8 Working with the Data 245
■CHAPTER 9 Building a View 309
■CHAPTER 10 Stored Procedures 335
■CHAPTER 11 T-SQL Essentials . 359
■CHAPTER 12 Advanced T-SQL 403
■CHAPTER 13 Triggers . 427
■CHAPTER 14 SQL Server 2005 Reporting Services . 451
■APPENDIX Glossary of Terms 473
■INDEX 485