Time to time I get questions asked about training and learning more about SQL Server management, maintenance, best practices. As with every Microsoft product I say they are best learnt with hands on technique, that is to say get yourself a copy of the software (of course legally/eval versions) and install it and as most things are wizard driven and well documented you can learn a lot about the product. I always suggest that when you go down this route always ensure you read the SQL Server books online as this provides context around the actions you are doing instead of just clicking Next.
Post this there are several resources and I am listing a few of my favourite ones, and I would be interested to hear back from of any others that worked particularly well for you.
|Type of Training||Links/More information|
Training Catalog – http://learning.microsoft.com/Manager/BrowseResults.aspx?browseval=pt&pid=55%252371%252374&cid=74&qry=&navclicked=1&nav=productandtechnology%3aServer+Technologies%2fMicrosoft+SQL+Server%2fMicrosoft+SQL+Server+2008
|SQL Server TechCenter – http://technet.microsoft.com/en-us/sqlserver/default.aspx
SQL Server Books Online – http://technet.microsoft.com/en-us/library/bb545450.aspx
SQL CAT Team – www.sqlcat.com
Forums – http://social.msdn.microsoft.com/Forums/en-US/category/sqlserver
It so happens that while I was writing this blog one my SQL Server colleagues Victor Isakov sent me an email providing details about a SQL Server 2008 training he is about to deliver. Below if further information about Victor and the topics he plans to cover in his course. Please email Victor directly to register your interest in the training. Victor’s email – firstname.lastname@example.org.
Victor Isakov is a Database Architect and Microsoft Certified Trainer who enjoys a reputation of being one of the most knowledgeable subject matter experts on SQL Server. Victor has provided consulting and training services around the world for over 15 years. He has authored a number of books on SQL Server and worked for Microsoft (Redmond) to develop the SQL Server exams/certifications.
In 2007 Victor was invited by Microsoft to attend the SQL Ranger program at Redmond in the US. Consequently he was one of the first IT professionals to achieve the Microsoft Certified Master: SQL Server and Microsoft Certified Architect: SQL Server certifications globally.
Currently, Victor is the only Microsoft Certified Architect: SQL Server in Australia.
SQL Server Training outline:
- SQL Server Architecture
- Installing and Configuring SQL Server
- Optimal SQL Server Configuration
- Managing Databases and Files
- Optimal Database Configuration
- Disaster Recovery
- Managing Security
- Transferring Data
- Automating Administrative Tasks
- Essential Database Maintenance
- Implementing Replication
- Maintaining High Availability
- Design Considerations for High Availability Solutions
- Monitoring SQL Server
- Troubleshooting and Performance Tuning