달력

52024  이전 다음

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31

'Lecture Notes/Database Design'에 해당되는 글 14건

  1. 2015.06.03 ER Diagram - ERWin & Examples
  2. 2015.06.03 Constraints
  3. 2015.06.03 Other Objects - View, Sequence, Inde, Synonym
  4. 2015.06.03 DDL statements
  5. 2015.06.03 DML - Insert, Update, Delete Statements
  6. 2015.06.03 Subquery
  7. 2015.06.03 Group Functions
  8. 2015.06.03 Single Row Functions
  9. 2015.06.03 Where Condition
  10. 2015.06.03 Select DML
  11. 2015.06.03 Installalation MySQL and Oracle
  12. 2015.04.07 Introduction to Database System
  13. 2015.04.07 Process of Executable File Generation
  14. 2015.04.07 Software Life Cycle

ER Diagram - ERWin & Examples

Lecture Notes/Database Design 2015. 6. 3. 09:14

ERwin Installation and Temporary License

1. http://erwin.com/resources/software-trials

 

ERD_Example.pdf

erwinlicense.lic

 

'Lecture Notes > Database Design' 카테고리의 다른 글

Constraints  (0) 2015.06.03
Other Objects - View, Sequence, Inde, Synonym  (0) 2015.06.03
DDL statements  (0) 2015.06.03
DML - Insert, Update, Delete Statements  (0) 2015.06.03
Subquery  (0) 2015.06.03
Posted by kingjung
|

Constraints

Lecture Notes/Database Design 2015. 6. 3. 09:12

 

11_Constraints.pdf

 

'Lecture Notes > Database Design' 카테고리의 다른 글

ER Diagram - ERWin & Examples  (0) 2015.06.03
Other Objects - View, Sequence, Inde, Synonym  (0) 2015.06.03
DDL statements  (0) 2015.06.03
DML - Insert, Update, Delete Statements  (0) 2015.06.03
Subquery  (0) 2015.06.03
Posted by kingjung
|

Other Objects - View, Sequence, Inde, Synonym

Lecture Notes/Database Design 2015. 6. 3. 09:12

 

10_View.pdf

 

'Lecture Notes > Database Design' 카테고리의 다른 글

ER Diagram - ERWin & Examples  (0) 2015.06.03
Constraints  (0) 2015.06.03
DDL statements  (0) 2015.06.03
DML - Insert, Update, Delete Statements  (0) 2015.06.03
Subquery  (0) 2015.06.03
Posted by kingjung
|

DDL statements

Lecture Notes/Database Design 2015. 6. 3. 09:11

 

09_DDL.pdf

 

'Lecture Notes > Database Design' 카테고리의 다른 글

Constraints  (0) 2015.06.03
Other Objects - View, Sequence, Inde, Synonym  (0) 2015.06.03
DML - Insert, Update, Delete Statements  (0) 2015.06.03
Subquery  (0) 2015.06.03
Group Functions  (0) 2015.06.03
Posted by kingjung
|

DML - Insert, Update, Delete Statements

Lecture Notes/Database Design 2015. 6. 3. 09:10

 

08_DML.pdf

 

'Lecture Notes > Database Design' 카테고리의 다른 글

Other Objects - View, Sequence, Inde, Synonym  (0) 2015.06.03
DDL statements  (0) 2015.06.03
Subquery  (0) 2015.06.03
Group Functions  (0) 2015.06.03
Single Row Functions  (0) 2015.06.03
Posted by kingjung
|

Subquery

Lecture Notes/Database Design 2015. 6. 3. 09:09

 

07_subqueries.pdf

 

'Lecture Notes > Database Design' 카테고리의 다른 글

DDL statements  (0) 2015.06.03
DML - Insert, Update, Delete Statements  (0) 2015.06.03
Group Functions  (0) 2015.06.03
Single Row Functions  (0) 2015.06.03
Where Condition  (0) 2015.06.03
Posted by kingjung
|

Group Functions

Lecture Notes/Database Design 2015. 6. 3. 09:09

 

