1 / 12

Beginner's Guide to DB2 Database System: Course, Certification, & Resources

Learn about the DB2 database system, course content, student requirements, IBM DB2 certification, stored procedures, pure XML, Java, and more. Get hands-on with DB2 Express-C and IBM Data Studio. Prepare for the DB2 Fundamentals Exam 730. Explore references, study material, and installation instructions. Enhance your skills in database management with this comprehensive guide.

sheldont
Download Presentation

Beginner's Guide to DB2 Database System: Course, Certification, & Resources

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. QUY Thai Duy – ITFac DLUquytd@dlu.edu.vn, thaiduyquy@gmail.com Getting started with the DB2 data base system

  2. Agenda • Content this course • Requirement for student • Getting started • IBM DB2 Certification • References

  3. Contents • Stored Procedures and User-Defined Functions and trigger • pureXML – SQLXML & XQuery • Java Ruby on Rail • Getting Started. • Installation and the DB2 Editions. • The DB2 Environment. • Movement Backup and Restore Data.

  4. Requirement • Go to school every time – roll call. • Practice theory and quicklab. • Examination: 30% test, 70% test final

  5. Getting Started • Software that will be used (Windows or Linux): • DB2 Express-C 9.5(has 9.7). • IBM Data Studio 1.1 • Download and unzip (but do not install) from: www.ibm.com/db2/express (downloads tab) • Book & Exercises accompanying the book: Getting Started with DB2 Express-C (FREE online book) • Download and unzip from: www.ibm.com/db2/express

  6. IBM DB2 Certification FREE • DB2 Elite for Academics Program FREE Certification: • Exam 730, DB2 9 Fundamentals (DB2 Associate Certification) • Students who pass can post their resume in the IBM Academic • Initiative Student Opportunity System (SOS) • Preparation/Study material is included as part of this free program

  7. IBM Certified Database Associate – DB2 9 Fundamentals

  8. References [1]. Raul Chong, Ian Hakes, Rav Ahuja, Getting started with DB2 Express C, IBM Coporation, 2008 [2]. Cao Thị Nhạn, Giáo trình tóm tắt Cơ sở dữ liệu, ĐH Đà Lạt, 2008. [3]. Roger E. Sanders, DB2 9 Fundamentals Certification Study Guide (Exam 730), IBM Press. [4]. Raul F. Chong, Understanding DB2 Learning Visually with Examples, IBM Press. [5]. Zamil Janmohamed, Clara Liu, Drew Bradstock, Raul Chong, Michael Gao, Fraser McArthur, Paul Yip, DB2 SQL PL Essential Guide for DB2 UDB on Linux, UNIX, Windows, i5/OS, and z/OS, IBM Press.

  9. References(cont) • DB2 Express Home page http://www.ibm.com/db2/express • IBM developerWorks DB2 zone (Technical articles and tutorials) http://www.ibm.com/developerworks/db2 • Online searchable manuals – DB2 Information Center V9: http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp • V9.5: http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp • DB2 product information and version specific details: http://www.ibm.com/software/data/db2/udb/ • DB2 Application Development: www.ibm.com/software/data/db2/udb/ad

  10. Contacts

  11. Thank you!What’s Next? • Check out Lesson 1 of the DB2 on Campus Lecture series: “Installation & the DB2 Editions”

More Related