1 Designing the Hardware and Software Infrastructure
Design for capacity requirements
Specify software versions and hardware configurations
|
Duration 2 hours |
2 Designing Physical Storage
Design physical storage
Design instances
|
Duration 1 hour |
3 Designing a Consolidation Strategy
This course covers developing a database consolidation strategy.
|
Duration 2 hours |
4 Designing Database-Level Security
Analyse business requirements
Integrate database security with enterprise-level authentication systems
Modify the security design based on the impact of network security policies
Analyse the risk of attacks to the server environment and specify mitigations
|
Duration 1 hour |
5 Designing Windows Server-Level Security Processes
This course covers how the server-wide security parameters of SQL Server are determined and set globally for each instance.
|
Duration 1 hour |
6 Designing SQL Server Service-Level Security
Design SQL Server service-level security
Design database-level security
|
Duration 1 hour |
7 Designing SQL Server Object-Level Security
This course covers the lowest level of security - the objects that store and interact with data.
|
Duration 1 hour |
8 Designing a Physical Database
Modify an existing database design based on performance and business requirements
Design tables and filegroups
Design index usage and views
|
Duration 1 hour |
9 Creating Database Conventions and Standards
Create database conventions and standards
Create database change control procedures
|
Duration 1 hour |
10 Designing a SQL Server 2005 Solution for High Availability
Develop a strategy for migration to a highly available environment
Design a highly available database storage solution
Design a database-clustering and database mirroring solutions
Design a high-availability solution based on replication
|
Duration 1 hour |
11 Designing a Data Recovery Solution for a Database
Specify data recovery technologies based on business requirements
Design backup strategies
Create a disaster recovery plan
|
Duration 1 hour |
12 Designing a Data-Archiving Solution
Select archiving techniques based on business requirements
Design the format of archival data
Specify what data to archive and plan for data archival and access
Design the topology and type of replication for archiving data
|
Duration 1 hour |
|
Duration 1 hour |
|
Duration 1 hour |
