So we want to build a simple ordering system. We are going to need to store the orders, the order items, the products they represent, the contact that placed the order, and the billing and shipping addresses. Let's get started!
If you haven't already, install the Microsoft SQL Server Express with Tools, or install Microsoft SQL Server Express and Microsoft SQL Server Management Studio Express (SSMS). If you don't have the .NET Framework 3.5 installed already, then you will need to install that before you will be able to install SSMS, as well as Windows PowerShell. We will use SSMS to design our database.
Open SSMS (Start | All Programs | Microsoft SQL Server (version) | SQL Server Management Studio Express).
When you open SSMS, you will be prompted for login credentials for the database. Generally, you can enter either the hostname\SQLEXPRESS or (local)\SQLEXPRESS.