Go to login Go to sub menu Go to text
  • Type MOOC course
  • Period Always open
  • hr Study freely
  • Course approval method Automatic approval

Instructor Introduction

Lecture plan

강의목록
  1. CHAPTER 1. Introduction to Database
    1. 제1강. Database Management System(DBMS)
    1. 제2강. Data Models, Data Languages, Data Approaches
    1. 제3강. DB Components, Architecture, History
  2. CHAPTER 2. Relational Model
    1. 제4강. Intro to Relational Model(1)
    1. 제5강. Intro to Relational Model(2)
  3. CHAPTER 3. SQL
    1. 제6강. Introduction to SQL
    1. 제7강. Basic Query Structure
    1. 제8강. Natural Join, Rename Operation, String Operations
    1. 제9강. Duplicates, Set Operations
    1. 제10강. Null Value, Aggregate Functions
    1. 제11강. Nested Subqueries
    1. 제12강. With Clause, Scalar Subquery, Modification of the Database
  4. CHAPTER 4. Intermediate SQL
    1. 제13강. Join Expressions, View
    1. 제14강. Transaction, Integrity Constraints
    1. 제15강. Index, Large Object Data Type, Authorization
  5. CHAPTER 5. Advanced SQL
    1. 제16강. Accessing SQL from Programming Language
    1. 제17강. JDBC Programming
  6. CHAPTER 7. Entity-Relationship Model
    1. 제18강. Entity, Relationship, Attribute
    1. 제19강. E-R Diagram, Weak Entity Set
    1. 제20강. Reduction to Relational Schemas
    1. 제21강. Extended E-R Model
  7. CHAPTER 8. Normalization
    1. 제22강. Normalization(Anomaly, Functional Dependency)
    1. 제23강. Normalization(Normal Form)
  8. CHAPTER 11. Indexing
    1. 제24강. Indexing
    1. 제25강. B+-Tree
  9. CHAPTER 12. Transaction
    1. 제26강. Transaction