데이터베이스

강의상세

<교재 및 출처> Database System Concepts, Sixth Edition, Abraham Silberschatz, Henry F. Korth, S. Sudarshan, McGraw-Hill, 2010

1.	OT	Orientation
	Chapter 1: Introduction	Database System
2.	Chapter 2: Intro to Relational Model	Relational Model
	Chapter 2: Intro to Relational Model / Chapter 3: Introduction to SQL	Natural Join. SQL
3.	Chapter 3: Introduction to SQL	Create tables, Basic Query Structure, Clause
4.	Chapter 3: Introduction to SQL	Joins, Operation
5.	Chapter 3: Introduction to SQL	Set Operations, Null Values, Aggregate Functions
	Chapter 3: Introduction to SQL	Aggregate Functions, Nested Subqueries
6.	Chapter 3: Introduction to SQL	Nested Subqueries, Modification of the Database
	Chapter 3: Introduction to SQL	MySLQ, Modification of the Database
7.	Chapter 3: Introduction to SQL / Chapter 4: Intermediate SQL	MySLQ Server Installation, Join Expressions
8.	Chapter 4: Intermediate SQL	Views, Transactions
	Chapter 4: Intermediate SQL	Integrity Constraints, SQL Data Types and Schemas, Authorization
9.	Chapter 5: Advanced SQL	JDBC
10.	Chapter 5: Advanced SQL	JDBC
11.	Chapter 7: Entity-Relationship Model	Design Process, Modeling, Constraints, E-R Diagram
12.	Chapter 7: Entity-Relationship Model	Design Issues
	Chapter 8: Relational Database Design	Features of Good Relational Design, Atomic Domains and First Normal Form
13.	Chapter 8: Relational Database Design
14.	Chapter 5: Advanced SQL	ODBC, Embedded SQL, SQL Data Types and Schemas Functions and Procedural Constructs
	Chapter 5: Advanced SQL	SQL Procedures
15.	Chapter 5: Advanced SQL / Chapter 11: Indexing and Hashing	Triggers, Advanced Aggregation Features, index file, B+-Tree