Beginning SQL Server 2000 for Visual Basic Developers

Thearon Willis is a senior consultant with 19 years of IT experience. He is a consultant for an international insurance company that provides web programming services. His web development tools of choice are ASP, dynamic HTML, Visual Basic, and SQL Server.

Introduction to SQL Server 2000; Installing the Personal Edition of SQL Server 2000; Designing and Creating the Development Database; SQL Server Security; SQL Server Query Analyzer; Database Connections; Introduction to Stored Procedures; Stored Procedures versus SQL Statements; Selecting Data; Inserting Data; Updating Data; Deleting Data; Working with Text Data; Installing Internet Information Server (IIS); SQL Server and XML; XML Web Reports; Case Study Part 1: Building an English Query Application; Case Study Part 2: Deploying an English Query Application; Appendix A: SQL Server and VB Data Types; Appendix B: ADO 2.6 Object Model; Appendix C: SQL Server Functions; Appendix D: Building the Hardware Tracking Framework; Appendix E: Creating the Hardware Tracking Business Server Component; Appendix F: References.