This is a good deal from Microsoft if you want to download SQL Server 2008 with advanced services and that without any cost but only suitable for learning and building desktop and small server applications, and for redistribution by ISVs. If you are still confused if its full featured download, here is what Microsoft SQL Server 2008 Express with Advanced Services means:

• SQL Server database engine – create, store, update and retrieve your data
• SQL Server Management Studio Basic – visual database management tool for creating, editing and managing databases
• Full-text Search – powerful, high-speed engine for searching text-intensive data
• Reporting Services – integrated report creation and design environment to create reports

Today morning I was searching for it wishing I could download a free copy of Microsoft SQL Server Express so  I can use it for learning at home and just lucky to find it as MS has made it availble on 8/22/2008  ( I feel lucky on this ). This version should be good enough for you.

However I would recommend you to go through all the details which they had given you over there. You can download it from here