Skip to content

Instantly share code, notes, and snippets.

@sairion
Last active December 24, 2015 09:29
Show Gist options
  • Select an option

  • Save sairion/6777791 to your computer and use it in GitHub Desktop.

Select an option

Save sairion/6777791 to your computer and use it in GitHub Desktop.
SQL Basics
/* SQL Basics by topics */
*Keys
-Foreign Key, Primary Key,
*Transation
-ACID (Atomicity, Consistency, Isolation, Durability) == "set of properties that guarantee that database transactions are processed reliably." (Wikipedia)
-Commit / Rollback after process
*Concurrency Control (Controlling Concurrent Transaction, interleaving excution of transaction)
-
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment