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
- Databases
- Tables
- Statements
- Clauses
- Where
- Order By
- Limit
- Functions
- Group By
- Relationships
- Indexes
- Joins
- Subqueries
- Temporary Tables
- Case Statements