ChannelDB2

Information

DB2 on Campus

The DB2 on Campus Program is an offering designed to promote the use of DB2 in educational institutions.

Website: http://channeldb2.com/oncampus
Members: 96
Latest Activity: 1 day ago

DB2 on Campus Resources and Videos


Table of contents
Presentation replays
Newsletters
DB2 online course (Videos)

Presentation Replays

DateTitleReplay link
03/09/09DB2 overview & PHP Seminar - Hosted by NUSLink
30/09/09DB2 9.7 - Technical overview - Hosted by Data Access (In Spanish)Link
12/11/09DB2 9.7 - Technical overview - Hosted by developerWorksLink

Newsletters

EditionView online
1st Quarter Edition1Q2009 (pdf, 2MB)
2nd Quarter Edition2Q2009 (pdf, 2MB)
3rd Quarter Edition3Q2009 (pdf, 2MB)
Join the DB2 on Campus Newsletter group to subscribe, provide feedback, or contribute to the next edition. We look forward to hearing from you.

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 TitleSize (MB)DownloadView onlineTranscripts
0The DB2 on Campus Program14.9Download now!Watch now!View
1The Role of DB2 Express-C in the IOD world (1 of 2)11.4Download now!Watch now!View
2The Role of DB2 Express-C in the IOD world (2 of 2)15.3Download now!Watch now!View
3Your opportunity - Ten steps to career success8.2Download now!Watch now!View

Technical Videos

#Lesson TitleSize (MB)DownloadView onlineTranscripts
0Lesson 0: Getting Started7.3Download now!Watch now!View
1Lesson 1: Installation and the DB2 Editions18.1Download now!Watch now!View
2Lesson 2: The DB2 Environment22.8Download now!Watch Part1! Watch Part2!View Part 1 View Part 2
3Lesson 3: Tools & Scripting50.3Download now!Watch Part1! Watch Part2!View Part 1 View Part 2
4Lesson 4: Architecture12.4Download now!Watch now!View
5Lesson 5: Connectivity20.5Download now!Watch now!View
6Lesson 6: Working with database objects21.1Download now!Watch now!View
7Lesson 7: Data movement23.5Download now!Watch now!View
8Lesson 8: Security14.1Download now!Watch now!View
9Lesson 9: Backup & Recovery21.7Download now!Watch now!View
10Lesson 10: Maintenance13.9Download now!Watch now!View
11Lesson 11: Concurrency & Locking19.3Download now!Watch now!View
12Lesson 12: SQL PL Stored Procedures30.0Download now!Watch now!View
13Lesson 13: UDFs19.8Download now!Watch now!View
14Lesson 14: Triggers20.3Download now!Watch now!View
15Lesson 15: PureXML SQL/XML XQuery42.1Download now!Watch now!View
16Lesson 16: Java, Ruby, PHP11.5Download now!Watch now!View
17Lesson 17: Troubleshooting14.9Download now!Watch now!View

DB2 on Campus Blog

New free ebook: IBM Data Studio for DB2

A new free ebook titled "Getting started with IBM Data Studio for DB2" is now available here!.

Data Studio is an eclipse-based tool that is replacing the DB2 Control Center and other DB2 tools. In addition to DBA tasks, you can also develop stored procedures (using languages such as SQL PL, PL/SQL, Java), SQL and XQuery scripts, and data Web services.

Download this free ebook and learn!

Enjoy,

Raul.
Continue

DB2 on Campus Newsletter - 3rd quarter is out

The DB2 on Campus newsletter summarizes many of the activities performed by students, professors, and IBMers around the world working/volunteering on the DB2 on Campus initiative.

The latest edition of the newsletter can be found here:
http://tinyurl.com/yatuhte

You can subscribe to the newsletter by visiting:
http://www.channeldb2.com/group/db2oncampusnewsletter

Enjoy! Raul.
Continue

DB2 Express-C 9.7.1 is out!

The 9.7.1 refresh of DB2 Express-C free database server is now available:
http://db2expressc.blogspot.com/2009/12/get-db2-express-c-971-now.html

Cheers,

Raul.
Continue

Waseda university using DB2 Express-C book for DB class

This October 3rd 2009, Waseda University in Japan started a DB2 class that is held every Saturday until late November. The course is part of the "Advanced IT Specialist Fostering Program” promoted by the Department of Education and Science Ministry in Japan. The materials are based on the DB2 on Campus workshop, as well as the "Getting started with DB2 Express-C" book, both of which were translated to Japanese.

Congratulations to IBM Japan to establish this great relationship and class at Waseda university!.
Continue

Story of two DB2 Student Ambassadors

Today the story of two DB2 Student Ambassadors in India has been published online in the Data Management Magazine. I'm very happy these two student ambassadors have been recognized by the IBM Information Champions program. I still recall how these two students became ambassadors. Early in 2008, I received an email from them inquiring about the DB2 on Campus program. At the time I had not visited India, so they showed initiative just by getting in touch with me. As time went on, the two students showed a lot of passion for DB2, and with a lot of enthusiasm, they started organizing events about DB2; therefore they were named DB2 Student Ambassadors, and established a DB2 User Group in their university. I was going to attend the inaguration ceremony, but on short notice, the mayor of the city decided to declare a holiday the day of my visit, which meant it would've been hard for students to use public transportation. Nonetheless, I spoke with Raghuveer/Pradeep on the phone, and congratulated them for their efforts. We also nominated them to the IBM Information Champions program, and I'm glad they were selected. Congratulations again to Raghuveer and Pradeep!

Raul.
Continue

Comment Wall

Comment

You need to be a member of DB2 on Campus to add comments!

Susan Visser 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.
Oswaldo F. Domejean 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
Chua Chuen Loy, Jackie 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.
Min Wei 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!
 

Members (96)

Indhuja pavan kumar ceeeni channeldb2 Raul sayak Ravindra Deshmukh Andrea Rodacki db2luw Pradeep Kumar G S agatha Rav Ahuja Udayachandran Willie isabelle claverie-berge Gustavo F. Ruiz JAYESH _BiLGe_ Virtue Min Wei Rafael Coss Vineet Jean-Marc Blaise Nuno Job sanjay Felix Rajesh Hiromiti Nakagawa Caroline Perlin Chua Chuen Loy, Jackie
 
 

Featured Downloads

New: Download DB2 9.7
Windows | Linux | Mac OS

Download FREE Database: DB2 Express-C

FREE Book: Getting started with DB2

DB2 on the Cloud

 

© 2010   Created by channeldb2

Badges  |  Report an Issue  |  Privacy  |  Terms of Service