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: 96
Latest Activity: 1 day ago

DB2 on Campus Resources and Videos

Table of contents

Presentation replays

Newsletters

DB2 online course (Videos)

Introductory videos
Technical 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)

Join the DB2 on Campus Newsletter group to subscribe, provide feedback, or contribute to the next edition. We look forward to hearing from you.

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

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

More…

Comment Wall

Comment

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

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!