SQL Learning Notes - 1

Posted on | In
Learning SQL.

SQL Learning Notes - 1

Good data storage allows

  • easy retrieval
  • easy updating
  • accessibility for multiple people at the same time
  • data consistency
  • space efficiency
  • speed
  • security

set theory

  • Tables = smallest logical subsets of data Each
  • Each column represents a unique category of information
  • each row must be unique
  • Order of columns or rows doesn’t matter