Beginning SQL Server 2000 for Visual Basic Developers - MINT
Thearon Willis

Book Information



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 Microsoft Access can provide. SQL Server 2000 is tightly integrated with Windows 2000, offering more support for XML and much improved Online Analytical Processing (OLAP) services.

This book is for VB developers who want to integrate SQL Server 2000 into their applications. It covers everything you need to know to work with SQL Server 2000 and provide users of your Visual Basic and web-based applications with controlled access to your data. You'll start with an introduction to designing and creating a database and then move on to create increasingly complex T-SQL stored procedures. Throughout, you'll learn how to incorporate data access (including ADO) into your Visual Basic applications, manage security, and make data available across the Web.

Chapter 1--Introduction to SQL Server 2000
Chapter 2--Installing the Personal Edition of SQL Server 2000
Chapter 3--Designing and Creating the Development Database
Chapter 4--SQL Server Security
Chapter 5--SQL Server Query Analyzer
Chapter 6--Database Connections
Chapter 7--Introduction to Stored Procedures
Chapter 8--Stored Procedures versus SQL Statements
Chapter 9--Selecting Data
Chapter 10--Inserting Data
Chapter 11--Updating Data
Chapter 12--Deleting Data
Chapter 13--Working with Text Data
Chapter 14--Installing Internet Information Server (IIS)
Chapter 15--SQL Server and XML
Chapter 16--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

Contact details

• Email: Click here to reply to this ad

Anti spam: Do NOT contact me offering services or anything of a commercial nature.