06_groupfunctions.pdf

 

'Lecture Notes > Database Design' 카테고리의 다른 글

DML - Insert, Update, Delete Statements  (0) 2015.06.03
Subquery  (0) 2015.06.03
Single Row Functions  (0) 2015.06.03
Where Condition  (0) 2015.06.03
Select DML  (0) 2015.06.03
Posted by kingjung
|

Single Row Functions

Lecture Notes/Database Design 2015. 6. 3. 09:08

 

05_singlerowfunctions.pdf

 

'Lecture Notes > Database Design' 카테고리의 다른 글

Subquery  (0) 2015.06.03
Group Functions  (0) 2015.06.03
Where Condition  (0) 2015.06.03
Select DML  (0) 2015.06.03
Installalation MySQL and Oracle  (0) 2015.06.03
Posted by kingjung
|

Where Condition

Lecture Notes/Database Design 2015. 6. 3. 09:06

 

04_where.pdf

 

'Lecture Notes > Database Design' 카테고리의 다른 글

Group Functions  (0) 2015.06.03
Single Row Functions  (0) 2015.06.03
Select DML  (0) 2015.06.03
Installalation MySQL and Oracle  (0) 2015.06.03
Introduction to Database System  (0) 2015.04.07
Posted by kingjung
|

Select DML

Lecture Notes/Database Design 2015. 6. 3. 09:05

 

03_select.pdf

 

'Lecture Notes > Database Design' 카테고리의 다른 글

Single Row Functions  (0) 2015.06.03
Where Condition  (0) 2015.06.03
Installalation MySQL and Oracle  (0) 2015.06.03
Introduction to Database System  (0) 2015.04.07
Process of Executable File Generation  (0) 2015.04.07
Posted by kingjung
|

Installalation MySQL and Oracle

Lecture Notes/Database Design 2015. 6. 3. 09:02

 

02_installation.pdf

 

'Lecture Notes > Database Design' 카테고리의 다른 글

Where Condition  (0) 2015.06.03
Select DML  (0) 2015.06.03
Introduction to Database System  (0) 2015.04.07
Process of Executable File Generation  (0) 2015.04.07
Software Life Cycle  (0) 2015.04.07
Posted by kingjung
|

Introduction to Database System

Lecture Notes/Database Design 2015. 4. 7. 13:23

1. Database

2. Users

3. Data Language

4. DBMS

5. Database Machine

 

 

01_introduction.pdf

 

'Lecture Notes > Database Design' 카테고리의 다른 글

Where Condition  (0) 2015.06.03
Select DML  (0) 2015.06.03
Installalation MySQL and Oracle  (0) 2015.06.03
Process of Executable File Generation  (0) 2015.04.07
Software Life Cycle  (0) 2015.04.07
Posted by kingjung
|

Process of Executable File Generation

Lecture Notes/Database Design 2015. 4. 7. 11:06

1. Preprocessing

2. Compiling

3. Linking

 

 

ProcessofExe.pdf

 

'Lecture Notes > Database Design' 카테고리의 다른 글

Where Condition  (0) 2015.06.03
Select DML  (0) 2015.06.03
Installalation MySQL and Oracle  (0) 2015.06.03
Introduction to Database System  (0) 2015.04.07
Software Life Cycle  (0) 2015.04.07
Posted by kingjung
|

Software Life Cycle

Lecture Notes/Database Design 2015. 4. 7. 10:01

1. Requirements Definition

2. System & Software Design

3. Implementation

4. Unit Testing & Integration Testing

5. Operation & Maintenance

 

 

SoftwareLifeCycle.pdf

 

'Lecture Notes > Database Design' 카테고리의 다른 글

Where Condition  (0) 2015.06.03
Select DML  (0) 2015.06.03
Installalation MySQL and Oracle  (0) 2015.06.03
Introduction to Database System  (0) 2015.04.07
Process of Executable File Generation  (0) 2015.04.07
Posted by kingjung
|

티스토리툴바