MCDBA SQL Server 2000考试指南(含盘,英文原版) 下载 pdf 电子版 epub 免费 txt 2025

　　 本书是美国著名的出版商McGraw-Hill出版的畅销认证系列丛书All-in-One之一。包含微软认证数据库管理员（MCDBA）认证两门核心考试的内容，全面介绍了SQL Server的各种不同版本，包括每个版本支持的操作系统，以及SQL Server 2000的高级特性。读者可以学到如何进行本地和远程安装、管理Windows 2000 Server和SQL Server 2000以及管理和维护数据等内容。本书每章都包括详细的考试目标、实际练习和考试技巧，是一个实用的学习工具。

本书所附光盘中包含大量原汁原味的考试试题以及自适应测试引擎。本书不仅适用于准备MCDBA考试，也是设计、实现和管理Microsoft SQL Server数据库的重要资源。

Introduction1

Chapter 1 Introducing Microsoft SQL Server 20003

Northwind Distributors Case Study3

Microsoft SQL Server 2000 Overview4

Implementation Architectures4

How Clients Communicate with SQL Server6

SQL Server Services8

Default Databases9

What a Database Includes10

New Features in SQL Server 200012

Planning a SQL Server 2000 Installation15

What Is the Primary Function of This Server?15

What Are the Performance and Redundancy Expectations?16

Will Replication Be Required?17

How Will SQL Server Be Licensed?17

Chapter Review18

Questions18

Answers19

Chapter 2 Installing SQL Server 200021

Installing SQL Server 200021

Performing a Local Installation21

Performing a Remote Installation25

Installing the Client Utilities27

Unattended Installation28

Upgrading to SQL Server 200031

Upgrade Requirements31

Upgrading SQL Server 7.0 to SQL Server 200031

Upgrading SQL Server 6.5 to SQL Server 200031

Troubleshooting SQL Server Installations35

Failed Installations and General Troubleshooting35

Connectivity Problems35

Uninstalling SQL Server 200035

Chapter Review36

Questions36

Answers38

Chapter 3 Configuring Microsoft SQL Server 200039

Verifying Your SQL Server 2000 Installation39

Windows 2000 Service Control Manager39

SQL Server Service Manager40

SQL Server Administration Tools42

SQL Server Enterprise Manager42

Client Network Utility45

Configure SQL XML Support in IIS46

Import and Export Data46

SQL Profiler47

SQL Query Analyzer48

Server Network Utility48

Common Configuration Tasks50

SQL Server Startup50

Connection Management52

Configuring Mail Support56

Configuring Network Libraries57

Introducing the Structured Query Language58

Transact-SQL Commands58

Using the SQL Query Designer64

Chapter Review66

Questions67

Answers69

Chapter 4 Creating SQL Server 2000 Databases70

What Is a SQL Server Database?70

Where the Data Is Stored71

Creating a Database72

Modifying a Database76

Available Database Options76

Setting Database Options80

Changing the Size of a Database82

Attaching and Detaching a Database84

Chapter Review86

Questions86

Answers88

Chapter 5 Creating and Managing Database Objects89

Introducing Tables89

Primary and Foreign Keys90

Creating a Table93

Modifying Tables98

Deleting Tables101

Introducing the Database Designer101

Introducing Constraints106

Introducing Indexes109

Creating an Index111

Deleting an Index112

Introducing Stored Procedures113

Executing Stored Procedures115

Creating Stored Procedures116

Modifying a Stored Procedure118

Deleting a Stored Procedure118

Introducing Triggers119

Creating a New Trigger120

Reviewing and Editing an Existing Trigger123

Introducing Views125

Examining Existing Views126

Accessing the Data in a View126

Creating Views127

Modifying Views130

Deleting Views132

Chapter Review132

Questions132

Answers134

Chapter 6 Managing and Monitoring SQL Server 2000 Security 136

Configuring the SQL Server Security Mode136

Windows Authentication Mode136

Mixed Mode138

Creating and Managing Logins139

Delegation and Impersonation143

Creating and Managing User Accounts143

Creating and Managing Security Roles145

Server Roles146

Database Roles147

Creating Database Roles149

Setting permissions in a database150

