University of Minnesota
University Relations

Minnesota Supercomputing Institute

Log out of MyMSI

Tutorial Details: Introduction to Relational Database and Structure Query Language (SQL)

Date: Tuesday, July 6, 2004, 01:00 pm - 03:00 pm
Location: 585 Walter
Instructor(s): Zheng Jin Tu, MSI

Relational Database is a type of database management system (DBMS) that stores data in the form of related tables. It has been widely used in scientific research and industry. SQL is the standard language for accessing relational database management system.

The topics which will be discussed in this tutorial:

1) A brief overview of relational database design concepts and principals

2) Conceptual data model, data, and constraints

3) Introduction to Structural Query Language (SQL)

4) A demonstration on how to create database and tables, input data, and retrieve or query data from database using Oracle database.

Prerequisites: None