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

《MCTS-SQL SERVER2005 70-431 微软出品的自学指南》(Self-Paced Training Kit (Exam 70-431))
  • 片  名  《MCTS-SQL SERVER2005 70-431 微软出品的自学指南》(Self-Paced Training Kit (Exam 70-431))
  • 简  介  对白语言: 英语
  • 类  别  资料
  • 小  类  计算机教程


  • 详细介绍中文名: 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
    在线时间:不定,长期
    常在服务器:随机
    声明:本人上传的书籍均来自网络,仅作为阅读交流之用,并无任何商业目的。如作者、出版社认为本人行为侵权,请即刻删除此贴!请下载的朋友尊重原书作者、出版社的知识产权,喜欢该书籍,请购买正版图书,支持作者和出版商。谢谢!
  • 《MCTS-SQL SERVER2005 70-431 微软出品的自学指南》(Self-Paced Training Kit (Exam 70-431))_large