SQL
Joins
JOIN types INNER JOIN: returns rows when there is a match in both tables. LEFT JOIN: returns ...
Constraints
What are constraints? Constraints are used to define rules to allow or restrict what values can ...
Indexes
Index Types The primary key is always automatically indexed and unique. Indexes by default are s...
Wildcards
What are Wildcards? MySQL provides two wildcard characters for constructing patterns: percentage...
Console Commands
DESC table - List all columns of an table DESC mysql.user - Access all users of mysql SELEC...
Sharding
Database sharding is the process of storing a large database across multiple machines. A single m...