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

DB2 on Campus Resources and Videos

 

 

Table of contents
Presentation replays
Newsletters
DB2 online course (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.

 

 

 

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

Loading… Loading feed

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!
 

Members (159)

 
 
 

Try BLU Acceleration on Cloud

© 2014   Created by channeldb2.

Badges  |  Report an Issue  |  Terms of Service