Module 7

Physical Design

Choose data types, indexes, constraints and storage for MySQL.

Intermediate 420 min 0 of 15 lessons published

Lessons

  1. 1
    The Goals of Physical Design Intermediate Coming soon
  2. 2
    Choosing the DBMS Intermediate Coming soon
  3. 3
    SQL Data Types Intermediate Coming soon
  4. 4
    Creating Tables Intermediate Coming soon
  5. 5
    PRIMARY KEY, FOREIGN KEY, UNIQUE and CHECK Intermediate Coming soon
  6. 6
    Handling NULL Values Intermediate Coming soon
  7. 7
    Primary and Secondary Indexes Intermediate Coming soon
  8. 8
    Composite Indexes Intermediate Coming soon
  9. 9
    Physical Data Organisation Intermediate Coming soon
  10. 10
    Query Optimisation Intermediate Coming soon
  11. 11
    Introducing EXPLAIN Intermediate Coming soon
  12. 12
    Transactions Intermediate Coming soon
  13. 13
    Users and Privileges Intermediate Coming soon
  14. 14
    Backup and Restore Intermediate Coming soon
  15. 15
    Building a Complete Database Intermediate Coming soon