Academic Database Overview





The interactive transcript could not be loaded.


Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Aug 31, 2018

Academic Database Overview

Level: Intermediate/Advanced

Series: Advanced SQL Queries

Length of video: 33 minutes (use chapters noted below)

Prerequisites: Familiarity with basic SQL queries.

Purpose of lecture:
This lecture is part of a series of lectures that serve as an introduction to the relational query language of SQL. The current lecture introduces the academic database, a set of tables used to demonstrate multi-table operations such as join and subquery.

It is important for anyone who plans to view the Advanced SQL Queries videos to first view this video. Without the benefit of this video, the semantics of the database might be unclear.

The tables described in this video can be created by running the script named academic.sql. This script can be downloaded from our website: www.timhartley.com

From the homepage, select the menu item named "The Insightful Professor" and a list of files available for download will be displayed.


Integrity constraints 1:17
Data definition statements 2:52
Sample data - table content 15:08
Design summary 20:13
Many-to-Many relationship 21:03
Cyclic relationship 24:16
Summary of relationships 27:20


When autoplay is enabled, a suggested video will automatically play next.

Up next

to add this to Watch Later

Add to

Loading playlists...