Thearon Willis

Although many web professionals will have incorporated a database into a web site before, they may not have much experience of designing them - this book will teach you all you need to know about designing a database for use with a web site or web application. From first principles to designing a successful web database, this book will show you how to get the most out of database design. From the Publisher Unlike other database design books in the market, this one focuses on design of databases for use on the Web. Web databases benefit from good general database design principles, but also have their own set of caveats, which must be considered for their design to be truly successful. This book covers both the general, and the web-specific database principles.

This is the only book that provides comprehensive coverage of SQL Server 2000 specifically from a Visual Basic programmer's point of view. SQL Server is now the first choice for the Visual Basic developer wanting a more powerful, reliable and sophisticated database than MS Access can provide. SQL 2000, is tightly integrated with Windows 2000, offering more support for XML and much improved OLAP (Online Analytical Processing) services. This book is for VB developers who want to integrate SQL Server 2000 into their applications. It covers everything needed to work with SQL Server 2000, including topics such as SQL Server 2000 tools, managing database security, building and deploying English query applications, and more.The Jet database engine, which has traditionally powered Access, is gradually being replaced by the Microsoft Database Engine (MSDE), a limited-client version of the SQL Server engine (but without the front-end tools such as Enterprise Manager). This means that VB developers traditionally used to using a single-file database now have to cope with the client-server architecture of SQL Server. This is a big conceptual leap, and many VB developers struggle to make it. This book is designed to help developers make that leap as easily as possible, and to show them how to use the full range of SQL Server's powerful tools within their VB applications.

This book explains, demonstrates, and applies techniques that lie at the intersection of the two great tools of the Information Age. One tool, the database, is relatively old. The other, the Internet, is quite new. With these two tools together, readers can create powerful Web pages. In this book, readers will learn how to incorporate databases into their ASP applications using ADO, which provides a set of objects through which one can connect to, read from, and write to databases. From installing the necessary software and a basic guide to SQL, to handling stored procedures, readers will get several real-world questions answered with code ready to cut and paste and a chance to practice at every step of the way.