《MCTS-SQL SERVER2005 70-431 微软出品的自学指南》(Self-Paced Training Kit (Exam 70-431))

This training kit is designed for information technology (IT) professionals who plan
to take Microsoft Certified Technical Specialist (MCTS) exam 70-431, as well as for IT
professionals who need to know how to implement and maintain Microsoft SQL
Server 2005 databases. We assume that before you begin using this kit you have a
working knowledge of Microsoft Windows, network technologies, relational data-
bases and their design, Transact-SQL, and the SQL Server 2005 client tools.
By using this training kit, you’ll learn how to



■ Install and configure SQL Server 2005.
■ Create and implement database objects.
■ Implement high availability and disaster recovery.
■ Maintain databases.
■ Support data consumers.
■ Monitor and troubleshoot SQL Server performance.






1 Installing SQL Server 2005 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
2 Configuring SQL Server 2005. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .51
3 Creating Tables, Constraints, and User-Defined Types. . . . . . . . . . . . . .103
4 Creating Indexes. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .147
5 Working with Transact-SQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .169
6 Creating Partitions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .207
7 Implementing Views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .237
8 Managing XML Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .255
9 Creating Functions, Stored Procedures, and Triggers. . . . . . . . . . . . . . .349
10Working with Flat Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .379
11Backing Up, Restoring, and Moving a Database. . . . . . . . . . . . . . . . . . .413
12Using Transact-SQL to Manage Databases. . . . . . . . . . . . . . . . . . . . . . . .447
13Working with HTTP Endpoints . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .477
14Working with SQL Server AgentJobs. . . . . . . . . . . . . . . . . . . . . . . . . . . .493
15Monitoring and Troubleshooting SQL Server Performance . . . . . . . . .529
16Managing Database Snapshots . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .601
17Implementing Database Mirroring. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .615
18Implementing Log Shipping . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .651
19Managing Replication. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .695
20Working with Service Broker. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .775
21Creating Full-Text Catalogs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .813

已通过安全测试
杀毒软件：AntiVir + AVG
病毒库版本：6.38.01.68
在线时间：不定，长期
常在服务器：随机



声明：本人上传的书籍均来自网络，仅作为阅读交流之用，并无任何商业目的。如作者、出版社认为本人行为侵权，请即刻删除此贴！请下载的朋友尊重原书作者、出版社的知识产权，喜欢该书籍，请购买正版图书，支持作者和出版商。谢谢！