Course Information

Data management technology, database

A database is an organized collection of data. It is the collection of schemas, tables, queries, reports, views and other objects. The data are typically organized to model aspects of reality in a way that supports processes requiring information. A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data. A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases.

Class Time and Location

  • 1분반: 목요일, 12:00-15:00 (인하대학교)
  • 2분반: 목요일, 16:30-19:30 (인하대학교)

Textbook

  • Slides

Course Project

  • None

Grading Policy

  • 10% Attendance
  • 30% Midterm
  • 30% Final
  • 30% Project

Late Policy

  • If the attendance is less than two-thirds of the total class time, F credit
  • If you are absent due to hospital treatment or emergency, please send your doctor's report by e-mail after scanning or shooting

Prerequisite

  • Algebra
  • English (Lectures in English)

Schedule and Syllabus

# of Lecture Date Description Course Materials
Lecture #1 2016-03-03 Introduction to Databases Lecture slides
Lecture #2 2016-03-10 The Relational Model Lecture slides
Lecture #3 2016-03-17 Relational Algebra - Select Lecture slides
Lecture #4 2016-03-24 Relational Algebra - Project Lecture slides
Lecture #5 2016-03-31 Relational Algebra - Join Lecture slides
Lecture #6 2016-04-07 Relational Algebra - Set operators Lecture slides
Lecture #7 2016-04-14 Relational Algebra - Renaming Lecture slides
Lecture #8 2016-04-21 Relational Algebra - Notation Lecture slides
Test #1 2016-04-28 Midterm Test
Holiday 2016-05-05 Children's Day
Lecture #10 2016-05-12 SQL 1 Lecture slides
Lecture #11 2016-05-19 SQL 2 Lecture slides
Lecture #12 2016-05-26 Indexes Lecture slides
Lecture #13 2016-06-02 Views Lecture slides
Test #2 2016-06-09 Final Test

Course FAQ

Oracle을 설치해서 실제 SQL을 학습하는 실습을 수행합니다. 이론을 잘 이해했다면 어렵지 않게 할 수 있습니다.

Course Comments