Microsoft 70-433 Training Kit - Original Edition

5星 · 超过95%的资源需积分: 10 129 浏览量更新于2024-07-28 收藏 4.26MB PDF 举报

"mcts70-433_microsoft_trainingkit原版教材" 该资源是"MCTS 70-433 微软培训套件"的原版教材，由微软出版社出版，针对的是微软认证技术专家（MCTS）70-433考试。这个认证专注于SQL Server的相关技术，特别是数据库开发。微软出版社是微软公司的一个分支，负责出版与微软技术和产品相关的书籍和学习资料。 70-433考试，全称为“Designing and Implementing Databases with Microsoft SQL Server 2008”，是为那些希望展示在SQL Server 2008环境下设计和实施数据库能力的专业人士准备的。这个认证涵盖了数据库架构、性能优化、数据安全以及灾难恢复等多个关键领域。书中内容可能包括但不限于以下知识点： 1. **SQL Server 2008基础**：介绍SQL Server的安装、配置、管理和维护，以及其核心组件，如数据库引擎、Integration Services、Analysis Services和Reporting Services。 2. **T-SQL编程**：深入讲解Transact-SQL语言，包括查询、数据修改、存储过程和触发器的编写。 3. **数据库设计**：涉及关系数据库理论，如范式、ER模型，以及如何创建高效、可扩展的表结构。 4. **索引和查询优化**：讨论索引类型（B树、哈希、全文索引等），以及如何通过查询优化器提升查询性能。 5. **安全性管理**：涵盖用户权限、角色、登录、权限分配和数据库审计等方面。 6. **备份与恢复策略**：介绍不同类型的备份（完整、差异、事务日志）、还原操作，以及如何制定有效的灾难恢复计划。 7. **性能监控与调优**：利用工具（如SQL Server Profiler、Dynamic Management Views）进行性能分析，以及调整数据库和查询性能的方法。 8. **高可用性解决方案**：包括镜像、群集、AlwaysOn Availability Groups等，用于保证数据库服务的连续性。 9. **Integration Services (SSIS)**：学习数据导入/导出、ETL（提取、转换、加载）流程的构建。 10. **Analysis Services (SSAS)**：介绍多维数据集、OLAP立方体的构建和MDX查询。 11. **Reporting Services (SSRS)**：涵盖报表设计、数据可视化和报表部署。这本书可能是为了帮助考生备考70-433考试而编写的，提供了丰富的实践案例和练习，帮助读者掌握并应用SQL Server 2008的相关技术。同时，它也适合那些想要深化SQL Server知识和技能的专业人士阅读。由于给出的文件内容主要涉及版权和出版信息，没有提供具体教材内容，以上知识点是基于70-433考试通常涵盖的主题推测得出的。对于实际教材的详细内容，可能还需要参考教材的目录或实际章节。

xiv

Contents

Enabling Service Broker 356

Conﬁguring Service Broker Components 358

Sending and Receiving Messages 363

Lesson Summary 368

Chapter Review . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .369

Chapter Summary 369

Key Terms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .369

Case Scenarios 370

Suggested Practices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .371

Implement Data Types 371

Implement Full-Text Search 371

Implement Service Broker Solutions 372

Take a Practice Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .372

Chapter 9 An Introduction to Microsoft SQL Server

Manageability Features 373

Before You Begin . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 374

Lesson 1: Integrating Database Mail . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .375

Overview of Database Mail 375

Lesson Summary 387

Lesson 2: Implementing Scripts by Using Windows PowerShell . . . . . . . .388

What Is Windows PowerShell? 388

Navigating the SQL Server PowerShell Hierarchy 389

Using SQL Server PowerShell to Enumerate Objects 391

Lesson Summary 396

Lesson 3: Tracking Data Changes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .397

Comparing Change Tracking to CDC 397

Conﬁguring Change Tracking 399

Conﬁguring CDC 408

SQL Server Audit 415

Lesson Summary 423

Chapter Review . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .424

Chapter Summary 424

xvii

Acknowledgments

Tobias Thernström

First of all, I want to thank my wife, Frida, for bearing with me while I worked on this book.

I also want to thank the people at Microsoft Press for turning my Swenglish into English;

I know it wasn’t easy. I really enjoyed working with Ken, Melissa, Laura, and DeAnn, as well

as our great technical reviewer, Kurt! I would also like to extend my thanks to the people at

GrandMasters for helping put together the great team that made this book possible. Finally,

to my great coauthors, Ann and Mike—without you, there would never have been a book.

Thanks, guys. You rock!

Ann Weber

I would like to thank my family and friends for all of the support I received while working

on this project. I would also like to thank Richard Kobylka and Lisa Kreissler for believing in

me and providing me with this great opportunity. I would be remiss if I did not thank Mike

Hotek for sharing the wisdom and knowledge he has gained while authoring many books.

His helpfulness and sense of humor kept me going throughout the project. Finally, I would like

to thank Laura Sackerman for making my ﬁrst project with Microsoft Press an easy transition.

Mike Hotek

I’d like to thank all of our readers for your many years of support and encouragement. Thank

you to my coauthors, Ann and Tobias—my small contribution wouldn’t have made it out the

door without all of the work that you put in. Thank you to Richard, DeAnn, and Kurt—your

long hours and hard work transformed our technobabble into coherent English. It has been

a pleasure working with Melissa, who spent countless hours herding cats to bring this book

into being. Laura, this has been our third book together and, as always, it has been a pleasure.

To the proverbial “man behind the curtain,” Ken Jones—even when the train is barreling

down the wrong track without a driver, it always manages to arrive at the right station, which

is a testament to the invaluable time and effort you put into every Microsoft Press book.

Contents

Acknowledgments xvii

剩余483页未读，继续阅读

AllahVII

粉丝: 0
资源: 8

Microsoft 70-433 Training Kit - Original Edition

mcts70-515_microsoft_trainingkit.pdf

70-528_MCTS_Training_Kit_Microsoft_.NET_Framework_2.0_Web-Based_Client_Development

MCTS70-433

MCTS 70-433 Microsoft SQL Server 2008 Database Development

70_526_MCTS_Training_Kit_Microsoft_.NET_Framework_2.0_Windows-Based_Client_Development

mcts 70-433 题库

MCTS_Self_Paced_Training_Kit_70-536_NEW.pdf

微软认证 MCTS 70-433 最新试题集（147道）

MCTS教程_70-642_Windows_Server_2008_网络基础架构.part2

MCTS教程_70-642_Windows_Server_2008_网络基础架构.part1

最新资源