Unit2

Unit 2: Full-stack web apps

Module 2.1

Course Material

• 2.1 Design the Logical Model of Your Relational Database
  • OC course time: 4 hrs

Mini-Projects

• Included in OC course:
  • Mini-project 2.1: Design an ERD

Self-Graded Assignments

• 2 auto-graded quizzes

Module 2.2

Course Material

• Included in OC course:
  • 2.2 Implement a Relational Database with SQL
    • OC course time: 4 hrs
    • Demonstrations show the steps of building a database in SQL Server, but you can follow along using any SQL DBMS and we recommend using MySQL or PostgreSQL rather than SQL Server.
• Not included in OC course:
  • Read this comic strip to understand the danger of SQL injection

Mini-Projects

• Included in OC course:
  • Mini-project 2.2a: Get some practice building an employee database
• Not included in OC course
  • Mini-project 2.2b: Integrate MySQL or Postgres into an ExpressJS app
  • Mini-project 2.2c (Optional): Use Sequelize in your ExpressJS app

Self-Graded Assignments

• 1 auto-graded quiz

Module 2.3 (Optional)

Course Material

• Included in OC:
  • 2.3 Retrieving data with SQL
    • OC course time: 20 hrs

Mini-Projects

• Included in OC:
  • Mini-Project 2.3a: Practice Executing Simple SQL Queries
  • Mini-Project 2.3b: Advanced SQL Queries
• Not included in OC:
  • Odin Project - SQL Zoo (self-graded, not for turn-in)