Free SQL Server Training
The internet has many free training resources for SQL Server DBA's and Developers. They include tutorials, whitepapers, webcasts, videos, and podcasts.
Table of Contents
- Training: Labs
- Training: Podcasts
- Training: Videos
- Training: Webcasts
- Training: Whitepapers
- General Skills
- SQL Server
- SQL Server 2008
- SQL Server 2005
- Virtual Server
Training
-
Training: Labs
- Microsoft's Virtual Labs
Microsoft Virtual labs provide a safe environment to learn learn various Microsoft technologies.
Recommendation: Print the tutorial before beginning - SQL Server 2008 Virtual Labs
-
Training: Podcasts
- Podcasts hosted on SQLServerPedia
-
Training: Tutorials
- 102 SQL Server 2005 Tutorials and Articles (mostly a dump of links from a few sites)
- SQL Server 2008 Books Online Tutorials - Microsoft
-
Training: Videos
- SQLShare - free SQL Server how to videos.
- Midnight DBA (Blog) by Sean McCown
-
Training: Webcasts
- Pain-of-Week Webcasts (Archive) from Quest Software
- Webcasts from Idera
- Microsoft's Webcasts
- Scripting Guys' Webcasts
Training: Whitepapers
General Skills
-
Skills: SQL
- http://www.sql-tutorial.net/
- http://www.firstsql.com/tutor.htm
- http://www.w3schools.com/sql/default.asp
- The Curse and Blessings of Dynamic SQL - 2008-12-26 by Erland Sommerskog
- Pivoting, Un-pivoting and Aggregating: A Quick Spin Around the Block by Phil Factor - Simple-talk
-
Skills: Windows Scripting
- Scripting Guys' Webcasts - Webcasts on writing window's scripts
SQL Server
- Tutorial: Learn SQL Server basics from A-Z from SearchSQLServer.com Published Nov 06, 2008. A collection of 35+ articles.
- Exforsys Inc - has a large collection of short training articles for SQL Server.
SQL Server 2008
- SQL Sever 2008 Webcasts, Virtual Labs and Podcasts from Microsoft
- Upgrade and Migration to SQL Server 2008 Webcast
- Collection of SQL Server 2008 webcasts mostly from Idera
- SQL Server 2008 video series on ITTV.net
- SQL Server 2008 Virtual Labs
SQL 2008: Administration
- Index Guide by Brad McGehee - Simple-talk
- Disk Partition Alignment Best Practices for SQL Server (Whitepaper) Writers Jimmy May, Denny Lee
- A Deadlock Occurrence and Resolution by Praveen Voleti - SQL ServerCentral
- Introduction to SQL Server FileStream by Jacob Sebastions - Simple-talk
- Microsoft SQL Server 2008 Learning Guide - SearchSQLServer.com
SQL 2008: Analysis Services (SSAS)
- SQL Server Analysis Services Tutorial - Microsoft's Books Online
SQL 2008: Data Mining
- SQL Server Analysis Services - Data Mining - Microsoft's Books Online
SQL 2008: High Availability
- SQL Server 2008 Failover Clustering (Download) - Microsoft
- Windows Failover Clustering Overview by Rob
- Scheduling Sub-Minute Log Shipping in SQL Server 2008 (Download) - Microsoft
- Six Failover Clustering Benefits Realized from Migrating to SQL Server 2008 by Joseph Sack - SQLCAT.COM
SQL 2008: Integration Services (SSIS)
- SSIS 2008 Crib Sheet by Robert Sheldon - Simple-Talk
SQL 2008: Performance
- Introduction to SQLDIAG for SQL Server Performance Monitoring and Tuning by Ray Barley - MSSQLTips.com
SQL 2008: Reporting Services (SSRS)
- Using Visual Studio to Develop Reports by Drew Salem - SQL Server Central
- Diagnosing Reporting Server Issues by Lukasz Pawlowski
- Creating a new report using Report Builder 2.0 by Decipherinfosys - System Engineering and RDBMS
SQL 2008: Power Shell
- Windows Power Week Webcast from Scripting Guy
- SQL Server PowerShell from Belle's SQL Musings
- Practical PowerShell (Video Series) by Don Jones from Idera
- Powershell series by Charley Hanania
SQL 2008: SMO
- Getting Started with SQL Server Management Objects (SMO) by Arshad Ali - MSSQLTips.com. Uses C# and includes samples for SQL Server 2005
- SQL Server Management Objects - C# Online.net. Explains the purpose for the SQL Server Assemble References.
SQL 2008: XML
- SQL Server XML from Belle's SQL Musings
- XML Workshops by Jacob Sebastiana
SQL Server 2005
- SQL Server 2005 Technical Articles from Microsoft
- SQL Server Tutorials from EXforsys Inc (Note: Embedded ads)
- 102 SQL Server 2005 Tutorials and Articles (mostly a dump of links from a few sites)
- SQL Server 2005 Books Online
- SQL Server 2005 Virtual Labs
-
SQL 2005: Administration
- SQL Server 2005 Essentials - Database Developer - 14 parts
- SQL Server 2005 for IT Professional - Administrators - 11 parts
- SQL Server PerfMon screen casts by Kevin Kline March 05, 2008
- Tips: 12 Essential Steps After Installing SQL Server by Sadequl Hussain - 2009-07-13
- Working with TEMPDB in SQL Server 2005 (30 Page Word Doc) - Book Online
SQL 2005: Analysis Services (SSAS)
- SQL Server Analysis Services Tutorial - Microsoft's Books Online
SQL 2005: Data Mining
- SQL Server Analysis Services - Data Mining (Webcast)- Microsoft's Books Online
SQL 2005: High Availability
- Pro SQL Server 2005 High Availability (Limited Preview) by Allan Hirt - hosted by Google Books
SQL 2005: Failover - Cluster
- SQL Share - free SQL Server how to videos. The clustering videos are very helpful.
-
SQL 2005: Integration Services (SSIS)
- Making SQL Server 2005 SSIS Packages Portable by Vyaskn
- SQL Server Integration Services - collection of webcasts
- SQL Server 2005 Integration Services - Microsoft site with tutorials, whitepapers, and webcasts.
- SQL Server Integration Services an Introduction by Arshad Ali (2009). Multi-part series of easy to read articles introducing SSIS many features and how to use them.
- Creating a Basic Package (SQL Server 8 min. video) from Microsoft Technet.
- SQL Server Books Online > Integration Services Tutorials step-by-step Tutorials for creating SSIS packages. Also available on your PC through books online.
- Making SQL Server 2005 SSIS Packages Portable
- SQL Share SSIS Videos - these helpful videos are short and to the point.
- Tutorial: SSIS best practices from SearchSQLServer.com
- Passing Variables by Patrick Index - Simple-Talk
- How to: Map Query Parameters to Variables - Technet
SQL 2005: Integration Services (SSIS) Migration
- DTS for SQL Server 2005-FAQ
- TechNet Webcast: From DTS to SSIS: Making the Move to SQL Server Integration Services
SQL 2005: Performance
- Using Windows Logman (Perfmon) by Ranga Narasimhan from MSSQLTips.com
- Microsoft Engineer's Approach to Diagnostic HIGH CPU SQL
- Using Plan Guides to Tune Queries (2008-11-19) by Armado Prato - MSSQLTips
SQL 2005: Reporting Services (SSRS)
- Beginning SQL Server 2005 Reporting Services Part 1 by Steve Joubert
- SQL Server 2005 Books Online > Reporting Services Tutorials is a good tutorial to get you started using reporting services.
- Microsoft SQL Server Reporting Services On-Demand Webcasts
- Microsoft Virtual Labs SQL Server 2005 Reporting Services
- Diagnosing Reporting Server Issues by Lukasz Pawlowski
- Installing and Configring SQL Sever 2005 Reporting Services by Akjosji
- Report Builder Introduction by Mike Gunderloy
SQL 2005: Windows Scripts
Virtual Server
- Virtual Servers are not Free (Whitepaper) by Alex Bakman
- Creating a Two-Node cluster using Microsoft Virtual Server 2005 (Instructions) by Robert Larson - Microsoft. Includes many related links on configuring clusters.
| << | Top | >> |