Enforce and manage security154

Manage Security Auditing154

Auditing Security with the SQL Profiler (SP)155

Chapter Reivew159

Questions160

Answers162

Chapter 7 Managing, Monitoring, and Troubleshooting SQL Server 2000 Databases163

Optimizing Database Performance163

Indexes164

The Index Tuning Wizard164

Customize Locking165

Recompiling170

Optimizing Hardware Use170

Managing Server Memory171

Managing Server Processors173

Managing Hard Drives174

Optimizing Files and Filegroups174

Performing Disaster Recovery Operations176

Performing Backups176

Recovering and Restoring Data182

Configuring, Maintaining, and Troubleshooting Log Shipping185

Performing Integrity Checks187

Using SQL Server Agent190

Creating and Managing Jobs190

Configuring Operators and Alerts193

Chapter Review195

Questions195

Answers197

Chapter 8 Extracting and Transforming Data with SQL Server 2000198

Supporting the Extensible Markup Language (XML)198

XML Overview199

Setting up IIS201

Importing and Exporting Data205

Using the Bulk Copy Program (BCP)206

Using Data Transformation Services (DTS)210

Introducing DTS211

Developing and Managing DTS Packages211

Transforming Data with DTS216

Managing Linked Servers218

Creating a Linked Server218

Executing Heterogeneous Queries220

Managing Replication Services220

Replication Service Architecture220

Implementing Replication222

Chapter Review240

Questions241

Answers242

Chapter 9 Developing a Logical Data Model243

Defining Entities244

Determining the Primary Entities244

Defining the Attributes of Your Entities244

Selecting a Level of Normalization245

Designing Entity Keys246

Primary Key246

Foreign Key247

UNIQUE Constraints248

Designing Attribute Domain Integrity249

CHECK Constraints250

Data Types250

Creating a User-Defined Data Type with the Enterprise Manager252

Selecting Attribute Properties253

Designing Logical Data Models from Business Scenarios255

Exercise #1: Southwest Bookstore255

Exercise #1: Southwest Bookstore Suggested Solution256

Chapter Review257

Questions258

Answers260

Chapter 10 Implementing the Physical Database261

Creating a New Database261

Database Properties263

Creating the Southwest Bookstore Database264

Creating Database Objects268

Creating Tables268

Creating Indexes276

Creating Views278

Creating Stored Procedures281

Creating User-Defined Functions285

Chapter Review288

Questions288

Answers289

Chapter 11 Retrieving and Modifying Data291

Performing Bulk Data Operations291

Using the Bulk Copy Program (BCP)292

Using the Bulk Insert T-SQL Command294

Using Data Transformation Services (DTS)296

Managing Data Using Transact-SQL304

Transact-SQL Commands305

Using Cursors with Transact-SQL310

Navigating a Cursor312

Accessing Data in a Heterogeneous Environment313

Creating a Linked Server313

Executing Queries to Linked Servers315

Accessing Data Using Heterogeneous Queries315

Returning Data Using XML317

Extensible Markup Language (XML) Overview317

Accessing XML Data with a URL319

Chapter Review321

Questions322

Answers324

Chapter 12 Programming Business Logic325

Designing Stored Procedures325

Creating Stored Procedures326

Using Input Parameters329

Using Output Parameters330

Modifying a Stored Procedure Using T-SQL331

Deleting a Stored Procedure332

Creating Triggers333

Creating a New Trigger333

Reviewing and Editing an Existing Trigger337

Developing User-Defined Functions339

Creating Views340

Implementing Views341

Accessing the Data in a View343

Modifying Views344

Deleting Views346

Chapter Review346

Questions347

Answers349

Chapter 13 Designing a Database Security Plan350

How SQL Server Manages Database Access350

Windows Authentication Mode350

Mixed Mode351

SQL Server Logins351

SQL Server Roles354

Controlling Table Access355

Restricting Access at the Table Level355

Restricting Access at the Column Level356

Controlling Access Using Other Database Objects358

Using Stored Procedures358

Using Triggers359

Using User-Defined Functions360

Controlling Access Using Views361

Using Application Roles362

Chapter Review363

Questions364

Answers365

