Microsoft Visual C# Database Design

Microsoft Visual C# Database Development

Microsoft Visual C#

This series of lessons teach the fundamental techniques of designing and developing databases using the Microsoft Visual C# programming environment. The lessons start 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 lessons focus on ADO.NET with database development using Microsoft SQL Server.

1.    Introduction to Databases 21. Operations on SQL Variables
2.    Serialization 22. SQL Expressions
3.    File-Based Databases 23. Introduction to SQL Functions
4.    Introduction to Collections 24. A Review of Built-In SQL Functions
5.    Built-In Collection Classes 25. The Tables of a Database
6.    Dictionary-Based Collections 26. The Records of a Database
7.    Introduction to XML 27. Assistance With Data Entry II
8.    Introduction to XML Elements 28. Database Visual Support
9.    Operations on XML Elements 29. Introduction to Data Selection
10.  Maintenance of XML Elements 30. Details on Data Selection
11. Characteristics of XML Nodes 31. Operations on Data Selection
12. XML Reading and Writing 32. Relationships and Data Integrity
13. Introduction to Data Sets and Tables 33. Data Binding
14. The Columns of a Table 34. Data Joins
15. The Records of a Table 35. Views
16. Assistance With Data Entry I 36. Stored Procedures
17. Data Relationships 37. Techniques of Commanding a Database
18. Introduction to Microsoft SQL Server 38. Introduction to LINQ
19. Introduction to ADO.NET 39. The .NET Framework Support for the LINQ
20. Introduction to SQL

Copyright © 2008, Yevol