FB

Sample Databases (ERD and SQL)

[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”3.22″][et_pb_row _builder_version=”4.0.6″][et_pb_column type=”4_4″ _builder_version=”4.0.6″][et_pb_code admin_label=”Script” _builder_version=”4.0.6″][/et_pb_code][et_pb_text admin_label=”Heading” _builder_version=”4.5.1″ hover_enabled=”0″]

Sample Databases (ERDs and SQL)

This page is a collection of all the sample databases available on Database Star. Each entry links to a post with more information, such as the ERD, table explanations, and SQL code to create and populate the database.

You can use the sample SQL database for practice with writing SQL, running SQL, and analysing the data.

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure=”2_5,3_5″ admin_label=”row” _builder_version=”4.0.6″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” link_option_url=”https://www.databasestar.com/sample-database-movies/”][et_pb_column type=”2_5″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_code admin_label=”Code” _builder_version=”4.0.6″ text_orientation=”center”][/et_pb_code][/et_pb_column][et_pb_column type=”3_5″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_text admin_label=”Movies” _builder_version=”4.0.6″]

Movies

A database containing movies, actors, crew, and the movies they have all been in.

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure=”2_5,3_5″ admin_label=”row” _builder_version=”4.0.6″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” link_option_url=”https://www.databasestar.com/sample-database-video-games/”][et_pb_column type=”2_5″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_code admin_label=”Code” _builder_version=”4.0.6″ text_orientation=”center”][/et_pb_code][/et_pb_column][et_pb_column type=”3_5″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_text admin_label=”Video Games” _builder_version=”4.0.6″]

Video Games

A database containing video games, their publishers, platforms, and how many sales they have made in several regions.

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure=”2_5,3_5″ _builder_version=”4.0.6″ link_option_url=”https://www.databasestar.com/sample-database-olympic-games/”][et_pb_column type=”2_5″ _builder_version=”4.0.6″][et_pb_code _builder_version=”4.0.6″ text_orientation=”center”][/et_pb_code][/et_pb_column][et_pb_column type=”3_5″ _builder_version=”4.0.6″][et_pb_text admin_label=”Olympics” _builder_version=”4.0.6″]

Olympic Games

A database containing each Olympic games, competitors, sports, events, and medals won.

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure=”2_5,3_5″ _builder_version=”4.0.9″ link_option_url=”https://www.databasestar.com/sample-database-superheroes/”][et_pb_column type=”2_5″ _builder_version=”4.0.6″][et_pb_code _builder_version=”4.0.9″ text_orientation=”center”][/et_pb_code][/et_pb_column][et_pb_column type=”3_5″ _builder_version=”4.0.6″][et_pb_text admin_label=”Superheroes” _builder_version=”4.0.9″]

Superheroes

A database containing 700+ superheroes, their attributes, superpowers, publishers, and several characteristics.

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure=”2_5,3_5″ _builder_version=”4.0.9″ link_option_url=”https://www.databasestar.com/sample-database-university-rankings/”][et_pb_column type=”2_5″ _builder_version=”4.0.6″][et_pb_code _builder_version=”4.0.9″ text_orientation=”center”][/et_pb_code][/et_pb_column][et_pb_column type=”3_5″ _builder_version=”4.0.6″][et_pb_text admin_label=”University Rankings” _builder_version=”4.0.9″]

University Rankings

This database contains a list of several hundred universities in the world, and their rankings over many years for three different ranking systems and 21 criteria. It’s good for summarising and visualising data and trends.

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section]

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.