Home » Tutorials » Microsoft SQL Server

Microsoft SQL Server

Our Categories

Blog Stats

  • 32,852 hits

Calendar

May 2013
M T W T F S S
« Apr   Jun »
 12345
6789101112
13141516171819
20212223242526
2728293031  

Please visit SQLVERSITY.COM for more details.

Microsoft SQL Server is a relational database management system(RDBMS) developed by Microsoft. As we already know that, database stores the data and we can retrieve/modify the data in database. SQL Server is not case sensitive. SQL Server uses T – SQL(Transact Structured Query Language) which is the extension of SQL. If you are strong in SQL basics, you can easily learn T – SQL.

The following are the list of editions of SQL Server:

Enterprise – It contains all features of SQL Server.

Express – It is free edition of SQL Server. We can use this edition for practicing, testing etc…

Standard – It is used for small applications.

Web – Used for web applications.

Work Group – It is used for small to medium applications.

These are some popular editions of SQL Server and there are some more editions like Compact, Azure, Developer etc…

The following are the list of versions of SQL Server:

SQL Server versions

There are some more versions prior to these. But they are not that much popular than these.

Below is the sample User Interface(UI) of SQL Server Management Studio. Do not worry about the below screenshot.

I will explain each and everything in my coming tutorials. Be ready 🙂

Microsoft SQL Server

Note:

You can download Microsoft SQL Server Express edition from Microsoft website and install as per the instructions given.

Now we can start playing with SQL Server 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: