SQL Server 2005数据库管理员培训(厦门高士达:2007年12月29日开课)
SQL Server 2005数据库管理员培训(厦门高士达:2007年12月29日开课)
SQL Server 2005 是一个全面的企业级数据库平台，提供了更安全可靠的存储功能，使您可以构建和管理用于业务的高可用和高性能的数据应用程序。SQL Server 2005 还结合了分析、报表、集成和通知功能。使您的企业可以构建和部署经济有效的BI解决方案，帮助您的团队通过记分卡、Dashboard、Web services 和移动设备将数据应用推向业务的各个领域。
微软认证技术专家是微软新认证之一，帮助专业人员针对各项特定技术进行学习，使他们能够在所从事领域充分展示广博而精深的技术知识与专业技能，从而成为业界佼佼者。
SQL Server 2005 微软认证技术专家(MCTS: SQL Server 2005) 证明获得者能够根据具体指令与规范实施并维护数据库，并掌握产品的全部信息，了解如何使用相关工具与Transact-SQL语言，同时也知道如何进行日常数据库管理。
在本课程中你可以学习到：
l 管理SQL Server 2005数据库和文件
管理SQL Server 2005安全l
备份和恢复SQL Serverl 2005数据库
监视SQL Server 2005性能l
迁移和转换数据l
利用代理服务完成自动化管理l服务器
实现SQL Serverl 2005高可用性
课程时间：
共12次课，3小时/次 60%理论学习，40%动手实验
上课地址：厦门市厦禾路帝豪大厦12楼
联系电话：0592－2966798
主办单位：
微软（中国）有限公司 教育培训与认证事业部
厦门高士达微软高级技术教育中心
课程大纲
课程模块
课程内容 实验内容
Module 1
PreparinglInstalling and Configuring SQL Server to Install SQL Server
Installing SQL Server 2005l
Managing a SQLl Performing an InstallationlServer 2005 Installation
Managing SQLl Server
Module 2:
PlanninglManaging Databases and Files
Databases
Creating Databasesl
Creatingl Managing Databases l a Database
Monitoring and Managing Filegroup Usagel
Viewingl Database Metadata
Module 3:
Disaster Recovery
Planning al
Backup Strategy
Backing Up User Databasesl
Restoring Userl Databases
Performing Online Restore Operationsl
Recovering Datal from Database Snapshots
l System Database and Disaster Recovery l Implementing a Backup Strategy
Restoring and Recovering a Databasel
l Performing Piecemeal Backup and Restore Operations
Restoring thel master Database
Module 4:
Managing Security
Overview of SQLl
Server Security
Protecting the Server Scopel
Protecting thel Database Scope
l Managing Keys and Certificates in SQL Server l Creating Logins and Assigning Server-Scope Permissions
Creating andl Managing Users
Using a Certificate to Protect Datal
Module 5:
Monitoring SQL Server
Viewing Current Activityl
Usingl System Monitor
Using SQL Server Profilerl
Using DDLl Triggers
Monitoring SQL Serverl Using Event Notifications l Performance
Tracing SQL Server Activityl
Implementing DDLl Triggers
Module 6:
Transferring Data
Overview of Datal
Transfer
Introduction to SQL Server Integration Servicesl
Usingl SQL Server Integration Services
Features of SQL Server Integrationl Creating an SSIS PackagelServices
Deploying an SSISl Package
Using SSIS to Extract Data, Perform Lookups, Sort, and Splitl Data
Module 7:
Automating Administrative Tasks
Automatingl
Administrative Tasks
Configuring the SQL Server Agentl
Creatingl Jobs and Operators
Creating Alertsl
Managing Multiplel Servers
Configuring SQLl Managing SQL Server Agent Security l Server Agent
Creating Operators and Jobsl
Creatingl Alerts
Module 8:
Overview oflImplementing Replication
Replication
Implementing Replicationl
Configuring Replication inl Creating a PublicationlSome Common Scenarios
Creating al Subscription
Implementing HTTP Merge Replicationl
Module 9:
Introduction to HighlMaintaining High Availability
Availability
Implementing Server Clusteringl
Implementingl Database Mirroring
Implementing Log Shippingl
Implementingl Configuring Database Mirroring to SupportlPeer-to-Peer Replication
Failover
Implementing Distributed High Availabilityl
