Well, with MS SQL, you are able to have a single PC act as both Server and Client.
However, if you want to practice setting it up over a network, here is what you do.
1. Establish your network, ensure both computers are named and can 'see' each other.
2. Install SQL Server to the Server machine.
3. Once done, you will see the Instance of SQL server running on the Server machine. Look for the icon in the system tray.
4. Install your client tools on the client machine. Namely MS Enteprise Manager and Query Analyzer.
5. Once installed, you may see an instance of SQL server on th client machine, you can ignore this.
6. Establish connection to the SQL Server on the Server machine. To do this open Enteprise Manager and go to Action > New SQL Server Group
7. Provide a name (Anything will do)
8. Once the group is established, Add the SQL server registration. To do this highlight the group, right click and select New SQL Server registration.
9. You should be able to see the server SQL instance listed in the drop down. If not, type the Server name and Enterpise Manager will locate it.
10. Log onto the server using either network credentials or any other log in details you have set for the database. (configure from the server)
That's about it (in basic form, it can get much more advanced). Once done you can create as many databases as you want. Run scripts, queries and build stored procedures to your hearts content.
Good luck!
