Beginning SQL Server 2005 Express Database Applications with Visual Basic Express and Visual Web Developer Express From Novice to Professional

SQL Server 2005 Express is the database component of Microsoft's Express Suite of products. It is free of charge, inherits many (non-enterprise) features from SQL Server 2005, and comes complete with development and administration tools. As such, it is an ideal database for developers and administrators to use in prototype/evaluation projects. It is also a powerful development platform for database applications on nonprofit websites, e-commerce sites, and in small offices and departments.

Author Rick Dobson provides all of the installation, configuration, administration, and development techniques that you need to build applications quickly. He focuses on techniques that are easy to learn and transparent in their real-world translations. Topics include the SSMS-based query tool and T-SQL programming, and Visual Basic Express and Visual Web Developer, both with SSE, to build Windows Forms applications and to develop ASP.NET web applications.

Working with SQL Server Express.- Getting Started with SQL Server Express.- Graphical and Command-Line Query Tools.- Exploring, Creating, and Recovering Databases.- Data Types, Tables, and Constraints.- Creating Queries from a Single Database Object.- Querying Multiple Database Objects and Manipulating Results Sets.- Leveraging Database Objects That Encapsulate T-SQL.- Managing SQL Server Express Security.- Working with Visual Basic Express and Visual Web Developer Express.- to Visual Basic Express and Windows Forms.- to Visual Web Developer Express, Web pages, and Web Forms.- Programming ADO.NET.- Programming DataAdapter and DataSet Objects.- Using Visual Database and Form Design Tool.

Rick Dobson has authored six books on database development with Visual Basic .NET, SQL Server, and Microsoft Access. In the past few years, he authored three DVDs on Visual Basic .NET, ADO.NET, and T-SQL. In addition, Dobson has written countless articles for computer periodicals, including SQL Server Magazine, Visual Studio .NET Developer, Visual Basic Developer, SQL Server Professional, SQL Server Solutions, Inside Microsoft Visual Basic, and Smart Access. Dobson is also the webmaster for several web sites. His most popular site, ProgrammingMSAccess.com, focuses on the needs of VB .NET and SQL Server developers as well as Access developers. This site gets over one million page views annually, and thousands of site visitors register to receive a newsletter summarizing new developments and opportunities on the site. Dobson also founded the Database Developers Group, an international association of Microsoft database developers.