DokuWiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
  - Introduction
    - [[Welcome]]
    - [[What you need to know]]
    - [[Understanding Databases]]
    - [[What are databases?]]
    - [[Exploring databases and database management systems]]
  - Database Fundamentals
    - [[The features of a relational database]]
    - [[Exploring unique values and primary keys]]
    - [[Defining table relationships]]
    - [[Describing many-to-many relationships]]
    - [[Transactions and the ACID test]]
    - [[Introduction to Structured Query Language (SQL)]]
  - Database Modeling: Tables
    - [[Introduction to database modeling]]
    - [[Planning your database]]
    - [[Identifying columns and selecting data types]]
    - [[Choosing primary keys]]
    - [[Using composite keys]]
  - Database Modeling: Relationships
    - [[Creating relationships]]
    - [[Defining one-to-many relationships]]
    - [[Exploring one-to-one relationships]]
    - [[Exploring many-to-many relationships]]
    - [[Understanding relationship rules and referential integrity]]
  - Database Modeling: Optimization
    - [[Understanding normalization]]
    - [[First normal form]]
    - [[Second normal form]]
    - [[Third normal form]]
    - [[Database denormalization]]
  - Database Modeling: Querying
    - [[Creating SQL queries]]
    - [[Structuring the WHERE clause]]
    - [[Sorting query results]]
    - [[Using aggregate functions]]
    - [[Joining tables]]
    - [[Inserting, updating, and deleting]]
    - [[The data definition language]]
  - Database Modeling: Indexing and Optimization
    - [[Understanding indexes]]
    - [[Understanding write conflicts]]
    - [[Understanding stored procedures and injection attacks]]
  - Database Options
    - [[Desktop databases]]
    - [[Relational database management systems]]
    - [[Object-based and XML-based databases]]
    - [[NoSQL databases]]
  - Conclusion
    - [[Final thoughts]]