SQL Server Learning Path and Training: Useful Links and Websites
Following useful links are collected, read, understood and compiled over the period of time.
SQL Server learning Path
- SQL Server Learning Path - Simple, Easy Steps
- SQL Server Learning Competency Levels (100, 200, 300, 400)
Free Online Courses & Tutorials
- SQL Server Hub
- SQL Server Documentation
- SQL Server Samples and Databases
- http://www.microsoftvirtualacademy.com/product-training/sql-server
- http://technet.microsoft.com/en-us/virtuallabs/default
- http://technet.microsoft.com/en-us/sqlserver/dd353197
- https://www.sqlskills.com/sql-server-resources/sql-server-mcm-training-videos/
- http://www.brentozar.com/first-aid/video-archive
- http://blogs.technet.com/b/cansql/archive/2013/10/31/11-free-sql-server-2012-online-training-courses-to-sharpen-your-skills.aspx
- http://www.toadworld.com/platforms/sql-server/w/wiki/default.aspx
- http://www.sqlservercentral.com/stairway/
- http://www.sqlservercentral.com/Articles/Video
- http://www.sqlservercentral.com/Training
- http://sqltidbits.com/videos
- https://www.sqlskills.com/help/accidental-dba
- http://sqlblog.com/blogs/adam_machanic/archive/2011/04/01/a-month-of-monitoring-part-1-of-30-a-brief-history-of-monitoring.aspx
- http://www.mssqltips.com/tutoriallist.asp
- Building Environment for Learning and Testing - Jonathan Kehayias
Free Tools & Well Known Scripts
- http://sqlmag.com/database-performance-tuning/mega-guide-free-sql-server-tools
- https://ola.hallengren.com
- https://sqlserverperformance.wordpress.com/category/diagnostic-queries
- http://www.brentozar.com/first-aid/sql-server-downloads
- https://www.idera.com/productssolutions/freetools
- http://www.apexsql.com/free
- http://www.johnsansom.com/top-10-free-sql-server-tools
- http://www.sql-server-performance.com/sql-server-scripts
- http://www.sqlservercentral.com/Scripts
- http://www.databasejournal.com/scripts
- http://architectshack.com/PoorMansTSqlFormatter.ashx
- http://www.ssmstoolspack.com
- http://www.sqltreeo.com/wp
- http://elsasoft.com
- https://sqlcequery.codeplex.com
- http://sqlcetoolbox.codeplex.com
- Microsoft Assessment and Planning Toolkit
- http://www.mssqltips.com/productlist.asp
- SSMS Boost
- sp_WhoIsActive - Who Is Active by Adam Machanic
- dbatools - PowerShell
- SQL Cheat sheet: https://websitesetup.org/sql-cheat-sheet/ (by Luke Harrison)
Paid Online Training by Gurus or by Universites
- SqlSkills.Com - Paul S. Randal and Kimberly L. Tripp (Rolling Monthly Payment)
- BrentOzar.Com (One-off payment per course - for 18 Months limited)
- PluralSight.com - One Stop Shop with IT Courses of industry known Gurus (Rolling Monthly Payment)
- UDemy.Com - Learn from Learned Pupils and its Economical (One-off payment per course - for lifetime)
- Marvwille Computer Courses
SQL Server Community – Interesting Bits
- http://sqlmag.com/sql-server/2013-sql-server-pro-community-choice-awards
- https://www.simple-talk.com/blogs/2014/01/06/victors-of-the-tribal-awards
- https://www.simple-talk.com/opinion
- http://channel9.msdn.com/
- http://www.sqlpass.org/
- http://www.sqlsecurity.com/
- http://www.sswug.org/
- http://www.databasejournal.com/links
- http://blogs.technet.com/b/dataplatforminsider/archive/2013/06/03/sql-server-2014-unlocking-real-time-insights.aspx
- http://sqlmag.com/sql-server-2014/evolution-sql-server-2014
- http://sqlbits.com
- http://dbareactions.com/
- http://blog.sqlauthority.com/
- SQL Server Service Packs (SP), Patches, Community Update (CU) Release Information
- SQL Server Editions - Features Supported by the Editions of SQL Server