书籍详情
电脑基础入门
作者:朱明方编著
出版社:清华大学出版社
出版时间:1994-01-01
ISBN:9787302014799
定价:¥180.00
内容简介
本书详细地介绍了SQLServer2000的配置和管理工作。其中,包括基本概念和术语、数据库安全的管理方法、数据库的日常维护、数据备份和恢复、数据转移操作、分布式数据管理及如何对数据库的性能进行监控和优化等内容。通过学习本书可以很好地掌握数据库管理员应该具备的基本知识。本书适用于计划参加相关的微软认证考试的人员使用。
作者简介
暂缺《电脑基础入门》作者简介
目录
Introduction
Course Materials
Prerequisites
Course Outline
Setup
Microsoft Official Curriculum
Microsoft Certified Professional Program
Facilities
Module 1 : SQL Server Overtriew
What Is SQL Server?
SQL Server Integration
SQL Server Databases
SQL Server Security
Working with SQL Server
Lab A: SQL Server Overview
Review
Module 2: Planning to Install SQL Server
Hardware Installation Considerations
SQL Server 2000 Editions
Software Installation Considerations
Methods of Installing SQL Server
Upgrading SQL Server
Verifying the Installation
Configuring SQL Server Enterprise Manager
Troubleshooting
Recommended Practices
Lab A: Installing SQL Server
Review
Module 3: Managing Database Files
Introduction to Data Structures
Creating Databases
Managing Databases
Placing Database Files and Logs
Optimizing a Database Using Hardware-based RAID
Optimizing a Database Using Filegroups
Optimizing the Database Using Filegroups with Hardware-based RAID
Capacity Planning
Performance Considerations
Recommended Practices
Lab A: Managing Database Files
Review
Module 4: Managing Security
Implementing an Authentication Mode
Lab A: Managing Security
Assigning Login Accounts to Users and Roles
Assigning Permissions to Users and Roles
Managing Security Within SQL Server
Lab B: Managing Permissions
Managing Application Security
Lab C: Managing Application Security
Managing SQL Server Security in the Enterprise
Recommended Practices
Review
Module 5: Performing Administrative Tasks
Configuration Tasks
Lab A: Configuring SQL Server
Routine SQL Server Administrative Tasks
Automating Routine Maintenance Tasks .
Lab B: Creating Jobs and Operators
Creating Alerts
Troubleshooting SQL Server Automation
Lab C: Creating Alerts
Automating Multiserver Jobs
Recommended Practices
Review
Module 6: Backing Up Databases
Preventing Data Loss
Setting and Changing a Database Recovery Model
SQL Server Backup
When to Back Up Databases
Performing Backups
Types of Backup Methods.
Planning a Backup Strategy
Performance Considerations
Recommended Practices
Lab A: Backing Up Databases
Review
Module 7: Restoring Databases
SQL Server Recovery Process
Preparing to Restore a Database
Restoring Backups
Restoring Databases from Different Backup Types
Restoring Damaged System Databases
Recommended Practices
Lab A: Restoring Databases
Review
Module 8: Monitoring SQL Server for Performance
Why to Monitor SQL Server
Performance Monitoring and Tuning
Tools for Monitoring SQL Server
Common Monitoring and Tuning Tasks
Recommended Practices
Lab A: Monitoring SQL Server
Review
Module 9: Transferring Data
Introduction to Transferring Data
Tools for Importing and Exporting Data in SQL Server
Introduction to DTS
Transforming Data with DTS
Recommended Practices
Lab A: Transferring Data
Review
Module 10: Maintaining High Availability
Introduction to Availability
Increasing Availability Using Failover Clustering
Standby Servers and Log Shipping
Recommended Practices
Lab A: Automating the Maintenance of a Standby Server
Review
Module 11 : Introducing Replication
Introduction to Distributed Data
Introduction to SQL Server Replication
SQL Server Replication Agents
SQL Server Replication Types
Physical Replication Models
Recommended Practices
Lab A: Implementing Replication
Review
Appendix A
Classroom Setup Guide
Classroom Requirements
Classroom Configuration
Setup Instractions
Automated Classroom Setup
Classroom Setup Checklist
Customization Information
Course Materials
Prerequisites
Course Outline
Setup
Microsoft Official Curriculum
Microsoft Certified Professional Program
Facilities
Module 1 : SQL Server Overtriew
What Is SQL Server?
SQL Server Integration
SQL Server Databases
SQL Server Security
Working with SQL Server
Lab A: SQL Server Overview
Review
Module 2: Planning to Install SQL Server
Hardware Installation Considerations
SQL Server 2000 Editions
Software Installation Considerations
Methods of Installing SQL Server
Upgrading SQL Server
Verifying the Installation
Configuring SQL Server Enterprise Manager
Troubleshooting
Recommended Practices
Lab A: Installing SQL Server
Review
Module 3: Managing Database Files
Introduction to Data Structures
Creating Databases
Managing Databases
Placing Database Files and Logs
Optimizing a Database Using Hardware-based RAID
Optimizing a Database Using Filegroups
Optimizing the Database Using Filegroups with Hardware-based RAID
Capacity Planning
Performance Considerations
Recommended Practices
Lab A: Managing Database Files
Review
Module 4: Managing Security
Implementing an Authentication Mode
Lab A: Managing Security
Assigning Login Accounts to Users and Roles
Assigning Permissions to Users and Roles
Managing Security Within SQL Server
Lab B: Managing Permissions
Managing Application Security
Lab C: Managing Application Security
Managing SQL Server Security in the Enterprise
Recommended Practices
Review
Module 5: Performing Administrative Tasks
Configuration Tasks
Lab A: Configuring SQL Server
Routine SQL Server Administrative Tasks
Automating Routine Maintenance Tasks .
Lab B: Creating Jobs and Operators
Creating Alerts
Troubleshooting SQL Server Automation
Lab C: Creating Alerts
Automating Multiserver Jobs
Recommended Practices
Review
Module 6: Backing Up Databases
Preventing Data Loss
Setting and Changing a Database Recovery Model
SQL Server Backup
When to Back Up Databases
Performing Backups
Types of Backup Methods.
Planning a Backup Strategy
Performance Considerations
Recommended Practices
Lab A: Backing Up Databases
Review
Module 7: Restoring Databases
SQL Server Recovery Process
Preparing to Restore a Database
Restoring Backups
Restoring Databases from Different Backup Types
Restoring Damaged System Databases
Recommended Practices
Lab A: Restoring Databases
Review
Module 8: Monitoring SQL Server for Performance
Why to Monitor SQL Server
Performance Monitoring and Tuning
Tools for Monitoring SQL Server
Common Monitoring and Tuning Tasks
Recommended Practices
Lab A: Monitoring SQL Server
Review
Module 9: Transferring Data
Introduction to Transferring Data
Tools for Importing and Exporting Data in SQL Server
Introduction to DTS
Transforming Data with DTS
Recommended Practices
Lab A: Transferring Data
Review
Module 10: Maintaining High Availability
Introduction to Availability
Increasing Availability Using Failover Clustering
Standby Servers and Log Shipping
Recommended Practices
Lab A: Automating the Maintenance of a Standby Server
Review
Module 11 : Introducing Replication
Introduction to Distributed Data
Introduction to SQL Server Replication
SQL Server Replication Agents
SQL Server Replication Types
Physical Replication Models
Recommended Practices
Lab A: Implementing Replication
Review
Appendix A
Classroom Setup Guide
Classroom Requirements
Classroom Configuration
Setup Instractions
Automated Classroom Setup
Classroom Setup Checklist
Customization Information
猜您喜欢