DATABASE
Basics Concept
What is RDBMS ?
Table
Field
Record
Column
Row
Schema
SQL Constraints
NOT NULL
Default
UNIQUE
PRIMARY
FOREIGN
CHECK
INDEX
Normalization
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
Data Integrity
Entity Integrity
Domain Integrity
Referential integrity
User-Defined Integrity
Data Type
Numeric
Date And Time
Character Strings
Binary
Misc
Operators
Aritmathics
Comparisons
Logical
Advanced
Function
View
Trigger
Index
More About Databases
Relational Database
No SQL Database
Advanced Topics
Normalizations
Sharding Strategies
ORMs
ACID
Transactions
Data Replications
N+1 Problems
Indexing
Theorem
Overview MYSQL
Syntax
SELECT
INSERT
UPDATE
DELETE
DROP
CREATE
SHOW
HAVING
LIKE
DISTINCT
WHERE
AND/OR
IN
ORDER BY
GROUP BY
DESC
TRUNCATE
ALTER
USE
COMMIT
ROLEBACK