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: 159
Latest Activity: Feb 7

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	Introduction to DB2 Express-C	4.2	Download not available	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

DB2 Express-C 10.1 - Faster, more features, and still free!

The new version of DB2 Express-C, version 10, is out, and it's more flexible and powerful than ever before! Starting from the fact that it now allows you to use 4GB of RAM instead of 2GB, this will boost different database operations. The database size is still unlimited (compared to 11GB for Oracle XE, or 10GB for SQL Server Express). Speaking of Oracle, DB2 Express-C includes the "Oracle compatibility feature", which means that as much as 98% of code written for Oracle could run with no changes on DB2 Express-C!.

There are other cool new features in DB2 Express-C that you can use and configure with minimal effort. For example, "Time Travel Query" allows you to develop "time-aware" applications with minimal effort. This is helpful for audit purposes, governance, and to solve problems because this feature will let you query your data as it was in a given period of time that you specify. This can help you to easily and quickly create charts like the ones you see for stock prices, for example.

Check out the article "DB2 Express-C 10: Even more value" for more details, and download and try DB2 Express-C 10! It's free!

DB2 Express-C 9.7.5 includes Oracle compatibility

In case you didn't already hear, last week DB2 Express-C 9.7.5 was released! The main feature it includes is Oracle compatibility! Though this functionality was available for a while in other editions of DB2, it has just been made available in DB2 Express-C. Read more about it in the DB2 Express-C team blog!

Raul.

Just imagine...

About two weeks ago, BigDataUniversity.com launched a Hadoop Programming Challenge with the opportunity to give 3 students a free trip to Las Vegas (all travel expenses paid!) and participate in the Information on Demand (IOD) conference. Students completing the Hadoop Fundamentals I course would be given the details of the challenge. If you click on the "Participants" link in the course, you will see (as of today) that there are about 1000 people registered in the course. That means 3 out of 1000 would be traveling to Las Vegas... That is not a bad ratio, but if you think about it, it is very likely not all registered students will complete the course. Say 300 (30%) complete it. This means 3 out of 300 would make it to Vegas!... but wait ...it gets better. Those who complete the course receive the details of the programming challenge. The challenge requires you to write some code. My guesstimate is that maybe 30 students (10% of 300) will actually submit their program... So now we have 3 out of 30 flying to Vegas!. Now, in my experience judging submissions for other challenges, out of those 30, some submissions will be incomplete or disqualified, some would be too simple... So say 50% are like that....that means 3 out of 15 (or 1 in 5) could be in Vegas this October!

Now remember: This is not a lottery, this is a challenge; therefore you have a say on the outcome. If you put the effort and are creative we can see you at IOD!...moreover, you may network with executives from many companies including IBM and that may open the door to more opportunities!

Now that would be a good reason for participating...

Just imagine!

P.S: Yes, this post will make more people think about participating, but in my opinion, the ratio would still be very good!...I don't think 10000 people would be participating as the submission deadline is this September 30th!

Good luck! Raul.

DB2 Express-C 9.7.4 - Did you try it out?

Hello,

DB2 Express-C 9.7.4 is out for about a week now. I wrote an article in developerWorks titled "What's new with DB2 Express-C 9.7.4". Check it out for details!

Cheers, Raul.

DB2 University

Today, DB2 University (db2university.com) was made available (in beta) to the community. DB2 university is an online educational Web site delivering free and paid courses by experienced professionals and teachers.

Why DB2 University?
DB2 University represents many things:

Flexibility
Online delivery of education is a growing trend. It allows students to learn at their own pace, in the comfort of their home, or wherever they may be. It allows companies to have their employees gain skill at a lower cost (No traveling expenses required).

The DB2 community demanded a site like this, and finally we have it! DB2 University delivers courses about DB2 and other technologies online, in either self-paced or Instructor-led format. The site has a sample of courses right now that you can check out:

- SQL Fundamentals I
- DB2 Essential Training I
- DB2 Essential Training II
- Data Studio Essential Training I

