SQL Server/Introduction
Introduction SQL Query SQL Stored Procedures SQL Triggers SQL Joins
SQL Views   Indexes BCP (Bulk Copy Program) Table Commands SQL Operators

Please note that the information on this page is related to an older version of Microsoft SQL Server.

Click on SQL Server Tutorials for new training content and material. In addition we have FREE SQL Tutorial videos here, so feel free to download the demos. Our partners also manage two blogs on the following SQL Server Versions:

-SQL Server 2008 Blog
-SQL Azure Blog

Please send any comments or suggestion to 
info@sqlserver2008tutorial.com

SQL Server is the client/server database from Microsoft. It can be scaled for a mid to large scale database management system. You can install SQL Server on Window NT/2000. It comes in different editions but we will discuss the enterprise edition here. Before we get into the details of the product, I want to show a few pictures from the actual graphic user interface for SQL Server.


When to start SQL Server Enterprise Manager, you will get the following window




Here we can see couple of SQL Servers that are on line, one of them is RDAC, the database for radiology archive database center. It has patient data and also research data at the Barrow Neurological Institute. You will notice various items under ACOM like database devices, logins etc. These topics are beyond the scope of this web site and will not be discussed here. I will talk about things like tables, stored procedures, views, triggers and other applicable stuff.


CREATE A NEW TABLE:

The are two ways you can create a table, using TRANSACT SQL statements or using the GUI in SQL Server. We will use GUI to create a new table. Select the database you want to create the table in, click on the plus sign right next to it. Click on Objects and then click on Tables. Just double click on the icon and new window will pop up. You can start entering the field information like name, data type and other information. Once you are finished you can click on the Save button. This is what a table looks like in SQL Server





If you want to set identity properties, primary or foreign keys for relationships, you can click on the Advanced Features tab right next to the save button. One of the ways you can monitor activity on your SQL Server is to use Current Activity under the Server menu. This will show you all the users that are connected to the server and all the databases they are currently using. Here is what the GUI look like