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.
Table of Contents: 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.
