|
The database design tutorial takes you through database design from problem conception to creating your tables. No knowledge of databases is assumed. Gain the necessary insight with plenty of examples to begin putting together your database whether personal or commercial.
- Get a firm grasp of the art of Entity Relationship Diagrams with tutorials you can study on your own time.
- See how you can translate your diagrams into real implementable tables.
- Understand the methods of eliminating redundancy and inconsistencies
- Learn Structured Query Language(SQL) to implement your design in any product of your liking (oracle, mysql etc)
Take the plunge, start designing!!!
| CLICK TO SUBSCRIBE |
|
|
|
Note: You will be billed automatically every month until you unsubscribe
|
|
|
| No. | Description | Links | | 1 | Introduces databases, why they are necessary and some advantages and disadvantages of using them
Database Design Tutorial Duration: 11 mins |   | | 2 | Introduction to Data Modeling and the basic three-level schema of a database
Database Design Tutorial Duration: 11 mins | Subscribe
| | 3 | Entity Relationship Diagrams part I introduces the concept of an entity, relationships and attributes of an entity
Database Design Tutorial Duration: 16 mins | Subscribe
| | 4 | Understanding Cardinality in Database Design.
Database Design Tutorial Duration: 16 mins | Subscribe
| | 5 | Understanding Participation in Database Design
Database Design Tutorial Duration: 5 mins | Subscribe
| | 6 | Understanding the use of Keys
(Primary, Foreign, Composite)
Database Design Tutorial Duration: 11 mins | Subscribe
| | 7 | Specialization/Generalization in Enhanced Entity Relationship Diagrams.
Identifying sub-entities of an entity and classifying a group of entities under a particular super-entity
Database Design Tutorial Duration: 12 mins | Subscribe
| | 8 | Understanding Null Values and why they should be avoided as much as possible
Database Design Tutorial Duration: 5 mins | Subscribe
| | 9 | Converting ERDs to Implementable tables.
(General Rules)
Database Design Tutorial Duration: 8 mins | Subscribe
| | 10 | Converting ERDs to Implementable tables
(Stable Translation Method)
Database Design Tutorial Duration: 15 mins | Subscribe
|
|
| Quotable Quote | There is no man so good, who, were he to submit all his thoughts and actions to the laws, would not deserve hanging ten times in his life.
-Michel de Montaigne, essayist (1533-1592)
|
|
