MySQL DBA course for Intermediate trainees by ENOSIS LEARNING

13. SQL SERVER 2008 DATABASE ADMINISTRATION
SQL Server 2008 Database Administration Course

Installing and Configuring
System Requirements for SQL Server 2008
Upgrading and Migrating to SQL Server 2008
Configuring Instances in SQL Server 2008
Creating and Managing Databases
Examining disk structures
Creating databases and transaction logs
Defining file groups
Permitting automatic database growth
Adding database files to expand databases
Specifying database options
Scripting objects and moving data with Transact-SQL
Detaching and attaching databases
Implementing Server and Database Security
Contrasting Windows and SQL Server authentication
Authorizing logins
Making logins members of server roles
Enforcing password policy
Adding users
Defining new roles
Delegating privileges with predefined roles
Assigning users to roles

Managing Permissions
Permitting object creation
Granting blanket permissions
Designing schemas
Assigning a default schema
Limiting object access
Meeting complex permission requirements with roles
Examining permission hierarchies

Recovering from Disasters
Choosing a recovery model
Transaction log architecture
Performing full, log and differential backups
Reclaiming transaction log space
Recovering user databases
Testing recovery scenarios

Automating Tasks with Jobs and Alerts
Configuring the agent
Setting up Database Mail
Defining jobs to handle routine tasks
Creating alerts and operators
Associating alerts with jobs

Performing Database Maintenance
Identifying and curing fragmentation
Finding and repairing database corruption
Choosing maintenance tasks
Scheduling plan execution
Monitoring SQL Server
Identifying problems with Activity Monitor
Querying Dynamic Management Objects
Configuring data collection
Reviewing the reports
Establishing SQL Server Failover Clustering
Leveraging virtual machines for clustering
Geographically dispersed clusters
Installing a new failover cluster
Adding a new mode
Failing over to a passive node
Employing Log Shipping
Synchronizing logins
Creating network shares
Specifying log backup frequency
Configuring the log shipping monitor
Redirecting applications
Bringing the standby online

Configuring Database Mirroring
Comparing mirroring Architectures
Setting the recovery model
Selecting the principal, mirror and witness servers
Configuring the principal, mirror and witness
Initiating the mirroring session
Enabling and disabling mirroring with scripts
Launching the Database Mirroring Monitor (DMM)
Taking a database snapshot
Querying a snapshot of the mirror

Leveraging Replication for High Availability
Enumerating types of replication
Making the business case
Creating distributors
Initializing databases
Creating and subscribing to a publication