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

游客，本帖隐藏的内容需要积分高于 1 才可浏览，您当前积分为 0

资源信息： 中文名: 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 在线时间：不定，长期 常在服务器：随机 声明：本人上传的书籍均来自网络，仅作为阅读交流之用，并无任何商业目的。如作者、出版社认为本人行为侵权，请即刻删除此贴！请下载的朋友尊重原书作者、出版社的知识产权，喜欢该书籍，请购买正版图书，支持作者和出版商。谢谢！