Microsoft SQL SERVER Training and Courses

MODULES:

Microsoft SQL Server

1. What’s New in Microsoft SQL Server
2. Microsoft SQL Server 2005 Editions, Capacity Limits, and Licensing
3. Roles and Responsibilities of the Microsoft SQL Server DBA
4. I/O Subsystem Planning and RAID Configuration
5. 32-Bit Versus 64-Bit Platforms and Microsoft SQL Server 2005
6. Capacity Planning
7. Choosing a Storage System for Microsoft SQL Server 2005
8. Installing and Upgrading Microsoft SQL Server 2005
9. Configuring Microsoft SQL Server 2005 on the Network
10. Creating Databases and Database Snapshots
11. Creating Tables and Views
12. Creating Indexes for Performance
13. Enforcing Data Integrity
14. Backup Fundamentals
15. Restoring Data
16. User and Security Management
17. Transactions and Locking
18. Microsoft SQL Server 2005 Memory Configuration
19. Data Partitioning
20. Replication
21. Integration Services
22. Analysis Services
23. Reporting Services
24. Notification Services and Service Broker
25. Disaster Recovery Solutions
26. Failover Clustering Installation and Configuration
27. Log Shipping and Database Mirroring
28. Troubleshooting, Problem Solving, and Tuning Methodologies
29. Database System Tuning
30. Using Profiler, Management Studio, and Database Engine Tuning Advisor
31. Dynamic Management Views
32. Microsoft SQL Server 2005 Scalability Options
33. Tuning Queries Using Hints and Plan Guides