Working with ADO.NET - Universal Database Access for mono

Contents

• 1. What is a Database
• 2. My choice: MySQL
• 3. Installation & First Steps with MySQL
  • 3.1 Installation on Windows
  • 3.2 Installation on Linux
• 4. Database Design
  • 4.1 Database Theory
    • 4.2.1 Normal Forms
    • 4.2.2 Relations
  • 4.3 Primary Key & Foreign Key
  • 4.4 Data Types
  • 4.5 Indizes
• 5. Learning SQL
  • 5.1 Simple SELECTs
  • 5.2 SELECT Data from relational Databases
  • 5.3 Editing Data
  • 5.3.1 INSERT
  • 5.3.2 UPDATE
  • 5.3.3 DELETE
  • 5.4 Advanced SQL
• 5. Monos Database layer
  • 5.1 Connecting to the Database
  • 5.2 Explanaition of various classes
• 6. Programming a book database
• 7. SQL-Reference