Create a Simple Database for Students and Courses in Easy Steps
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.
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
