
Instructor Introduction
-
김연정
부산대학교 소프트웨어교육센터 강의전담교수 (17.8~20.1월)
Lecture plan
강의목록
-
CHAPTER 1. Introduction to Database
- 제1강. Database Management System(DBMS)
- 제2강. Data Models, Data Languages, Data Approaches
- 제3강. DB Components, Architecture, History
-
CHAPTER 2. Relational Model
- 제4강. Intro to Relational Model(1)
- 제5강. Intro to Relational Model(2)
-
CHAPTER 3. SQL
- 제6강. Introduction to SQL
- 제7강. Basic Query Structure
- 제8강. Natural Join, Rename Operation, String Operations
- 제9강. Duplicates, Set Operations
- 제10강. Null Value, Aggregate Functions
- 제11강. Nested Subqueries
- 제12강. With Clause, Scalar Subquery, Modification of the Database
-
CHAPTER 4. Intermediate SQL
- 제13강. Join Expressions, View
- 제14강. Transaction, Integrity Constraints
- 제15강. Index, Large Object Data Type, Authorization
-
CHAPTER 5. Advanced SQL
- 제16강. Accessing SQL from Programming Language
- 제17강. JDBC Programming
-
CHAPTER 7. Entity-Relationship Model
- 제18강. Entity, Relationship, Attribute
- 제19강. E-R Diagram, Weak Entity Set
- 제20강. Reduction to Relational Schemas
- 제21강. Extended E-R Model
-
CHAPTER 8. Normalization
- 제22강. Normalization(Anomaly, Functional Dependency)
- 제23강. Normalization(Normal Form)
-
CHAPTER 11. Indexing
- 제24강. Indexing
- 제25강. B+-Tree
-
CHAPTER 12. Transaction
- 제26강. Transaction
Additional Info
동영상에 사용된 ppt는 Database System Concepts (Copyright by Silberschatz, Korth and Sudarshan) 6th Edition에서 제공된 자료임을 알려드립니다.