Software Programming & Development
Mysql Topics Covered |
|
| Database Design with My SQL |
|
| Why use a Relational Database? | |
| Blasted Anomalies | |
| ~ ~ ~ |
The update anomaly The delete anomaly The insert anomaly |
| Normalization | |
| ~ ~ ~ |
First normal form Second normal form Third normal form |
| Types of Relationships | |
| ~ ~ ~ |
The one-to-many relationship The one-to-one relationship The many-to-many relationship |
| Advanced Database Concepts | |
| ~ ~ ~ |
Referential integrity Transactions Stored procedures |
| The Structured query Language for Creating and Altering Tables | |
| Essential Definitions | |
| ~ ~ |
Null Values Indexes |
| The create database Statement | |
| The use database Statement | |
| The create table Statement | |
| Column Types | |
| ~ ~ ~ |
String column types Numeric column types Date and time types |
| Creating Indexes | |
| Table Types | |
| ~ ~ ~ |
MyISAM InnoDB Tables Berkeley DB Heap |
| The alter table Statement | |
| ~ ~ ~ ~ ~ ~ |
Changing a table name Adding columns Dropping columns Adding indexes Dropping indexes Changing column definitions |
| Using the show Command | |
| ~ ~ ~ ~ ~ ~ |
show databases show tables show columns show index show table status show create table |
| GUI Tools for Manipulating MySQL Tables and Data | |
| ~ | Using phpMyAdmin |
| The Structured Query Language for Inserting, Editing, and Selecting Data | |
| ~ ~ ~ ~ |
The insert Statement The update Statement The delete Statement The replace Statement |
| The Basic select Statement | |
| ~ ~ ~ ~ |
The Where clause order by limit group by and aggregate functions |
| Joining Tables | |
| ~ ~ ~ ~ ~ ~ |
The two-table join (equi-join) The multi-table join The outer join The self join Unions Correlated subqueries |
