GOC615 - Upgrading Your Database Administrator and Infrastructure Skills to SQL 2008/2008 R2
On this course are provided informations about new features of Microsoft SQL Server 2008 and 2008 R2 in area of the database administration and database infrastructure. The course is intended for database professional only.
Teaching methodsExpert instruction with practical examples, computer
practice
Course syllabus
Security Enhancements
- Extensible Key Management
- Transparent Data Encryption
- SQL Audit
- Integrated Authentication Enhancement
Manageability Enhancements
- Configuration Servers
- Policy–based Management
- Data tier application management
- Compression
Performance Enhancements
- Resource Governor
- Extended Events
- Utility management
- Performance Data Collection
Availability Enhancements
- Database Mirroring Enhancements
- Backup Compression
- Hot–Add CPU
- CHECKDB Enhancements
- Failover Clustering Enhancements
- Peer–to–Peer Replication Enhancements
Upgrade
- Pre–Upgrade Considerations
- Document and Measure
- Determine Appropriate Upgrade Strategy
- Upgrade Process
- Post–Upgrade Considerations
Additional new features
- Spatial Indexing
- Integrated Full–Text (iFTS)
- Sparse Columns
- Filtered Indexes
- FILESTREAM
- Stream Insight
Change Monitoring
- Change Tracking
- Change Data Capture
Catalog price of course and handbook
| Praha |
11700 Kč
|
--
|
30 items
|
| Brno |
11400 Kč
|
--
|
30 items
|
Course dates
|