5. Databases and SQL

Syllabus Points Covered

Programming for the web

Designing web applications

• Model elements that form a web development system

  • interfacing with databases that are based on Structured Query Language (SQL) or non-SQL

• Observe and describe the back-end process used to manage a web request

  • databases

• Apply a web-based database and construct script that executes SQL

  • selecting fields

  • incorporating ‘group by’

  • common SQL queries

  • constraints using WHERE keyword

  • table joins

Chapter Contents

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