Create a Simple Database for Students and Courses in Easy Steps
Home > database design
create a simple database
in 3 lessons
This step-by-step guide is an overview of the stages to design, create, populate and then query a student database.
The task is to create a database that hold the records of students and the courses they are registered on.
Create a Simple Database
Includes data, code & instructions
3 Lessons
video help
Additional Course Material
Database Design
- Database Relationships (lesson 1)
- Design Considerations (lesson 3)
- Database SQL
- Student Database Example (lesson 2)
- SQL Querying Multiple Tables (lesson 3)
Lesson 1 :
how to design a database
Database design starts with an ER diagram. There are two parts to this lesson:
Lesson 2 :
create the database
Create the database using SQLite. There are two parts to this lesson:
Lesson 3 :
relate tables
Students and courses are related using a junction table called registration. There are three parts to this lesson:
Deeper dive - included in this course
Database Design
database relationships
lesson 1
relational databases use keys and relationships to relate tables together when needed.
SQL
access the database using SQL
lesson 2
use SQL select statement to see our data
