MCSE Administering SQL Server 7考前冲刺pdf电子书版本下载

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

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

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

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

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

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

Chapter 1 Microsoft Certification Exams 1

Assessing Exam-Readiness 2

The Exam Situation 2

Exam Layout And Design 3

Microsoft s Testing Formats 5

Strategies For Different Testing Formats 7

Exam-Taking Basics 10

Mastering The Inner Game 10

Additional Resources 11

Chapter 2 SQL Server Overview 13

Introduction To Application Architectures 14

SQL Server Architecture Overview 15

SQL Server Functions And Features 16

The Four System Databases In SQL Server 7 17

Practice Questions 19

Need To Know More? 21

Chapter 3 Server Installation,Configuration,And Upgrades 23

Overview Of Installing SQL Server 24

Planning For Installation 24

Preparing For Installation 30

Installing SQL Server 31

Upgrading SQL Server 32

Unattended Installations 38

Troubleshooting The Installation 40

Troubleshooting An Upgrade 40

Testing An Installation 40

Starting And Stopping SQL Server 41

Configuring SQL Server 42

Configuring SQL Mail 44

Setting Up A Failover Server 45

Installing A Client Computer 46

Uninstalling SQL Server 47

Practice Questions 48

Need To Know More? 52

Chapter 4 Security 53

Security Overview 54

Authentication 54

Accessing Databases 59

Roles 61

Permissions 67

Limitations On Logins,Users,Roles,And Passwords 71

Practice Questions 72

Need To Know More? 76

Chapter 5 Databases And Files 77

Database Overview 78

The Transaction Log 80

Creating Databases 81

Planning A Database 81

Altering Databases 83

Configuring Databases 88

Viewing Database Information 90

Practice Questions 92

Need To Know More? 95

Chapter 6 Transferring Data 97

The INSERT Statement 98

The SELECT INTO Statement 103

The BULK INSERT Statement 104

The bcp Program 107

The Data Transformation Service 112

Practice Questions 119

Need To Know More? 123

Chapter 7 Backing Up Databases 125

Backup Devices 126

Types Of Backups 126

The BACKUP Command 128

Choosing A Backup Strategy 137

Practice Questions 138

Need To Know More? 141

Chapter 8 Restoring Databases 143

The RESTORE Command 144

Other RESTORE Options 151

Relevant System Tables 154

Practice Questions 155

Need To Know More? 157

Chapter 9 Monitoring The Server 159

The SHOWPLAN Command 160

The UPDATE STATISTICS Command 163

The Error Log 165

The sp_who Stored Procedure 167

The sp_lock Stored Procedure 168

The sp_spaceused Stored Procedure 169

The sp_monitor Stored Procedure 170

The Database Consistency Checker(DBCC) 172

Detecting And Resolving Locking Problems 172

SQL Server Profiler 175

Monitoring With Windows NT Performance Monitor 176

Practice Questions 177

Need To Know More? 181

Chapter 10 Automating Administrative Tasks 183

Overview Of Automated Administration 184

Defining Jobs,Operators,and Alerts 186

Practice Questions 195

Need To Know More? 198

Chapter 11 Replication 199

The Publish And Subscribe Model 200

Overview 200

Setting Up Replication 202

Practice Questions 236

Need To Know More? 240

Chapter 12 Remote Data Access 241

Overview 242

Remote Procedure Calls 242

Distributed Queries 247

Distributed Transactions 253

Practice Questions 257

Need To Know More? 261

Chapter 13 SQL Server 7 Troubleshooting 263

Handling Problems With Upgrading From SQL Server 6.x 264

Handling Problems With BACKUP And RESTORE Operations 265

Handling Replication Problems 267

Handling Distributed Query Problems 271

Handling Problems With Access To SQL Server,Databases,And Database Objects 273

Practice Questions 275

Need To Know More? 278

Chapter 14 Sample Test 279

Questions,Questions,Questions 280

Picking Proper Answers 280

Decoding Ambiguity 281

Working Within The Framework 282

Deciding What To Memorize 283

Preparing For The Test 284

Taking The Test 284

Sample Test 286

Chapter 15 Answer Key To Sample Test 305

Appendix Pubs Database 313

Glossary 321

Index 339