HOUR 2. SQL Server Basics

You should know some basics when getting started with SQL Server 2005 Express. Knowledge of these basics will help you to make decisions about whether the product is right for you, and will help you with the installation process. In this hour you’ll learn:

The versions of SQL Server 2005 that are available

How to install SQL Server Express

How to get started with the SQL Server Management Studio Express

Versions of SQL Server 2005 Available

Microsoft recognizes that there is a plethora of database users with disparate needs. They therefore have released the following six versions of SQL Server 2005:

SQL Server 2005 Express Edition

SQL Server 2005 Workgroup Edition

SQL Server 2005 Developer Edition

Get Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.