Database

• Database model
  • Resultsets
  • Naming conventions
  • Indexes
• Querying
  • Basic usage
  • Arguments
  • Giving full SQL statement
  • Without option
  • Fields selection
  • Using JOINs
  • UNION queries
  • Counting
  • Grouping
  • Order
  • Request pager
  • Criteria
• Updating
  • General
  • Inserting a row
  • Updating a row
  • Removing a row
  • Use prepared statements