5. Databases and SQL

• 5.1. Overview
  • 5.1.1. What is a Database?
  • 5.1.2. Querying a Database
• 5.2. Select
  • 5.2.1. SELECT columns
• 5.3. Where
• 5.4. Order By
• 5.5. Limit
• 5.6. Readability
  • 5.6.1. Comments
• 5.7. Insert
  • 5.7.1. Inserting multiple records
• 5.8. Update
  • 5.8.1. Primary Key
• 5.9. Delete
• 5.10. Joins
• 5.11. More Joins
  • 5.11.1. Left Join
  • 5.11.2. Right Join
  • 5.11.3. Full Outer Join
• 5.12. Group By