Synopses & Reviews
SQL Server 2005 Express (SSE) 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 its own dedicated development and administration tools. As such, not only is it an ideal database for developers and administrators to use in prototype/evaluation projects, it is also a powerful development platform in its own right for low-budget database applications for non-profit Web Sites, as well as small office/departmental solutions and even eCommerce sites.
This book provides all of the installation, configuration, administration and development techniques that you need to build these types of application quickly and effectively. It focuses on solution techniques that are easy to learn, fast to implement, and transparent in the ways they address real-world problems. It covers: SQL Server Express tools and techniques, including use of Express Manager, and T-SQL programming; Using Visual Basic Express with SSE to build Windows Forms applications; Using Visual Web Developer with SSE for rapid but effective development of ASP.NET Web applications.
The book includes two full example case studies showing how to build a paypal-based eCommerce site and a Church administration application.
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.
Table of Contents
Working with SQL Server Express: Intro to SQL Server Express; SQL Server Express Management Tools; Building a Database; Tables; Queries and Views; User-defined Functions, Stored Procedures, and Triggers; Security.- Building Applications with SQL Server Express: Intro to VB Express and Windows Forms; Intro to Visual Web Developer Express; Visual Web Developer Application Issues; Intro to ADO.NET 2.0; Drill down on Data in Forms.- Bring it altogether: Sample Applications; PayPal eCommerce site; Church Administration/collections Application.