图书介绍

MCSE Administering SQL Server 7考前冲刺2025|PDF|Epub|mobi|kindle电子书版本百度云盘下载

（美）Jeffrey R.Garbus等著著
出版社：北京：中国水利水电出版社
ISBN：7508405366
出版时间：2001
标注页数：346页
文件大小：24MB
文件页数：385页
主题词：

PDF下载

点此进入-本书在线PDF格式电子书下载【推荐-云解压-方便快捷】直接下载PDF格式图书。移动端-PC端通用
种子下载[BT下载速度快]温馨提示：（请使用BT下载软件FDM进行下载）软件下载地址页直链下载[便捷但速度慢] [在线试读本书] [在线获取解压码]

点击复制MD5值：805848b1c7a602b8c3c68fa4fac2203a

下载说明

MCSE Administering SQL Server 7考前冲刺PDF格式电子书版下载

下载的文件为RAR压缩包。需要使用解压软件进行解压得到PDF格式图书。

点击复制85GB完整离线版磁力链接到迅雷FDM等BT下载工具进行下载详情点击-查看共享计划

建议使用BT下载工具Free Download Manager进行下载,简称FDM(免费,没有广告,支持多平台）。本站资源全部打包为BT种子。所以需要使用专业的BT下载软件进行下载。如BitComet qBittorrent uTorrent等BT下载工具。迅雷目前由于本站不是热门资源。不推荐使用！后期资源热门了。安装了迅雷也可以迅雷进行下载！

（文件页数要大于标注页数，上中下等多册电子书除外）

注意：本站所有压缩包均有解压码： 点击下载压缩包解压工具

图书目录

Chapter 1 Microsoft Certification Exams1

Assessing Exam-Readiness2

The Exam Situation2

Exam Layout And Design3

Microsoft s Testing Formats5

Strategies For Different Testing Formats7

Exam-Taking Basics10

Mastering The Inner Game10

Additional Resources11

Chapter 2 SQL Server Overview13

Introduction To Application Architectures14

SQL Server Architecture Overview15

SQL Server Functions And Features16

The Four System Databases In SQL Server 717

Practice Questions19

Need To Know More?21

Chapter 3 Server Installation,Configuration,And Upgrades23

Overview Of Installing SQL Server24

Planning For Installation24

Preparing For Installation30

Installing SQL Server31

Upgrading SQL Server32

Unattended Installations38

Troubleshooting The Installation40

Troubleshooting An Upgrade40

Testing An Installation40

Starting And Stopping SQL Server41

Configuring SQL Server42

Configuring SQL Mail44

Setting Up A Failover Server45

Installing A Client Computer46

Uninstalling SQL Server47

Practice Questions48

Need To Know More?52

Chapter 4 Security53

Security Overview54

Authentication54

Accessing Databases59

Roles61

Permissions67

Limitations On Logins,Users,Roles,And Passwords71

Practice Questions72

Need To Know More?76

Chapter 5 Databases And Files77

Database Overview78

The Transaction Log80

Creating Databases81

Planning A Database81

Altering Databases83

Configuring Databases88

Viewing Database Information90

Practice Questions92

Need To Know More?95

Chapter 6 Transferring Data97

The INSERT Statement98

The SELECT INTO Statement103

The BULK INSERT Statement104

The bcp Program107

The Data Transformation Service112

Practice Questions119

Need To Know More?123

Chapter 7 Backing Up Databases125

Backup Devices126

Types Of Backups126

The BACKUP Command128

Choosing A Backup Strategy137

Practice Questions138

Need To Know More?141

Chapter 8 Restoring Databases143

The RESTORE Command144

Other RESTORE Options151

Relevant System Tables154

Practice Questions155

Need To Know More?157

Chapter 9 Monitoring The Server159

The SHOWPLAN Command160

The UPDATE STATISTICS Command163

The Error Log165

The sp_who Stored Procedure167

The sp_lock Stored Procedure168

The sp_spaceused Stored Procedure169

The sp_monitor Stored Procedure170

The Database Consistency Checker(DBCC)172

Detecting And Resolving Locking Problems172

SQL Server Profiler175

Monitoring With Windows NT Performance Monitor176

Practice Questions177

Need To Know More?181

Chapter 10 Automating Administrative Tasks183

Overview Of Automated Administration184

Defining Jobs,Operators,and Alerts186

Practice Questions195

Need To Know More?198

Chapter 11 Replication199

The Publish And Subscribe Model200

Overview200

Setting Up Replication202

Practice Questions236

Need To Know More?240

Chapter 12 Remote Data Access241

Overview242

Remote Procedure Calls242

Distributed Queries247

Distributed Transactions253

Practice Questions257

Need To Know More?261

Chapter 13 SQL Server 7 Troubleshooting263

Handling Problems With Upgrading From SQL Server 6.x264

Handling Problems With BACKUP And RESTORE Operations265

Handling Replication Problems267

Handling Distributed Query Problems271

Handling Problems With Access To SQL Server,Databases,And Database Objects273

Practice Questions275

Need To Know More?278

Chapter 14 Sample Test279

Questions,Questions,Questions280

Picking Proper Answers280

Decoding Ambiguity281

Working Within The Framework282

Deciding What To Memorize283

Preparing For The Test284

Taking The Test284

Sample Test286

Chapter 15 Answer Key To Sample Test305

Appendix Pubs Database313

Glossary321

Index339