This course covers the following topics Data models: relational, entity-relationship. Relational query languages: relational algebra and SQL. Relational database design. Application interfaces and embedded SQL. Storage and indexing.
- Apply database design techniques and tools to create a database schema and database instance for an application.
- Apply an application design method and development tools to create a web application to support users in querying and manipulating the database for an application.
- Compose queries on a database in both SQL and the relational algebra.
- Assess the quality of database schemas and queries.
- Apply methods to improve the performance and security of a database application.