Module 7
Physical Design
Choose data types, indexes, constraints and storage for MySQL.
Intermediate 420 min 0 of 15 lessons published
Lessons
-
1
The Goals of Physical Design Intermediate Coming soon
-
2
Choosing the DBMS Intermediate Coming soon
-
3
SQL Data Types Intermediate Coming soon
-
4
Creating Tables Intermediate Coming soon
-
5
PRIMARY KEY, FOREIGN KEY, UNIQUE and CHECK Intermediate Coming soon
-
6
Handling NULL Values Intermediate Coming soon
-
7
Primary and Secondary Indexes Intermediate Coming soon
-
8
Composite Indexes Intermediate Coming soon
-
9
Physical Data Organisation Intermediate Coming soon
-
10
Query Optimisation Intermediate Coming soon
-
11
Introducing EXPLAIN Intermediate Coming soon
-
12
Transactions Intermediate Coming soon
-
13
Users and Privileges Intermediate Coming soon
-
14
Backup and Restore Intermediate Coming soon
-
15
Building a Complete Database Intermediate Coming soon