Go to login Go to sub menu Go to text

Course summary

  • Type MOOC course
  • Period Always open
  • Learning Time Study freely
  • Course approval method Automatic approval
  • Certificate Issue Online
http://www.edwith.org/database
둘러보기
Thumb up 55 Learner 1664

Instructor Introduction

  • 김연정

    부산대학교 소프트웨어교육센터 강의전담교수 (17.8~20.1월)

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

Additional Info

동영상에 사용된 ppt는 Database System Concepts (Copyright by Silberschatz, Korth and Sudarshan) 6th Edition에서 제공된 자료임을 알려드립니다.