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