Databases

Contents

• Module Summary
• Learning Objectives
• Module Projects
• Weekly Details:
  • Week 1: assignments, lesson plan
  • Week 2: assignments, lesson plan
• Study Materials:
  • Isolate - examples and exercises
  • Integrate - projects to study
  • Class Recordings
  • Study Links (external)
• Curriculum (external)
• HYF Home (external)

---

Module Summary

TOP

---

Learning Objectives

Programming Skills

• Learn what relational database management systems (RDBMS) are
• Learn about relational models, tables, relations, columns, rows and keys
• Learn how to write structured query language (SQL)
• Familiarize some theoretical concepts: information systems, databases, RDMBs, relational models, tables, records, attributes, fields and keys
• Learn how to navigate a (SQLite) database
• Learn how to write basic SQL queries using following statements: SELECT, ORDER BY, SELECT DISTINCT, WHERE, LIMIT, BETWEEN, LIKE

Tooling

• SQLite - a SQL database engine
• node-sqlite3

TOP

---

Module Projects

Projects in this module will use the same folder structure & boilerplate code you learned in the previous web-apps module