Keep on Learning
It is usually taboo to talk about how much someone makes, but still, everyone wants to know where they stand in terms of earning potential.
Certmag.com does an annual survey to find out if certifications increase a person's pay or not. The surveys have shown that a person who holds a certification is generally better paid than a similar individual who is not certified. The next logical question is, which certification results in the highest pay?
According to results from last year's survey, certmag says that IBM DB2 certified DBAs earn more than Oracle or Microsoft DBAs!
Enterprise Systems have also done a survey and have recently published their finding:
According to this, DBAs make more than most other IT professionals. Not a surprise, really given the skill and expertise required to do this job. The article also agrees with the findings from certmag.com and lists DB2 as the database where salaries are highest. Actually, DBAs on IMS systems are THE highest.
So, be proud of the fact that you work with DB2 and be proud of your certifications!
If you aren't yet using DB2 or certified, does this help convince you? I hope so!
A fellow blogger (Bill Higgins) pointed to an interesting article by Joan Houlihan that gives tips on how to become an author. I thought I'd point to this article in my blog as well.
My job is similar to Mary O'Brien role, but I focus on Information Management titles.
One of the things that Joan mentions in her articles is "Despite the prevalence of online communications, book sales have steadily increased over the past decade
I'm not sure that I've seen the same trend, but I hope to see an increase in book sales! I'm planning to change a few things in the DB2 library for the next release to help achieve this. I can't reveal my strategy at this time, but maybe in the near future.
svisser1 2700018UK9 3,838 Views
DB2Night Show: Nov 19: What's NEW and COOL with DB2 LUW, and a peek into the crystal ball!
Nov 19, 2010
11:00 - 12:00 EST
Register: click here.
If you have ever attended a DB2 related conference, you have probably attended a presentation given by George Baklarz. George keeps us all tuned in to DB2 LUW's newest and coolest features, and frequently shares his crystal ball thoughts on "what's coming" as well.
In this episode of The DB2Night Show, George has agreed to join us as special guest. By the end of 2010, he will have flown about two billion miles around the globe. We're not sure how he has found the time to join us, but we are awfully darned appreciative.
Participate as a studio audience member as one studio audience member will be randomly selected to win an electronic gift certificate. If you can't make the scheduled time, register anyways so that you get information about recorded replays. Lastly, please forward this invitation to at least 5 of your friends! Thank you!
On top of being a very successful presenter, George is also a very successful author of 10 books about DB2. I’m very proud to say that I’ve been alongside George for every single book and am glad that his is such a prolific author. Let’s hope that I can continue to convince him to write books despite his insane travel schedule!
First, let's look at the intended audience for the test as well its structure.
The target audience is a database developer who has an in-depth knowledge of:
* all common programming tasks
* embedded SQL programming, ODBC/CLI programming, or Java programming
There are 63 multiple choice questions on the test and you are required to get a score of 57% or better to pass. The following 7 sections are on the test:
* Database objects and Programming Methods (13%)
* Data Manipulation (26%)
* Embedded SQL Programming (11%)
* ODBC/CLI Programming (13%)
* Java Programming (13%)
* Advanced Programming (16%)
* User Defined Routines (8%)
Section 1: Database objects and Programming Methods (13%)
This section tests:
* Your ability to identify the different database objects that are available with DB2 UDB.
* Your ability to identify the naming conventions used for DB2 UDB objects.
* Your knowledge of the constraints available and your ability to identify when and how NOT NULL, default, check, unique, and referential integrity constraints should be used.
* Your ability to identify how operations performed on the parent table of a referential integrity constraint are reflected in the child table of the constraint.
* Your ability to identify the more common privileges used when developing or running DB2 UDB applications.
* Your knowledge of the various special registers available and your ability to obtain the current value of any special register using SQL.
* Your ability to identify the similarities and differences between static embedded SQL and dynamic embedded SQL.
* Your ability to identify the difference between CLI/ODBC, JDBC, and SQLJ.
Today's assessment question:
Given a table created using the statement:
CREATE TABLE abc.stuff (i INT)
A user called XYZ is to be enabled to access data from table ABC.STUFF using an implicit schema.
Assuming the necessary privileges have been granted, which of the following statements issued by user ABC will provide this result?
A. CREATE ALIAS stuff FOR abc.stuff
B. CREATE VIEW abc.stuff FOR xyz.stuff
C. CREATE ALIAS abc.stuff FOR xyz.stuff
D. CREATE VIEW xyz.stuff AS SELECT i FROM abc.stuff
Where to find the answer:
1) Chapter 2 of Roger Sanders book: DB2(R) Universal Database V8.1 Certification Exam 703 Study Guide
2) Tutorial: http://www.ibm.com/software/data/education/selfstudy.html#2.
3) Product document: search on 'alias'
Tip: If you are an employee of IBM, search for Roger's book on Books 24x7.
Susan Visser[Read More]
875 exams taken after 4 days! Very steady business. We offer DB2, WebSphere, Lotus, Tivoli and Rational exams, but clearly this is a DB2 crowd! We offer all the exams to help people become cross trained in all SWG products.
I had dinner with Roger Sanders last night. I first met Roger years ago just after he published his first book about DB2. I'm glad that I was able to work with him on the three Exam Study guides that he wrote for our Version 8 exams and I'm working very hard to get more book projects for Roger.
Roger tells me that he gets lots of reader feedback about his sample questions and how useful readers find it that he explains the reason an answer is correct. I'm sure that now that IBM charges $10 per take on the assessment exams, more people will choose to use Roger's books for his assessment questions as well as the content of the book.
One of the projects I got involved with in January was to set up a program for Russia to get more people trained and certified. I suggested that we translate Roger's Exam 700 Study Guide along with a few other materials. I am happy to say that Roger's book is now available in Russia and that Roger has been invited to run a crammer course to a select group. It is great how quickly we were able to make this initiative a reality! If we are successful in getting people certified at the entry level, we'll continue the program and focus on Exams 701 and 703.
I was also privileged to meet several people from Brazil this week. We talked at great lengths about the various ways we can increase certifications there as well. I fully believe that you can't just throw a test at someone and hope that they pass. You need to build a program around the test, similar to what we are doing in Russia: a book that people can read and keep to refer to over time, hands on experience, and if possible, training sessions. And then the exams. I am very hopeful that we will be able pull something together for Brazil and other countries as well.
I'm writing this entry on Friday morning at 9:00 am and we have a room filled with people who are currently taking an exam and another room full of people waiting to take their exams before heading home. It has been a very successful week and I look forward to working at next year's conference planned for Dallas in August 2006.
As of this morning, ChannelDB2.com now has 471 members....much lower than I expected. But that can change, right?
Why should you join?
As Willie says:
Believe it or not, DB2 is now into "social networking" with the ChannelDB2 web site. ChannelDB2 is a DB2 community (all flavors of DB2 and all things DB2) featuring content such as DB2 related videos, podcasts, blogs, photos, resources, etc... for Linux, UNIX, Windows, System z, and System i. It's your one stop shopping for just about anything you might be looking for in DB2 land.
I agree with Willie and suggest that after you become a member of ChannelDB2, that you join one or more of the following groups:
DB2 in Books
I've listed every published book in this discussion group and I encourage you to use this as a way to reach the authors or to find related information such as events that the authors are taking part in, podcasts or webinars that are related to the book topic, and so on....
DB2 for Linux, UNIX, Windows
This is a place where you can find information about anything related to DB2 for LUW. Feel free to add discussions for areas that are not yet created. I've created a few discussions that you might find useful, including information about the latest ILO courses or current promotions that are being offered.
DB2 for z/OS
Same as the one above, only content is specific to the z platform.
I just started this group to be a collection of the many things that are happening at the IOD conference. With so much information being sent on a daily basis in regards to the conference, isn't it nice to have one spot that collects that information? And better yet, this is a place where you can share your thoughts on events that are taking place at the conference.
What do you think? Worth checking out? I hope so. When you're a member, make me a friend! A girl can never have too many friends!
Yesterday I took part in an event that our skill resouces team ran to give information about certification testing to our 2500 employees of the Toronto Lab. I thought I'd share with you a few of the tips that I provided to these attendees.
Select desired certification by visiting http://www.ibm.com/software/data/education/cert/
This site was recently re-launched and is the best place to start to find out everything you will want to know about getting prepared to take a DB2 certification exam.
* Certification Roadmaps
* Complimentary Certification Tutorials
* Exam Preparation Documents
* On-line Assessment Exams
* Certification Guides
* Certification Process Checklist
Recommended Study Materials for DB2 Certification Exams
Exams 700, 701, and 703 each have a study guides written specifically for the exam. See http://www.ibm.com/software/data/education/bookstore/certify.html for a list of the books that are available to prepare for exams within each job role.
DB2 UDB V8.1 Certification Test 700 Study Guide by Roger Sanders
DB2 UDB V8.1 Certification Test 701 and 706 Study Guide by Roger Sanders
DB2 UDB V8.1 Certification Test 703 Study Guide by Roger Sanders
The series of study guides by Roger Sanders is recommended for those who need a quick refresh of the exam material. He includes sample questions and has focused the books on just what you need to pass the exams.
DB2 UDB v8.1 for Linux, UNIX, and Windows Database Administration Certification Guide, 5/e by George Baklarz, Bill Wong
DB2 UDB v8.1 Application Development Certification Guide, 2/e by Steve Sanyal, Kevin Gashyna, David Martineau, Mike Kyprianou
Advanced DBA Certification Guide and Reference for DB2 Universal Database v8.1 for Linux, UNIX, and Windows, 1/e by Dwaine Snow, Tom Phan
The series of Certification Guides is recommended for those who need to prepare for the exam, but also wish to have information beyond the exam for learning or reference purposes.
CASCON, The Centre for Advanced Studies Conference, is taking place this week in Toronto. CASCON is the premiere computer science and software engineering conference in Canada. This conference is an excellent venue for exchanging ideas, showcasing results, experiences and tools, and networking with researchers and practitioners from academia, industry, and government.
Here is a link to give more information: https://www.ibm.com/ibm/cas/cascon/
Yesterday I had lunch with Stephen Perelgut who ran a workshop on popular technologies such as blogging, podcasting, and RSS feeds. Stephen is running two sessions this week, and both are full to capacity. I was too late to sign up for either of his workshops, so I'm not able to attend. Stephen tells me that he may run another session in the Toronto Lab for employees in a few months.
After lunch I met with Dr. Imran A. Zualkernan who is working on a technology to turn flow diagrams into test questions. Dr. Zualkerman showed me this technology in action using a flow diagram for a few DB2 UDB task. Seems interesting, but I don't think it's ready for prime time use yet. I'll provide some user scenarios to Dr. Zaulkerman so he can further test this technology. Using this technology might be helpful when creating sample study questions. We'll see.
I spent the afternoon in a Women in Technology Workshop: Tenth Workshop on Women in Technology: Global Transformation for Women & ICT.
This workshop discussed the ongoing action needed to transform the global position of women in Information and Communication Technology (ICT). The speakers/facilitators included: Claudia Morrell, Kelly Lyons, Sophia Huyer, and Ann Holmes.
It is conceived as a follow-on to the First International Symposium on Women and ICT that took place June 12-14, 2005 in Baltimore, Maryland, USA. Two hundred and fifty participants, representing six continents and 29 developing and developed countries, including leaders from business, government, non-government agencies, and education, gathered to explore concrete ways to increase girls' and women's participation and leadership with Information and Communication Technology in order to effect economic, social, and political change.
The focus of the CASCON session was to discuss the messages that should be presented at the second United Nations World Summit on the Information Society, Tunis 16-18 November 2005. The goal is to change the gender disparity evidenced in Women and Information Technology: Fast Facts at http://www.umbc.edu/cwit/fastfacts.html and planning for continuing action.
Some interesting facts:
* Computer-related occupations, 2004, U.S.
* Computer and information systems managers, 31.0% female
* Computer scientists and systems analysts, 29.4% female
* Computer programmers, 26.7% female
* Computer software engineers, 25.0% female
* Computer support specialists, 29.7% female
* Database administrators, 33.6% female
* Network and computer systems administrators, 20.3% female
* Network systems and data communications analysts, 21.9% female
* Operations research analysts, 43.0% female
Source: U.S. Bureau of Labor Statistics, 2005
The database area has had very highly ranked women running the business until recently: Janet Perna and Pat Selinger. Both of whom have recently retired.
I can't say that I've overly passionate about this subject yet, but it does bother me to hear that fewer and fewer women are going to university and even fewer are choosing technical degrees. There are lots of studies that try to figure out the reason for the decline as well as many programs in place to help. One of the things that we discussed yesterday was the need to figure out what programs exist around the world and to share these ideas so we can make programs accessible to people every where in the world. A portal is being designed, so hopefully that will help.
Kind of in line with this topic, last night I volunteered to help out at a Girl Guides event in support of a technology badge. This is one of the many programs that IBM takes part in to encourage girls to take an interest in technology.
Make sure you bookmark the ChannelDB2 website to see the very latest videos that are uploaded. Rav Ahuja filmed me when we were in Las Vegas for the IOD conference last year where I spoke about the latest releases of books related to IM products. Here is the link: My Video.
Personally I'm not happy with how it turned out... but my co-workers tell me that it's fine. (Do we ever like seeing ourselves on video?)
I asked Rav to make an update as there have been several new books published since that recording was made. He suggested that I simply turn the camera on myself, film a new segment and upload it. I think I'll do that! And I encourage anyone else who feels that they have something to share to do the same.
I also noticed that there is a place to put photos as well. I have a few photos from several conferences that I'd also like to share, so I'll add them there too.
Also see my blog on PlanetDB2.com.[Read More]
On Friday I dropped into a bank to deposit a royalty cheque. The bank teller was quite interested to hear that I am an author and that I help others publish books. Even though I told her that I have a very narrow field: technical books about DB2, she still wanted my card and has followed up with a few questions about how to get started.
She's from Croatia and would like to write a travel book for those traveling there. I have no idea as to where to start for this type of book, but I gave her the same advice that I would give to anyone writing any book. Here is what I would say for someone wanting to write a technical book:
1) Search on amazon to see what books are available. Read the TOC or Index if you can and see if it would be different than the book you have in mind. For technical books, also check to see if there a redbook that covers the topic.
2) Read the comments from the readers to see what people like or dislike about the various books. Use this information to help you decide on what you want to focus on.
3) Look into buying a book about writing a book. I found several on amazon for writing travel books, but here's what I'd suggest for technical books:
Developing Quality Technical Information: A Handbook for Writers and Editors (2nd Edition)
4) Consider checking out blogs on the topic you are interested in. Do the blogs exist? Are you considered an expert or knowledgeable in the area? Would you start your own blog? Apparently some people are putting their draft chapters in blogs to be reviewed and critiqued before the material is finalized and published.
5) Consider writing an article to be published in a magazine or online. Quite often you will be paid for the content. This will help you make a name for yourself in the topic area.
6) Answer the following questions, as these are likely the questions a publisher will ask you to determine if they want to take the risk on your book:
1. Working Title:
2. Brief Description: In one or two paragraphs, describe the work, its purpose, rationale, and approach.
3. Outstanding Features: Briefly list what you consider to be the three (or more) outstanding, distinctive or unique features of the work and why.
a. Identify the intended target audience.
b. At what level is the book targeted (beginner, intermediate, advanced)?
c. Is it primarily descriptive or qualitative, elementary or rigorous, etc.?
d. Estimate the size of the target audience and ways to verify the estimate.
e. Identify some of the obstacles faced by this target audience when it comes to mastering the proposed topic.
5. Status of the Book:
a. What portion of the material is now complete?
b. When do you expect to have a complete manuscript?
c. If chapters are not available now for review, when will they be ready to submit?
d. How many and what type of figures (e.g. drawings, half-tones, charts, photos, etc.) do you plan?
e. If producing the material electronically, what hardware, operating system, software, macros, etc. will you be using?
6. Competition: Consider the existing books in this field and discuss their strengths and weaknesses individually and specifically. This material is written for reviewers and not for publication, so please be as frank as possible.
a. Identify competing titles currently available, noting the author, title, publisher, price, page count, and year. Compare each to your proposed work, noting the similarities as well as the differences.
b. Indicate why the work you propose to deliver is unique. Compare and contrast your credentials to the credentials of the authors of the other books.
c. If there are no books on this subject, explain why you believe there still is market interest.
Also visit http://www.ibm.com/ibmpress for a proposal template that you can download as well as answers to frequently asked questions.
Don't get scared off by the number of steps listed above! Writing a book is very possible and the thing you need most is passion for the topic!