1.     Install SQL Server 2008 (Manually & automatically)

2.     Upgrading to SQL Server 2008 from older versions

3.     Configuring SQL Server 2008 for the enterprise

4.     Understand SQL Server Configuration Manager

5.     Manage SQL Server using PowerShell Scripting Language

6.     Understand how data is stored

7.     Understand how Transaction log works

8.     Considerations for placing data/log files.

9.     Create SQL Server databases

10.  Configure SQL Server databases

11.  Manage and update SQL Server databases

12.  Compress data from within SQL Server databases.

13.  Understand database schemas

14.  Implement Indexes for performance

15.  Understand and Implement SQLCMD

16.  Understand and work with Policy Based Management to enforce policies

17.  Centralize SQL Server management

18.  Understand various backup types and their recovery models

19.  Create backup strategy for your enterprise

20.  Compressing database backups

21.  Understanding DMV’s and Functions

22.  Understand automatic failover and client re-direction in database mirroring

23.  Checking the integrity of database backups

24.  Restore databases from backups

25.  Understand the architecture of Restore process

26.  Perform online restore operations

27.  Perform various restore operations

28.  Create a snapshot of the database for read only purpose

29.  Recover data using the snapshot copy of the database

30.  Performing backups and restores on system databases

31.  Understand the Security framework

32.  Understand and implement Principals, Securables

33.  Grant and revoke permissions at the object, database and server level

34.  Understand various authentication methods

35.  Understand how password policies work

36.  Managing SQL Server security

37.  Understanding database roles, application roles and server roles

38.  Understand the cryptography architecture of your SQL Server

39.  Understand Key’s and Certificates

40.  Encrypt your SQL Server data

41.  Understand and implement DDL triggers

42.  Understand SQL Server Audit system

43.  Transfer data to and from SQL Server using various Data Transfer tools

44.  Understanding SQL Server Integration Services

45.  Working with SSIS tools

46.  Understand SSIS connection manager, data sources and data views

47.  Deploy SSIS packages

48.  Understanding SQL Server Automation tasks using SQL Server Agent Service

49.  Understand the architecture of SQL Agent Jobs, Roles, Operators, etc.

50.  Configure SQL Server Agent Service

51.  Create a maintenance plan to perform maintenance on SQL Server

52.  Understand and Implement SQL Server Agent Alerts (both regular and performance based condition alerts)

53.  Manage multiple SQL Servers using Master / Target server concept

54.  Understanding the architecture of Replication

55.  Implementing Articles, Publication, and Subscriptions

56.  Understand various types of Replication and their use

57.  Implement Snapshot Replication

58.  Implement Transactional Replication

59.  Understand HTTP Merge Replication

60.  Understanding Peer-to-Peer Replication

61.  Understand the importance of high Availability

62.  Understand various H/A technologies in SQL Server

63.  Understand and Implement Log Shipping

64.  Understand and Implement Database Mirroring

65.  Creating SQL Server Endpoints for DBM

66.  Publishing Oracle data

67.  Understanding Windows Server Clustering

68.  Installing SQL Server in a Cluster

69.  Understanding Distributed Load Balancing

70.  Understanding Distributed High Availability

71.  Understand Replication Agents

72.  Monitoring SQL Server environment

73.  Using Activity Monitor, System Monitor

74.  Understand & Implement SQL Server Profiler

75.  Forwarding server events using Multi-Server jobs

76.  Understanding and implementing BCP

77.  Implementing and understanding event notifications in SQL Server

78.  Performance troubleshooting with SQL Server

79.  Troubleshoot concurrency problems

80.  Troubleshoot SQL Server Agent, Database mail, and disk space problems

81.  Understanding Database Tuning Advisor

82.  Checking the consistency and integrity of databases

83.  Understanding Tail-Log backups

84.  Understanding SQL Server System Configuration Checker for Installation and Upgrade

85.  Understanding the hardware and software requirements for SQL Server

86.  Implement SQL Server Capacity Planning

87.  Performance tuning with Indexes

88.  Bulk INSERT data using Bulk Insert

89.  Understand and Implement Filestreams

90.  Understand and perform restore of a damaged SQL Server data page

91.  Configuring SQL Server agent Proxies

92.  Understand Server to Client and Server to Server Replication scenarios

93.  Work with database copy wizard

94.  Create policies to administer object naming convention

95.  Restore file or filegroup from backups

96.  Generate SQL Server Configuration Reports

97.  Generate DMB Status Reports

98.  Troubleshooting SQL Server connectivity

99.  Understand and Implement Resource Governor

100. Monitor Resource Governor Performance

101. Understand, Implement and Manage SQL Server Data Collector