SQL Server Express is installed by default along with Visual Studio, which saves developers a lot of time in choosing an appropriate relational database platform.
It also exposes most of the concepts one will find in comparable products, and for using a Structured Query Language in general. This means that developers do not have to re-learn fundamental concepts when switching to other technologies such as Oracle and MySQL.
There is, however, one thing that is missing by default, and that is a administration option using a graphical tool that most DBA's are familiar with. This can lead to frustrating debugging sessions and more.
In this video, I will show you where to get the SQL Server 2008 Management Studio installer, and how to navigate a somewhat unintuitive installation process. From there, I will show you how to view and edit data contained in one of the tables.