《IBM DB2認證認證》課程介紹
DB2是IBM公司研制的一種關系型數據庫系統，主要應用于大型應用系統，具有較好的可伸縮性，可➿⚽✨➿從大型機到單用戶環境，可應用于OS/2、Windows等平台下。 DB2提供了高層次的數據利用性、完整性、安全性、可恢複性，以及小規模到大規模應用程序的執行能力，具有與平台無關的基本功能和SQL命令，并以擁有一個非常完備的查詢優化器而著稱，改善了查詢性能并➿⚽✨➿多任務并行查詢。DB2是目前市場上的主流大型數據庫産品之一，适⏭➰為高校學生實踐認證類課程的學習對象。
《DB2認證》是基于DB2 UDB的将數據庫理論與行業軟件相結合的認證類專業課程。作為數據庫基本原理的後續課程以及數據庫應用開發的先修課程，此課程的教學目的在于介紹DB2 UDB的體系架構、數據庫高級管理的主要任務及手段，通過大量的實際案例幫助學生快速了解和掌握數據庫的創建、維護、監控、恢複、調優、應用程序開發等工作，為學生日後從事數據庫相關工作打下堅實的基礎。
DB2認證課程的主要教學内容包括：DB2數據庫組件介紹、體系架構、實用工具，以及DB2數據庫的日常管理任務，如安裝配置、實例管理、數據庫創建和物理存儲規劃、數據移動(遷移)、數據庫日志管理、數據庫備份和恢複、數據庫鎖和并發控制、性能監控和調優、問題診斷、DB2數據庫安全等，也包括新版本增加的一些重要功能和特性。
此課程第二學年第二學期開設，計劃學時48，含實驗學時16，先修課為：高級語言程序設計，操作系統，數據庫原理。
Introduction to the course“DB2 Certification”
DB2 is a relational database system developed by IBM company, which is mainly used in large-scale application system. It has good scalability, can support from mainframes to single user environment, can be applied to OS/2, Windows and other platforms. DB2 provides high level data utility, integrity, security, recovery as well as the execution ability from small scale to large scale application. DB2 provides the basic functions and the SQL command which are both platform independent. DB2 is well known by having a very complete query optimizer, which improves the performance of the query and supports multi-task parallel query. DB2 is one of the popular database products on the market at present, and is very suitable for students practice as a learning object in certification courses.
"DB2 certification" is a certification course based on DB2 UDB which combines the database theory and software industry. As the subsequent course of database basic principle and the prerequisite course of database application development, the objective of this course is to introduce DB2 architecture, and the main task and means of database advanced management. Through a large number of actual cases, this course will help students quickly understand and master the database creation, maintenance, monitoring, recovery, optimization, application development work, and lay a solid foundation for the students who will be engaged in the related database work in the future.
The main contents of DB2 certification courses include: introduction of DB2 database component, architecture, utility, and DB2 database daily management tasks, such as installation and configuration, instance management, database creation and physical storage planning, data movement (migration), database log management, database backup and recovery, and concurrency control, the database lock performance monitoring and tuning, problem diagnosis, DB2 database security. It also includes some important functions and characteristics of new version.
This course will be opened in the fourth semester, totally 48 hours, including 16 hours experiment, and its prerequisite courses advanced programming language, operating system, database principle.
