| Intro about DBMS & RDBMS |
Dr.EF.Code's Rule. |
DDL-Data Definition Language |
DML - Data Manipulation Language. |
| SQL - Structured Query Langauge |
Databases - Create , Drop |
Table |
Skeleton of Table |
| Queries |
Create,Alter,Insert,Update,Delete,Select. |
TRUNCATE TABLE Statement |
UNION Operator |
| INTERSECT |
Subqueries A query within a query |
Joins |
MySQL Aliases |
| MySQL Clauses |
DISTINCT Clause Retrieve unique records |
Filter results |
ORDER BY Clause Sort query results |
| GROUP BY |
HAVING Clause |
MySQL-Functions |
|
| Procedures |
Triggers |
Literals (Constants) |
|
| Variables |
Loops and Conditional Statements |
AUTO_INCREMENT (Sequences) |
Comments |
| PHP - Database Connectivity with MySQL. |
Reports . |