While the Programming Foundations: Databases course on LinkedIn Learning is intended as an overview of the ideas behind relational databases, and not a hands-on exploration of using a database, we’ve heard from many of our learners that they would like access to the database used in the course for practice.
This repository includes files you can use to practice. The files are:
- tables of data used to populate the Restaurant database (contents of the
csvsfolder) - two versions of the Restaurant database for various software tools (
restaurant.sqlandrestaurant_sqlite.db) - a listing of the commands that I used to work with the database (
queries.md)
You do not need to use these files to follow along with the course.
Chapter 5 in the Programming Foundations: Databases course is intended as a preview of what you can do with a relational database after learning SQL.
For an introduction to the SQL language, see the course Learning SQL Programming on LinkedIn Learning.
In the course, I demonstrated interacting with the database using HeidiSQL, connected to a MariaDB server. Because this can take some effort to set up, you may consider using DB Browser for SQLite on a local system instead. I’ve provided the database here in two formats:
restaurant.sqlcan be imported into tools like MySQL, SQL Server, and other compatible database management systems.restaurant_sqlite.dbcan be opened in DB Browser for SQLite.
For practice purposes, both options work in a similar way.
