Information Management Ecosystem Partnerships
IBM Canada Lab
Summer/Fall 2010
Welcome
DB2 9.7 Academic Workshop
Information Management
© 2010 IBM Corporation
Information Management
Disclaimer
© Copyright IBM Corporation 2010. All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM
Corp.
THE INFORMATION CONTAINED IN THIS PRESENTATION IS PROVIDED FOR INFORMATIONAL PURPOSES ONLY. WHILE
EFFORTS WERE MADE TO VERIFY THE COMPLETENESS AND ACCURACY OF THE INFORMATION CONTAINED IN THIS
PRESENTATION, IT IS PROVIDED “AS IS” WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED. IN ADDITION,
THIS INFORMATION IS BASED ON IBM’S CURRENT PRODUCT PLANS AND STRATEGY, WHICH ARE SUBJECT TO
CHANGE BY IBM WITHOUT NOTICE. IBM SHALL NOT BE RESPONSIBLE FOR ANY DAMAGES ARISING OUT OF THE USE
OF, OR OTHERWISE RELATED TO, THIS PRESENTATION OR ANY OTHER DOCUMENTATION. NOTHING CONTAINED IN
THIS PRESENTATION IS INTENDED TO, NOR SHALL HAVE THE EFFECT OF, CREATING ANY WARRANTIES OR
REPRESENTATIONS FROM IBM (OR ITS SUPPLIERS OR LICENSORS), OR ALTERING THE TERMS AND CONDITIONS OF
ANY AGREEMENT OR LICENSE GOVERNING THE USE OF IBM PRODUCTS AND/OR SOFTWARE.
IBM, the IBM logo, ibm.com, and DB2 are trademarks or registered trademarks of International Business Machines Corporation
in the United States, other countries, or both. If these and other IBM trademarked terms are marked on their first
occurrence in this information with a trademark symbol (® or ™), these symbols indicate U.S. registered or common law
trademarks owned by IBM at the time this information was published. Such trademarks may also be registered or
common law trademarks in other countries. A current list of IBM trademarks is available on the Web at “Copyright and
trademark information” at www.ibm.com/legal/copytrade.shtml
Other company, product, or service names may be trademarks or service marks of others.
2 © 2010 IBM Corporation
Information Management
Agenda – Day 1
■ 1.0 Welcome
■ 1.1 The Relational Data Model
■ < Break >
■ 1.2 DB2 Fundamentals and Data Studio
■ 1.3 IBM Data Studio Lab (Hands On)
Lunch
■ 1.4 Working with Databases and Database Objects
■ 1.5 Working with Databases and Database Objects (Hands On)
■ < Break >
■ 1.6 Introduction to SQL
■ 1.7 Understanding SQL Lab (Hands On)
■ Summary
3 © 2010 IBM Corporation
Information Management
Agenda – Day 2
■ 2.1 Data Concurrency
■ 2.2 Data Concurrency Lab (Hands On)
■ < Break >
■ 2.3 Database Security in DB2
■ 2.4 DB2 Security Lab (Hands On)
Lunch
■ 2.5 DB2 Backup and Recovery
■ 2.6 DB2 Backup and Recovery Lab (Hands On)
■ < Break >
■ 2.7 DB2 pureXML
■ 2.8 DB2 pureXML – Storing XML Data Made Easy Lab (Hands On)
■ Summary
4 © 2010 IBM Corporation
Information Management
Agenda – Day 3
■ 3.1 DB2 Programming Fundamentals
■ < Break >
■ 3.2 Accessing DB2 Databases From Applications Lab (Hands On)
■ Summary
■ Lunch
■ 3.3 Course Review
■ 3.4 IBM Certified Academic Associate - DB2 9 Database and Application
Fundamentals
5 © 2010 IBM Corporation
Information Management
IBM Certified Academic Associate - 302
- DB2 9 Database and Application Fundamentals
■ Test : IBM Certified Academic Associate - DB2 9 Database and Application
Fundamentals
– This is an entry level academic course for the DB2 9 products The certified individual is
knowledgeable about the fundamental administration and development concepts of DB2 9.7.
– Exam breakdown:
• Relational Data Model (15%)
• DB2 Fundamentals (15%)
• DB2 pureXML (10%)
• Transactions on DB2 (5%)
• Data Concurrency (5%)
• Working with Database Objects (10%) Free for attendees of
• Database Security in DB2 (10%) this workshop!
• Backup and Recovery (5%)
• DB2 Programming Fundamentals (10%)
• Working with SQL (15%)
6 © 2010 IBM Corporation
Information Management
DB2 Certification & Free Tutorials
Information Management Certification website:
– www.ibm.com/software/data/education
Step 1
– IBM Certified Database Associate for DB2 9 Fundamentals, Exam 730
• Exam info: http://www-03.ibm.com/certify/tests/obj730.shtml
• Free tutorial: http://www.ibm.com/developerworks/offers/lp/db2cert/db2-cert730.html
■ Step 2 (for DBAs)
– IBM Certified Database Administrator for DB2 9.7 DBA for LUW, Exam 541
• Exam info: http://www-03.ibm.com/certify/tests/obj541.shtml
• Free tutorial (DB2 9): http://www.ibm.com/developerworks/offers/lp/db2cert/db2-cert731.html
■ Step 2 (for Developers)
– IBM Certified Application Developer for DB2 9.7, Exam 543
• Exam info: http://www-03.ibm.com/certify/tests/obj543.shtml
■ Step 2 (for z/OS)
– IBM Certified Database Administrator for DB2 9 DBA for z/OS, Exam 732
– Exam info: http://www-03.ibm.com/certify/tests/obj732.shtml
Step 3
– IBM Certified Advanced Database Administrator for DB2 9 DBA for LUW, Exam 734
• Exam info: http://www-03.ibm.com/certify/tests/obj734.shtml
7 © 2010 IBM Corporation
Information Management
IBM Guided Hands-on Technical Learning
-Technical Education Bootcamps
Education
DM Bootcamps
– WW Bootcamps Available for:
DB2 9.7 LUW & Migration Clinic
DB2 pureXML
Informix 11.5
IBM InfoSphere Warehouse v9.7
IBM Optim Solutions
Guardium
SolidDB
InfoSphere Change Data Capture
InfoSphere Information Server
InfoSphere Master Data Management
■ 2010 schedule, bootcamp agenda and registration available here:
www.ibm.com/developerworks/data/bootcamps/
8 © 2010 IBM Corporation
Information Management
Individual Reading
Reading Materials – printed
– www.ibm.com/software/data/education/bookstore
– Study Guides
• DB2 9 Fundamentals 978-1-58-347072-5
• DB2 9 for Linux, UNIX, and Windows Database Administration 158347-077-8
• DB2 9 for z/OS Database Administration 978-158347-074-9
• DB2 9 for Linux, UNIX, and Windows Database Administration Upgrade 158347-078-6
– Books
• DB2 9 for Linux, UNIX, and Windows – Sixth Ed. 0-13-185514-X
• Understanding DB2: Learning VisuallyReading Materials – online
– Manuals: http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg27015148
– DB2 Information Center: http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/
– IBM Redbooks: http://www.redbooks.ibm.com/ with Examples 0-13-158018-3
• Understanding DB2 9 Security 0-13-1345907
• DB2 9 for Developers 978-158347-071-9
Tutorials/Self-Study
– www.ibm.com/software/data/education/selfstudy.html
Data Management Magazine – (Former IBM Database Magazine)
– http://www.ibmdmmagazinedigital.com/
Performance Perspectives – Insights and ideas on Information on Demand
– http://www-01.ibm.com/software/data/performance-perspectives/
9 © 2010 IBM Corporation
Information Management
Bringing it all Together
-Information on Demand Conference
IOD Global, 24 – 28 October 2010 – Las Vegas, United States
Education/Certification
Business Prospecting
Partner Networking
IBM Relationships
10 © 2010 IBM Corporation
Information Management
Access to Software
DB2 Express-C
http://www.ibm.com/db2/express/
Application Development Downloads
IBM Data Studio: www.ibm.com/software/data/studio/
DB2 Information Center
DB2 Client
Zend Core for IBM
More Info: www.ibm.com/software/data/db2/ad/
Download Via: www.ibm.com/db2/express/download.html
Software Value Package:
https://www-304.ibm.com/jct09002c/partnerworld/mem/valuepack/mem_ben_value_resellers.html
11 © 2010 IBM Corporation
Information Management
DB2 Express-C vs. DB2 Express Fixex Term License (FTL)
■ * Features entitled with Subscription are available only while Subscriptions are valid
■ ** Subscription Price indicated is for United States and subject to change. Pricing in other countries may vary.
■ *** No-charge community-based assistance is available via the online forum.
■ **** CPU and memory limitations for DB2 Express-C are not limitations of the machine size, rather they specify DB2 usage limits
on those machines.
12 © 2010 IBM Corporation
Information Management Ecosystem Partnerships
IBM Canada Lab
Questions? Summer/Fall 2010
E-mail: imschool@us.ibm.com
Subject: “DB2 Academic Workshop”
Information Management
© 2010 IBM Corporation
