DB2 on Campus

Information

This group is for people interested in the DB2 on Campus program

Website: http://channeldb2.ning.com/group/db2oncampus
Members: 89
Latest Activity: 11 hours ago

DB2 on Campus Resources and Videos

The DB2 on Campus Program is a project designed to promote the use of DB2 in educational institutions. You can get more information about DB2 on Campus program, or join the DB2 on Campus group at facebook.com

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

Edition	View online
1st Quarter Edition	1Q2009 (pdf, 2MB)
2nd Quarter Edition	2Q2009 (pdf, 2MB)

DB2 on Campus Videos

Learn DB2 in one day with the help of the videos listed below. Use them in conjunction with the FREE online DB2 Express-C book 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

Discussion Forum

What's the full procedure ? 3 Replies

Started by Indhuja. Last reply by Indhuja Oct 31.

DB2 on Campus Blog

Loading feed

Comment Wall (3 comments)

Add a Comment

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

3 Comments

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!