Getting Started - SQL

Contents

Installing Microsoft SQL Server 2005
JAWS Scripts
Tutorials
Notes

Installing Microsoft SQL Server 2005 SQL Server

To install SQL Server 2005 Express Edition:

1. Go to the MS Visual Studio Express 2005 Home Page.
2. Select the "Download" button
3. The preparatory steps are noted there..
4. Below the SQl Server image, click "download". After being selected, the download will begin.

Top

JAWS Scripts

Microsoft VS 2005 JAWS Scripts

http://grabbag.alacorncomputer.com contains the Jaws Basic Setup for VS.net IDE's download.

Tutorials

SQLCourse.com is a unique introductory SQL tutorial not only provides easy-to-understand SQL instructions, but it allows you to practice what you learn using the on-line SQL interpreter. You will receive immediate results after submitting your SQL commands. You will be able to create your own unique tables as well as perform selects, inserts, updates, deletes, and drops on your tables. This SQL tutorial currently supports a subset of ANSI SQL.

http://sqlcourse2.com/intro2.html is an Intermediate/Advanced SQL Tutorial will cover the SELECT statement in great detail. The SELECT statement is the core of SQL, and it is likely that the vast majority of your SQL commands will be SELECT statements. Due to the enormous amount of options available for the SELECT statement, this entire tutorial has been dedicated to it.

Top

Notes

For the introduction to Relational Databases (RDBMS) Transact-SQL will be used. Sometimes abbreviated T-SQL, Transact-SQL is Microsoft's and Sybase's proprietary extension to the SQL language. Microsoft's implementation ships in the Microsoft SQL Server product. Sybase uses the language in its Adaptive Server Enterprise, the successor to Sybase SQL Server.

Top