MS SQL Tutorial for Beginners

Save

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).

Related Searches

  • Photo Credit the programmer and a computer image by Andrey Andreev from Fotolia.com
Promoted By Zergnet

Comments

Resources

You May Also Like

  • SQL Scripting Tutorial

    SQL (Structured Query Language) is a computer programming language used to manage data in relational database management systems. It was originally based...

Related Searches

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!