This course builds on previous coursework and/or experience to design and implement database backends and frontends. Solutions include RDBMS and no-SQL designs, and both desktop and web-based front-ends. Previous database and coding experience is required.
Prerequisite: Applied BAS degree students only.
- Design and implement both SQL and non-SQL databases.
- Transform data between different text-based database formats.
- Write SQL and non-SQL queries that filter, sort, and summarize table data.
- Create reports, data-entry forms, and form-based navigation using standalone programs.
- Create web-based reports, data-entry forms, and form-based navigation via client/server coding.
- Understand the process for creating interactive maps built from geo-spatial databases.