Starting off with SQL basics questions

[mikehende]

Hey guys, I am starting study SQL from here:

http://www.tizag.com/sqlTutorial/sqldatabases.php

I have installed SQL Server but stuck at :

SQL - Creating a Database

Creating a database inside of SQL Express has its advantages. After launching Microsoft's SQL Server Management Studio Express application, simply right-clicking on the Databases folder of the Object Explorer gives you the option to create a New Database. After selecting the New Database... option, name your database "MyDatabase" and press "OK".

First, si there supposed to be an icon for the server on my desktop? If so, none on my desktop. I looked in All Programs and am not seeing "Microsoft's SQL Server Management Studio Express"? Help please?

[Old Pedant]

Management Studio is usually a separate download and install.

Go back to the http://msdn.microsoft.com/express pages and see if you can't find where to download and install it from.

[guelphdad]

SQL Server is a different RDBMS from MySQL. Please post questions for it in the general database forum.

[mikehende]

Since my pc is 32 bit, I had downloaded the first one on the top which is the "SQL Server Express 2008 R2", is this correct?

[mikehende]

tried it from here

http://www.microsoft.com/download/en/details.aspx?id=7593

and tried to install 2 times but having a problem it seems the software will not restart the pc on it's own [see image attached] and when I do it manually nothing happens.

Also, before doing so I choose the first option [see arrow] to install, is this correct? [see 2nd image]

[mikehende]

I tried this one:

SQL Server 2008 R2 Express
32-bit Database and Management Tools


and looks like it works!