책 이미지
책 정보
· 분류 : 외국도서 > 컴퓨터 > 데이터베이스 관리 > 일반
· ISBN : 9780735610514
· 쪽수 : 1131쪽
· 출판일 : 2000-10-01
목차
Chapter 1: Overview of Microsoft SQL Server 2000
Chapter 2: The Microsoft Windows 2000 Platform
Chapter 3: Roles and Responsibilities of the Microsoft SQL Server DBA
Chapter 4: Designing a Microsoft SQL Server System
Chapter 5: I/0 Subsystem Configuration and Planning
Chapter 6: Capacity Planning
Chapter 7: Installing Microsoft SQL Server
Chapter 8: Managing Microsoft SQL Server Services
Chapter 9: Creating Databases
Chapter 10: Creating Database Tables
Chapter 11: Configuring Microsoft SQL Server on the Network
Chapter 12: Microsoft SQL Server and Microsoft Cluster Services
Chapter 13: Introduction to Transact-SQL and SQL Query Analyzer
Chapter 14: Retrieving Data Using Transact-SQL
Chapter 15: Managing Tables Using Transact-SQL and Enterprise Manager
Chapter 16: Creating and Using Defaults, Constraints, and Rules
Chapter 17: Creating and Using Indexes
Chapter 18: Creating and Using Views
Chapter 19: Understanding Transactions and Transaction Locking
Chapter 20:Understanding Advanced T-SQL
Chapter 21: Creating and Managing Stored Procedures
Chapter 22: Creating and Using Triggers
Chapter 23: Accessing Microsoft SQL Server from the Internet
Chapter 24: Loading the Database
Chapter 25: Component Services and Microsoft Distributed Transaction Coordinator
Chapter 26: Microsoft SQL Server Replication: Overview and Snapshot Replication
Chapter 27: Transactional Replication
Chapter 28: Merge Replication
Chapter 29: Using Microsoft SQL Server Analysis Services
Chapter 30: Microsoft SQL Server Administration
Chapter 31: Automating Administrative Tasks
Chapter 32: Backing Up Microsoft SQL Server
Chapter 33: Restoring and Recovering the Database
Chapter 34: User and Security Management
Chapter 35: Using SQL Query Analyzer and SQL Profiler
Chapter 36: Solving Common Performance Problems
Appendix A: Microsoft SQL Server Configuration Parameters
Appendix B: Microsoft SQL Server Monitoring
Appendix C: DBCC Commands
Glossary
Index