Some of these courses have been translated to different languages (Portuguese, Spanish, Russian); and they all have a corresponding book that can be used as a reference. For example, the SQL Fundamentals I course is based on the Database Fundamentals eBook just published; the DB2 Essential Training I & II courses are based on the Getting started with DB2 Express-C eBook, and the Data Studio Essential Training I course is based on the Getting started with IBM Data Studio for DB2 ebook.

Books, videos, online delivery... A complete set of materials in different formats!

Quality, easily consumable material
Before DB2 University was released -- and this applies to internet content in general -- you could find a lot of material about DB2 on the Web; however, in many cases it was hard to make sense what was relevant or not. Some of the material out there is obsolete, incorrect, or too complex; and this would cause you a headache more than helping you. Moreover, there is no logical flow when reading this material. You just get an ocean of information that is hard to digest.

At DB2 University, we use Moodle open source course management system (CMS). A CMS helps instructors organize the material in a relevant and easily digestable way. Now students can go through the material with a logical flow that will save them time in their learning. They can also be confident the material is relevant, up-to-date, and of great quality, since it's been prepared by experienced professionals and teachers.

The Moodle version running on DB2 University was enabled to use DB2 as its database server. This means Moodle is helping DB2, and DB2 is helping Moodle!

Recognition
Everyone taking a course likes to have some document to attest they completed the course. At DB2 University, we offer completion certificates to all students passing a course.

A real-life reference: Moodle using DB2, DB2 on the Cloud
Every time you access DB2 University you are seeing DB2 in action!. As mentioned earlier, Moodle CMS was enabled to run on DB2. Moreover, every time you access DB2 University, you are also seeing DB2 in action on the Cloud!. Yes, DB2 University was implemented on the Amazon Cloud. We manage it using Rightscale, a Cloud management platform. Working on the Cloud also enabled us to set up a disaster recovery site at a low cost, so we use a different elastic cloud computing (EC2) instance to run a DB2 Stand-by server in a HADR configuration.

There are many more things to say about DB2 University and how it was implemented. A developerWorks article published on January 13th has more details. It is the first in a series of articles describing how DB2 University was implemented, including it's open-ID sign up capabilities (that is, how ChannelDB2/Facebook/Yahoo/Google IDs can be used to log on to DB2 University), and also using an Android phone to access your marks at DB2 university.

I would like to end this post by inviting you once again to try out DB2 University. Right now we have a special promotion where the top 20 students passing some of the courses offered will receive free or discounted IBM Certification exam vouchers, and also free hard copies of books!

We would like to hear any feedback you may have about the site so we can improve it!. Moreover, if you would like to host your quality material in our site, please let us know! It could be hosted either as a free or a fee-based course. It's up to you!

Enjoy! Raul.

More…

Comment Wall

Comment

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

Comment by Harishkumar Baburao Pathangay on July 6, 2013 at 12:50pm: Hi,

I have created a YouTube channel providing a new learning experience through video tutorials for DB2 on LUW. Also you will find few Tips n Tricks videos.

Keep watching and Happy Learning.
URL: www.youtube.com/db2luwacademy

I thank you all for the support and also provide your feedback's and suggestions to improve the learning experience.

Please feel free to reach me at db2academy@gmail.com.

Thanks,

Harish Pathangay

Comment by Susan Visser on June 24, 2010 at 1:47pm: How do YOU like to learn? Take this survey and let us know! http://bit.ly/bL2OZN

Comment by Vinay Bharadwaj on June 9, 2010 at 10:44am: Hi

I am Vinay, DB2 Student Ambassador at the University of New Mexico, Albuquerque, NM. Announcing the group "DB2 in USA", all DB2 users and developers are welcome to join and contribute to the group.

Link : http://www.channeldb2.com/group/db2inusa

Thank you
Vinay

Comment by Susan Visser on April 12, 2010 at 5:27pm: Start or manage your career in the software industry: http://bit.ly/cPtFQz

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!