Database Exercises

Goals

By the end of this module, you should be able to:

• Create and manage databases and database users
• Define database tables
• Perform CRUD operations on individual database tables
• Write queries that output information from multiple tables

Understand:

• What a database is
• What a database management system is
• How and when to write a JOIN clause
• How and when to use a sub-query

Contents

• Databases
• Tables
• Statements
• Clauses
  • Where
  • Order By
  • Limit
• Functions
• Group By
• Relationships
  • Indexes
  • Joins
  • Subqueries
• Temporary Tables
• Case Statements