20140220_Session

Relational Database Design with MySQL

February 20th 2014

• Google On-Air Event Page link: https://plus.google.com/u/0/events/c1kp4si27p8p2ect899hjf901kc?authkey=CN61wJTfh5j6EQ
• Youtube Video Link: N/A

This is of course just suggestion in attempt to support the cause and resulting higher education. So if I'm way off beat with this, just let me know n' I'll try n' harmonize better ^_^ ~ Josh

Participants

Speaker:

• David Stockton

Talking Heads:

• Bud Manz
• David Maybury
• Kerry McCullough
• Mansoor Bahramand
• Roberto Quezada
• Dann Stockton
• Josh Houghtelin

Live Audience: *

OVERVIEW

Topic: Relational Database Design

• Mysql is assumed to be the focus Database Server
• The focus project is kidsquest

Core Principles

• MyISAM vs INNODB
• Tables vs Views
• Table & Field naming
• Keep it small & fast...
  • Don't store unnecessary crud. Put log data in log files.

Relationships

• One to One
• One to Many
• Many to One
• Many to Many

Tools

• MySQL Workbench
• PHPMyAdmin

Change Management

• Install/Deploy Packages
• Upgrade/Deploy Packages

External Links

• Mysql Manual: Optimizing Database Structure
• MySQL Workbench Tutorial
• MySQL Workbench Database Design. Development. Administration. Migration.