Free Training for SQL Server 2005

Blog Roll:

Top Links:

October 3, 2006

Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. Its primary query language is Transact-SQL, an implementation of the ANSI/ISO standard Structured Query Language (SQL). SQL Server 2005, the latest version, provides a single management console for anywhere administration, and an extensible management infrastructure that can be easily programmed using SQL Management Objects.

The following are five great Free Training web resources for learning how to use and administer Microsoft SQL Server 2005.

SQL Server 2005 Samples and Sample Databases:
Here are over 100 code samples for SQL Server 2005, along with three sample databases. While targeted at beginners, even expert programmers will find these useful. The samples download provides over 100 samples for SQL Server 2005, demonstrating the following components:

Database Engine, including administration, data access, Full-Text Search, Common Language Runtime (CLR) integration, Server Management Objects (SMO), Service Broker, and XML
Analysis Services
Integration Services
Notification Services
Reporting Services
Replication

Five Free SQL Server 2005 Video Tutorials
LearnSqlServer.com has made available five free video tutorials on SQL Server 2005. They make available several free SQL Server training videos at any given time for different skill levels ("100" for beginners, "500" for guru-level), and each month rotate these so you can see more of their training for free.

SQL Server 2005 SP1 CTP Available for Download
SQL Server Express users will gain Reporting Services and FullText Search with the first service pack for SQL Server 2005. This article gives a detailed, illustrated description of the first Community Technical Preview of SQL Server 2005 SP1, which updates all editions and online books.

SQL Server 2005 for the Database Developer
This technical article explains and describes many of the new features in SQL Server 2005. It covers topics such as Choosing between Transact-SQL and managed code, Web services, ADO.NET and ADO.NET notification support.

SQL Server Chapters and Articles
Learn how to take full advantage of SQL Server 2005's key innovations with these free book chapters and articles from awprofessional.com.

	Replicating Code Modules with SQL Server 2005 Sep 15, 2006
	Monitoring and Troubleshooting Replication Using SQL Server 2005 Sep 1, 2006
	Maintaining Transactional Replication with SQL Server 2005 Aug 18, 2006
	Setting Up Transactional Replication with SQL Server 2005 Aug 11, 2006
	Notification Services and the Service Broker in SQL Server 2005 Jun 23, 2006
	In-Process Data Access in SQL Server 2005 Jun 16, 2006
	Enterprise Data Management in SQL Server 2005 Apr 7, 2006
	Loading Images into SQL Server with C# Jul 8, 2005
	Effective Database Design: Choosing The Right Process Mar 4, 2005
	SQL Server 2005: Two Little Known Features That Matter Big! Jan 28, 2005
	Installing and Configuring SQL Server Reporting Services Jan 21, 2005
	Microsoft SQL Server 2000 Reporting Services Jan 7, 2005
	SQL Server 2005's Snapshot Isolation Dec 23, 2004
	T-SQL Enhancements in SQL Server 2005 Jul 30, 2004
	Maintaining Transactional Replication Apr 30, 2004
	Monitoring and Troubleshooting Transactional Replication Apr 23, 2004
.	Setting Up Transactional Replication with SQL Server Mar 26, 2004
	Introduction to Database Replication Mar 5, 2004
	Using SQL Server's XML Support Jan 16, 2004
	Tuning MDX: Improving Performance with Caches Nov 22, 2002