70-431 Tutorials & Websites - Proprofs Free Webschool

Teach Yourself SQL in 21 Days

http://www8.silversand.net/techdoc/teachsql/index.htm

A free electronic version of the "Teach Yourself SQL Server in 21 Days" book. An excellent read!

Authored by: cbrzana Category: Microsoft Certification Tags: sql server t-sql microsoft 70-431 tutorial relational database

T-SQL User Guide

http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug

A very comprehensive guide to Transact-SQL (T-SQL), the query language for SQL Server. You can also download this tutorial as a 700+ page PDF.

Authored by: cbrzana Category: Microsoft Certification Tags: t-sql sql sql server 2005 query microsoft relational database rdms 70-431

SQLZoo.net - Excellent SQL Tutorials

http://sqlzoo.net/

Awesome tutorials on T-SQL commands -- allows you to enter a query and view the results. Nice hands on usage allows you to view data without the risk of ruining anything!

Authored by: cbrzana Category: Microsoft Certification Tags: sql server t-sql microsoft relational database rdms query 70-431

SQL Server Books Online

http://msdn2.microsoft.com/en-us/library/ms130214.aspx

A free resource from Microsoft -- a definite must have resource when learning SQL Server 2005.

Authored by: cbrzana Category: Microsoft Certification Tags: sql server microsoft windows 70-431 relational database t-sql

T-SQL Tips: Tips to get you writing T-SQL code

view online

A document I created that shows 3 easy ways to make learning T-SQL much less painful!

Authored by: cbrzana Category: Microsoft Certification Tags: t-sql sql database microsoft mcdba 70-431

MSSQLServer.com - Free Tutorials

http://www.mssqlserver.com/tsql/

A very nice collection of free powerpoints that discuss relational databases and T-SQL. I highly recommend this if you are interested in SQL Server!

Authored by: cbrzana Category: Microsoft Certification Tags: tutorials sql server rdms relational database microsoft 70-431 query t-sql

SQL Server 2005 Learning Resources

http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx

A link to Microsoft's SQL Server Express page...download SQL Server for free. Includes almost 9 hours of free video tutorials to help get you started with SQL Server.

Authored by: cbrzana Category: Microsoft Certification Tags: sql server microsoft query relational database 70-431 t-sql

SQL Tutorial

http://www.sql-tutorial.net/

A nice tutorial on the most common SQL commands. Recommend you know these before diving into SQL Server/T-SQL.

Authored by: cbrzana Category: Microsoft Certification Tags: sql t-sql 70-431 microsoft relational database rdms query sql server

MSDN SQL Server Developer Center

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_tsqlcon_6lyk.asp

MSDN - a great resource to view the correct syntax of various T-SQL commands, and a brief explanation of each. A definite must-have while learning SQL Server/T-SQL.

Authored by: cbrzana Category: Microsoft Certification Tags: sql server t-sql microsoft rdms relational database query 70-431

XML Tutorials

http://www.w3schools.com/xml/default.asp

Very nice site to learn fundamental XML concepts, many of which are required for the 70-431 exam.

Authored by: cbrzana Category: Microsoft Certification Tags: xml sql server 70-431 ciw