Web Unit 4 Sprint 14 - Relational Databases

Course Overview

Welcome to Web Unit 4 Sprint 14. This course will teach you the fundamentals of relational databases, from basic concepts to advanced data modeling techniques.

Course Objectives

  • Understand relational database concepts and components
  • Master SQL querying and data manipulation
  • Design and implement database schemas
  • Work with multiple tables and relationships
  • Apply data normalization principles
  • Use Knex.js for database operations

Module 1: Database Basics

Learn the fundamentals of relational databases, SQL basics, and how to work with data using knex.js.

Module 1

Module 2: Schema Design

Master database schema design, migrations, and seeding with Knex.js.

Module 2

Module 3: Multi-Table Queries

Explore relationships between tables and learn advanced querying techniques.

Module 3

Module 4: Data Modeling

Understand data normalization and create complex table relationships.

Module 4

Course Resources

Knex.js Documentation SQLite Documentation PostgreSQL Documentation SQLite Studio Postman GitHub

Sprint Challenge

Apply your knowledge of relational databases in a comprehensive challenge.

Sprint Challenge