DB2 on Campus
Information
The DB2 on Campus Program is an offering designed to promote the use of DB2 in educational institutions.
Website: http://channeldb2.com/oncampus
Members: 98
Latest Activity: Feb 16
DB2 on Campus Resources and Videos
| Table of contents |
| Presentation replays |
| Newsletters |
| DB2 online course (Videos) |
Presentation Replays
| Date | Title | Replay link |
|---|---|---|
| 03/09/09 | DB2 overview & PHP Seminar - Hosted by NUS | Link |
| 30/09/09 | DB2 9.7 - Technical overview - Hosted by Data Access (In Spanish) | Link |
| 12/11/09 | DB2 9.7 - Technical overview - Hosted by developerWorks | Link |
Newsletters
| Edition | View online |
|---|---|
| 1st Quarter Edition | 1Q2009 (pdf, 2MB) |
| 2nd Quarter Edition | 2Q2009 (pdf, 2MB) |
| 3rd Quarter Edition | 3Q2009 (pdf, 2MB) |
DB2 online course (Videos)
Learn DB2 in one day with the help of the videos listed below. Use them in conjunction with the FREE DB2 Express-C ebook and start to develop solid basic DB2 skills. The material for the videos, corresponding PDF presentations, and the book is the same: Three different formats of learning, one content. Note that hands-on exercises ("Quicklabs") are also included with the book.
Download all the videos and corresponding PDF presentations at once (445MB) from here (quick registration required). You can also download individual videos or watch them online by selecting the appropriate link in the tables below (no registration required).
Introductory Videos
This is the introductory presentation provided as part of the DB2 on Campus program. It has been split into four parts:
| # | Presentation Title | Size (MB) | Download | View online | Transcripts |
|---|---|---|---|---|---|
| 0 | The DB2 on Campus Program | 14.9 | Download now! | Watch now! | View |
| 1 | The Role of DB2 Express-C in the IOD world (1 of 2) | 11.4 | Download now! | Watch now! | View |
| 2 | The Role of DB2 Express-C in the IOD world (2 of 2) | 15.3 | Download now! | Watch now! | View |
| 3 | Your opportunity - Ten steps to career success | 8.2 | Download now! | Watch now! | View |
Technical Videos
| # | Lesson Title | Size (MB) | Download | View online | Transcripts |
|---|---|---|---|---|---|
| 0 | Lesson 0: Getting Started | 7.3 | Download now! | Watch now! | View |
| 1 | Lesson 1: Installation and the DB2 Editions | 18.1 | Download now! | Watch now! | View |
| 2 | Lesson 2: The DB2 Environment | 22.8 | Download now! | Watch Part1! Watch Part2! | View Part 1 View Part 2 |
| 3 | Lesson 3: Tools & Scripting | 50.3 | Download now! | Watch Part1! Watch Part2! | View Part 1 View Part 2 |
| 4 | Lesson 4: Architecture | 12.4 | Download now! | Watch now! | View |
| 5 | Lesson 5: Connectivity | 20.5 | Download now! | Watch now! | View |
| 6 | Lesson 6: Working with database objects | 21.1 | Download now! | Watch now! | View |
| 7 | Lesson 7: Data movement | 23.5 | Download now! | Watch now! | View |
| 8 | Lesson 8: Security | 14.1 | Download now! | Watch now! | View |
| 9 | Lesson 9: Backup & Recovery | 21.7 | Download now! | Watch now! | View |
| 10 | Lesson 10: Maintenance | 13.9 | Download now! | Watch now! | View |
| 11 | Lesson 11: Concurrency & Locking | 19.3 | Download now! | Watch now! | View |
| 12 | Lesson 12: SQL PL Stored Procedures | 30.0 | Download now! | Watch now! | View |
| 13 | Lesson 13: UDFs | 19.8 | Download now! | Watch now! | View |
| 14 | Lesson 14: Triggers | 20.3 | Download now! | Watch now! | View |
| 15 | Lesson 15: PureXML SQL/XML XQuery | 42.1 | Download now! | Watch now! | View |
| 16 | Lesson 16: Java, Ruby, PHP | 11.5 | Download now! | Watch now! | View |
| 17 | Lesson 17: Troubleshooting | 14.9 | Download now! | Watch now! | View |
DB2 on Campus Blog
Loading feed
Comment Wall
Comment
-
Comment by Susan Visser on December 2, 2009 at 2:10pm -
DB2 vs SQL Server? Which is better? Which product should YOU build skills on?
Find this out... and much more. This Friday, December 4 at 11 EST, join Scott Hayes and Leon Katsnelson on Episode #7 of The DB2 Night Show!
Find out more... click here.
-
Comment by Oswaldo F. Domejean on February 11, 2009 at 7:36pm -
Hi,
I invite you all to visit my website that has a publication about the weaknesses SQL has on Database Processing. All the examples had been tested in DB2, but the situation is practically the same and in some cases still worse in other SQL DBMS. This publication explains aspects related to:
• Equivalent queries may produce different results.
• Aggregation operators like SUM, AVG, etc. doesn’t generate the correct calculation in certain cases.
• Query tables that have nulls may lead us to misinterpret results in a variety of cases.
It’s essential for us to be conscious about the weaknesses this language has in order to avoid them. I hope it’s useful:
The publication at amazon.com: http://www.amazon.com/Weaknesses-Database-Processing-Oswaldo-Domejean/dp/0557024927/ref=sr_1_1?ie=UTF8&s=books&qid=1233516665&sr=1-1
The publication at lulu.com: http://stores.lulu.com/dbtips
A couple of weaknesses explained in my blog: http://dbtips.wordpress.com/
and its video clip in youtube.com: http://www.youtube.com/watch?v=FWrH5K6V6E0
Thanks for reading,
O. F. Domejean
-
Comment by Chua Chuen Loy, Jackie on December 12, 2008 at 4:27am - DB2 on Campus has landed in Singapore, National University of Singapore, since 2007.
-
Comment by Min Wei on November 28, 2008 at 8:48am -
Yes,I think it's great for us to have an original editions when we
are reading the translated ones.For one thing,it can tell us how the concept is called in English,which will help us greatly when we meet them again and for the other thing,we can get clearly what the author wanna say,and maybe there are some misunderstandings,so I think ,this is really good when I get an original book written in English!
About
Featured Downloads
© 2010 Created by channeldb2 on Ning. Create a Ning Network!
You need to be a member of DB2 on Campus to add comments!