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

✍ Scribed by Rick Dobson (auth.)

• Publisher: Apress
• Year: 2006
• Tongue: English
• Leaves: 604
• Edition: 1
• Category: Library

✦ Synopsis

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

Front Matter....Pages i-xxi
Front Matter....Pages 1-1
Getting Started with SQL Server Express....Pages 3-31
Graphical and Command-Line Query Tools....Pages 33-71
Exploring, Creating, and Recovering Databases....Pages 73-106
Data Types, Tables, and Constraints....Pages 107-154
Creating Queries from a Single Database Object....Pages 155-189
Querying Multiple Database Objects and Manipulating Results Sets....Pages 191-245
Leveraging Database Objects That Encapsulate T-SQL....Pages 247-306
Managing SQL Server Express Security....Pages 307-368
Front Matter....Pages 369-369
Introduction to Visual Basic Express and Windows Forms....Pages 371-408
Introduction to Visual Web Developer Express, Web pages, and Web Forms....Pages 409-443
Programming ADO.NET....Pages 445-483
Programming DataAdapter and DataSet Objects....Pages 485-514
Using Visual Database and Form Design Tool....Pages 515-574
Back Matter....Pages 575-596

✦ Subjects

Programming Techniques; Programming Languages, Compilers, Interpreters