Chapter 14 Tuning and Optimizing Data Access367

Optimizing Database Performance367

Indexes368

Customize Locking371

Analyzing Query Execution Plans375

Interactively Executing a Stored Procedure377

Using the SQL Profiler to Analyze Performance380

Chapter Review383

Questions384

Answers386

Appendix A Microsoft Certification Exam Prep 70-228387

Questions387

Answers398

Appendix B Microsoft Certification Exam Prep 70-229402

Questions402

Answers414

暂无相关内容，正在全力查找中

暂无出版社相关信息，正在全力查找中！

暂无相关书籍摘录，正在全力查找中！

在线阅读地址：MCDBA SQL Server 2000考试指南(含盘,英文原版)在线阅读

在线听书地址：MCDBA SQL Server 2000考试指南(含盘,英文原版)在线收听

在线购买地址：MCDBA SQL Server 2000考试指南(含盘,英文原版)在线购买

暂无原文赏析，正在全力查找中！

书籍介绍

本书是美国著名的出版商McGraw-Hill出版的畅销认证系列丛书All-in-One之一。包含微软认证数据库管理员（MCDBA）认证两门核心考试的内容，全面介绍了SQL Server的各种不同版本，包括每个版本支持的操作系统，以及SQL Server 2000的高级特性。读者可以学到如何进行本地和远程安装、管理Windows 2000 Server和SQL Server 2000以及管理和维护数

• 作者：迪克格雷森 发布时间：2023-12-10 02:24:59

  高龙巴和哥哥骑马路过仇人门口还狠狠瞪着里面的描写真的很有意思

• 作者：行吟泽畔 发布时间：2010-07-19 23:56:30

  浪漫主义

• 作者：某吉 发布时间：2013-01-17 09:26:49

  我好爱小布头！

• 作者：小橘子Leo 发布时间：2022-12-04 13:28:13

  一般，相比这套书的素描差很多

• 作者：Ein 发布时间：2020-11-16 18:33:25

  一遍刷完，大部分句子还是看不懂，哭

• 作者：阿一 发布时间：2019-07-20 23:11:04

  把埃及的方方面面的都串起来了，从地理、建筑、科学到信仰、艺术和社会，是本适合全方位了解埃及的书，而且配图丰富，带你逐步领略这个神奇的国度

• 科学的共性

  作者：(。-`ω´-) 发布时间：2017-03-18 16:49:12

  生物学领域的一个巨大秘密，是细胞内线粒体拥有自己的遗传基因，但现在几亿年过去，只有高等细胞就像人类细胞线粒体还有37对基因，这些线粒体遗传基因的消失其实很像兰道儿描述的暗物质与普通物质之间的作用过程。曾有人（忘了谁）取名叫梯度下降的生物学近似 Biologically Plausible Approximations of Gradient Descent。

  同样，

  这可以类比为一种算法，而且大脑中可能用来实现对梯度下降算法近似的可能机制意外地多。也就是利用反馈连接传播误差。一个例子是 O'Reilly 的 XCAL 算法 (O'Reilly et al., 2012)，通过本地的 Hebbian 学习法则实现了误差的反向传播。这应该与暗物质相互作用成为普通物质类似。

  实现反向传播的另一个可能途径是基于脉冲时间的可塑性 (STDP)。就像人的神经元可以通过脉冲速率的时间导数来编码反向传播所需的误差导数。这中间有些信号莫名其妙的消失了。

  —2017.3.18

• 非常实用

  作者：月光海洋 发布时间：2018-11-14 13:56:38

  每个单元有一页讲解，一页练习，适合每1-2天学习一课。

  细致分析了在什么情景中用什么语法，从讲解到练习都是一些实际生活中会遇到的例子。

  并不是用背诵来学习，而是采用了理解和浸入式的方式。

  很多知识点会反复出现，用不同的例子帮助读者反复回想，从而加深理解和记忆。

  学习压力和负担更小，而且对口语、阅读和写作助益颇多。

  很多练习的考查点也对英语类考试很有帮助。

  对生活、工作和考试都非常实用，自学也很合适~

  有零碎时间的，可以每天坚持学一点。

  有集中一段时间可以学习的，也可以集中突击。