Microsoft Visual Basic Database Design

This is an electronic book (ebook) that teaches the fundamental techniques of designing and developing databases using the Microsoft Visual Basic programming environment. The ebook starts with file-based applications using collection classes and serialization. It follows with XML development. To formally introduce databases, there are a few lessons on the concept of a data set. The rest of the ebook focuses on ADO.NET with database development using Microsoft SQL Server.

Purchase the ebook.

Part I: Databases Fundamentals		Part V: Microsoft SQL Server and ADO.NET
1. Introduction to Databases		22. Introduction to Microsoft SQL Server
2. Serialization		23. Introduction to ADO.NET
3. File-Based Databases		Part VI: SQL and Transact-SQL
Part II: Collections		24. Introduction to SQL
4. Introduction to Collections		25. Operations on SQL Variables
5. Built-In Collection Classes		26. SQL Expressions
6. Dictionary-Based Collections		27. Introduction to SQL Functions
Part III: XML		28. A Review of Built-In SQL Functions
7. Introduction to XML		Part VII: Database Development With ADO.NET
8. Introduction to XML Elements		29. The Tables of a Database
9. Operations on XML Elements		30. The Records of a Database
10. Maintenance of XML Elements		31. Assistance With Data Entry II
11. The Attributes of XML Elements		32. Introduction ADO.NET Visual Tools
12. Types of Nodes of an XML Document		33. Introduction to Data Selection
13. XML Reading and Writing		34. The Data Adapter
Part IV: Data Sets		35. Sorting and Filtering Records
14. The Data Grid View		36. Operations on Data Selection
15. Introduction to Data Sets and Tables		37. Relationships and Data Integrity
16. The Columns of a Table		38. Data Binding
17. The Records of a Table		39. Data Joins
18. Assistance With Data Entry I		40. Views
19. Data Relationships		41. Stored Procedures
20. Records Maintenance		42. Techniques of Commanding a Database
21. The Data View
		Screenshots