MS SQL Tutorial for Beginners

by Virginia Grant

Learning to use Microsoft SQL may seem daunting, so it is best to start small and follow the logical steps. The secret is to start with a clear concept of what you want your database to accomplish.

MS SQL Server 2008

As of 2010, the current version of the Microsoft SQL Server is the 2008 version, code named Denali. It is available as a free trial download (see Resources). If you do not have the Microsoft SQL Server installed, you can download the trial version by clicking on the "Download Trial Version" and following the screen prompts. Installing and registering the trial version permits access to Microsoft's free online user tutorials and study guides.

Opening a Database

With the SQL Server installed and open, select the "File" tab, select a table to open and click on the file. The table will open and you will have the opportunity to make changes, create queries and add data.

Closing and Saving Your Work

When you have made your changes, sorted or added your data, save the file by clicking on the "File" tab and selecting "Save." You can find a selection of SQL commands on the SQL.org site that will allow you to manipulate field size, query data, create and drop tables, and perform other SQL tasks (see Resources).

About the Author

Virginia Grant wrote her first cookbook "Wholly Crepe" in 2008 and has since added "Easy Roasts," "A Deep Beauty," "Breaking Up The Big Banks" (with T.J. Walker) and an ACC "Guide to Long Island Sound." She has been a business analyst, law librarian and paralegal, and real estate broker.

Photo Credits

  • photo_camera the programmer and a computer image by Andrey Andreev from Fotolia.com