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: 109
Latest Activity: Aug 27

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

Learn DB2 with a free online course and get a free DB2 Certification voucher!

This September I will be giving away 25 free IBM certification vouchers to take any DB2 certification exam at any time, anywhere in the world where there is a testing center such as Prometric.

If you already passed Exam 730, this could be an opportunity for you to take Exam 731 for free (for example), or you can choose any other exam.

In order to get the voucher, you will be asked to take a free online DB2 basic course titled "DB2 Essential Training I" that will be available to take at any time starting on September 13th, 2010.

If you have already passed Exam 730, the course may not be hard for you. It is based on the free e-book "Getting started with DB2 Express-C". It has 5 lessons which you can finish in one day or weekend. There will be one short assignment, one live review session with me for feedback (Web-based), and then a test.

If you are interested, please reply before Sep 1st, 2010 to db2univ at ca.ibm.com email with this information:

- Email
- Firstname
- Lastname
- Country

Use "Free certification voucher" as the title of your email for easy identification.

Once you send me this information, I will be providing you with a userID/password, and more instructions.

Cheers, Raul.

… Continue

Job internship opportunities at the IBM Toronto Lab.

Early this year we started the search for students around the world to fill up two 16-month internship positions at the IBM Toronto Lab. We were looking for the best Web developers to help with cool and interesting projects that would use Web services, mobile technologies (iPhone, Android), and Cloud technologies; all in conjunction with DB2.

Today I'm happy to announce that after a long selection and recruitment process, Marius-Gabriel Butuc from Romania (left on the picture) and Henrique Copelli Zambon from Brazil (right on the picture), have been selected.

These are their stories in their own words:

Henrique Copelli Zambon
I'm a Computer Engineering student from the University of Sao Paulo. I learned about this opportunity from my colleague Phillip Viana, who now works as a Software Engineer at IBM Brazil. I'm very excited about this opportunity because of the chance to work with cool technologies involving mobile platforms (iPhone and Android), Web services and cloud computing using DB2. After several phone interviews, and completing an assignment, I was delighted to be chosen. I'm looking forward to the work ahead!

Marius-Gabriel Butuc
Hi, I'm Marius, a 2nd year MSc Software Engineering student at the "Alexandru Ioan Cuza" University of Iasi, Romania. As soon as I learned about this opportunity from my professor, Dr. Sabin-Corneliu Buraga, I was happy to embark in an application process that made me discover great people who have now become both my colleagues and inspiration. Discovering an unsuspected match between my interests and most of the buzzwords surrounding the project - like Django, RESTful Web Services, interface development for mobile devices, Ruby on Rails and DB2 - I soon decided to take this opportunity. After my longest flight to date, and with a smile on my face, I'm eager to fulfill this great learning opportunity, in the middle of this great team!

More information about internships
Through the DB2 on Campus program we recommend students we've met in person at DB2 on Campus events, or referred from a teacher or IBMer.

Internship applications at the Toronto Lab start in mid-December for positions that start in May. Though 16-month intership work periods are preferred, there are also 4, 8 and 12 month internships. Preference is given to Canadian students, but everyone is invited. Most positions are for development and testing, where C/C++/Java skills are a must. DB2 skills are a plus.

Learn DB2 quickly from channeldb2.com/oncampus videos, and the free eBook "Getting started with DB2 Express-C".

… Continue

Data Studio webinar replay

If you missed the Data Studio Webinar held on July 27th, the replay is available here:
http://tinyurl.com/276y96j

Cheers, Raul.

… Continue

Free Data Studio webinar - Receive book for attending!

This Tuesday, July 27th, I will be delivering a free webinar about the free IBM Data Studio software. Receive a hard copy of the book "Getting started with IBM Data Studio for DB2" just for attending!

The presentation will show you all the possibilities available for database administration and development using Data Studio.

Details:
Date: Tuesday, July 27th
Time: 11:30am - 1:00pm EST
Link: https://de202.centra.com:443/GA/main/0000017cff6600000128b56cd8a024e2
(replay available from the same link)

Hope to "see you" there!

Raul.

… Continue

DB2 Express-C 9.7.2 is now available for download!

DB2 Express-C 9.7.2 is now available for download!. It is a full refresh of the free edition of DB2 with lots of new features and fixes including:

- Default parameter values in user defined functions (UDFs)
- Named arguments when calling user defined functions
- Ability to copy table spaces and SQL schemas between active databases using RESTORE with TRANSPORT option
- Auditing improvements with full replay of past database activities
- Improved performance and ease of development for .NET applications

Download landing page:
http://www.ibm.com/db2/express/download.html

Cheers, Raul.

… Continue

More…

Comment Wall

Comment

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

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 Ganapavarapu 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!