PART 01 소프트웨어 설계
CHAPTER 01 요구사항 확인 (NCS 5 level) 3
SECTION 01 요구사항 확인 능력 단위 정의 ··············································3
SECTION 02 현행 시스템 분석 ···································································3
SECTION 03 요구사항 확인 ·······································································15
SECTION 04 분석모델 확인 ·······································································26
CHAPTER 02 화면 설계 (NCS 5 level) 36
SECTION 01 화면 설계 능력 단위 정의 ···················································36
SECTION 02 UI 요구사항 확인 ··································································36
SECTION 03 UI 설계 ··················································································46
CHAPTER 03 애플리케이션 설계 (NCS 6 level) 55
SECTION 01 애플리케이션 설계 능력 단위 정의 ····································55
SECTION 02 공통 모듈 설계 ·····································································55
SECTION 03 객체지향 설계 ·······································································69
CHAPTER 04 인터페이스 설계(NCS 6 level) 82
SECTION 01 인터페이스 설계 능력 단위 정의 ········································82
SECTION 02 인터페이스 요구사항 확인 ···················································82
SECTION 03 인터페이스 대상 식별 ··························································94
SECTION 04 인터페이스 상세 설계 ························································101

PART 02 소프트웨어 개발
CHAPTER 01 데이터 입출력 구현 (NCS 5 level) 117
SECTION 01 데이터 입출력 구현 능력 단위 정의 ································117
SECTION 02 논리 데이터저장소 확인 ····················································117
SECTION 03 물리 데이터저장소 설계 ····················································136
SECTION 04 데이터 조작 프로시저 작성 ···············································148
SECTION 05 데이터 조작 프로시저 최적화 ···········································161
CHAPTER 02 통합 구현(NCS 5 level) 172
SECTION 01 통합 구현 능력 단위 정의 ·················································172
SECTION 02 모듈 구현 ············································································172
SECTION 03 통합 구현 관리 ···································································182
CHAPTER 03 제품소프트웨어 패키징(NCS 5 level) 193
SECTION 01 제품소프트웨어 패키징 능력 단위 정의 ···························193
SECTION 02 제품소프트웨어 패키징 ······················································193
SECTION 03 제품소프트웨어 매뉴얼 작성 ·············································204
SECTION 04 제품소프트웨어 버전관리 ···················································214
CHAPTER 04 애플리케이션테스트 관리(NCS 5 level) 222
SECTION 01 애플리케이션테스트 관리 능력 단위 정의 ························222
SECTION 02 애플리케이션 테스트케이스 설계 ······································222
SECTION 03 애플리케이션 통합 테스트 ·················································238
SECTION 04 애플리케이션 성능 개선 ····················································252
CHAPTER 05 인터페이스 구현 (NCS 5 level) 270
SECTION 01 인터페이스 구현 능력 단위 정의 ······································270
SECTION 02 인터페이스 설계 확인 ························································270
SECTION 03 인터페이스 기능 구현 ························································279
SECTION 04 인터페이스 구현 검증 ························································294

PART 03 데이터베이스
CHAPTER 01 SQL 활용 (NCS 3 level) 303
SECTION 01 SQL 활용 능력 단위 정의 ·················································303
SECTION 02 기본 SQL 작성 ···································································303
SECTION 03 고급 SQL 작성 ···································································350
CHAPTER 02 SQL 응용 (NCS 5 level) 370
SECTION 01 SQL 응용 능력 단위 정의 ·················································370
SECTION 02 응용 SQL 작성 ···································································370
SECTION 03 절차형 SQL 작성 ·······························································384
CHAPTER 03 논리 데이터베이스 설계(NCS 6 level) 408
SECTION 01 논리 데이터베이스 설계 능력 단위 정의 ·························408
SECTION 02 데이터 모델 ········································································408
SECTION 03 데이터모델링 및 설계 ························································434
CHAPTER 04 물리 데이터베이스 설계(NCS 6 level) 451
SECTION 01 물리 데이터베이스 설계 능력 단위 정의 ·························451
SECTION 02 물리요소 조사 분석 ····························································451
SECTION 03 데이터베이스 물리속성 설계 ·············································474
SECTION 04 물리 데이터베이스 모델링 ·················································491
SECTION 05 데이터베이스 반정규화 ······················································501
SECTION 06 물리데이터 모델 품질검토 ·················································508
CHAPTER 05 데이터 전환(NCS 5 level) 519
SECTION 01 데이터 전환 능력 단위 정의 ·············································519
SECTION 02 데이터 전환 기술 ·····························································519
SECTION 03 데이터 전환 수행 ·······························································528
SECTION 04 데이터 정제 ········································································536

PART 04 프로그래밍 언어 활용
CHAPTER 01 서버프로그램 구현 (NCS 5 level) 545
SECTION 01 서버프로그램 구현 능력 단위 정의 ··································545
SECTION 02 개발환경 구축 ·····································································545
SECTION 03 공통 모듈 구현 ···································································558
SECTION 04 서버 프로그램 구현 ····························································572
SECTION 05 배치 프로그램 구현 ····························································583
CHAPTER 02 프로그래밍 언어 활용 (NCS 3 level) 589
SECTION 01 프로그래밍 언어 활용 능력 단위 정의 ·····························589
SECTION 02 기본문법 활용 ·····································································589
SECTION 03 언어특성 활용 ·····································································599
SECTION 04 라이브러리 활용 ·································································609
CHAPTER 03 응용 SW 기초기술 활용(NCS 3 level) 619
SECTION 01 응용 소프트웨어 기초기술 활용 능력 단위 정의 ·············619
SECTION 02 운영체제 기초 활용 ····························································619
SECTION 03 네트워크 기초 활용 ····························································709

PART 05정보시스템 구축 관리
CHAPTER 01 소프트웨어 개발 방법론 활용(NCS 6 level) 730
SECTION 01 소프트웨어 개발 방법론 활용 능력 단위 정의 ················730
SECTION 02 소프트웨어 개발 방법론 선정 ···········································730
SECTION 03 소프트웨어 개발 방법론 테일러링 ··································777
CHAPTER 02 IT프로젝트 정보시스템 구축 관리(NCS 5 level) 785
SECTION 01 IT프로젝트 정보시스템 구축 관리 능력 정의 ·················785
SECTION 02 네트워크 구축 관리 ····························································785
SECTION 03 SW 구축 관리 ····································································799
SECTION 04 HW 구축 관리 ····································································807
SECTION 05 DB 구축 관리 ···································································814
CHAPTER 03 소프트웨어 개발 보안 구축(NCS 5 level) 824
SECTION 01 소프트웨어 개발 보안 구축 능력 단위 정의 ····················824
SECTION 02 SW개발 보안 설계 ·····························································824
SECTION 03 SW개발 보안 구현 ···························································840
CHAPTER 04 시스템 보안 구축(NCS 5 level) 848
SECTION 01 시스템 보안 구축 능력 단위 정의 ····································848
SECTION 02 시스템 보안 설계 ·······························································848
SECTION 03 시스템 보안 구현 ·····························································863

PART 06최신 IT 용어
CHAPTER 01 최신 IT 용어(네트워크 및 컴퓨팅 분야) 877
CHAPTER 02 최신 IT 용어(소프트웨어 응용 분야) 891
CHAPTER 03 최신 IT 용어(데이터/DB 분야) 902