Keep on Learning
A new ILO course has just been added. This one is an SQL workshop that is spread over 4 half-days in two weeks. ILO courses are the IBM courses that you take without traveling by joining a remote instructor via your computer.
Here are some details:
SQL Workshop - Multi Week Instructor Led Online
On completion of this course, you should be able to:
* Code SQL statements to retrieve data from a DB2 or Informix table, including the SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY clauses* Code inner joins and non-correlated subqueries* Use SQL arithmetic operations* Use scalar and column functions* Use UNION and UNION ALL* INSERT, UPDATE and DELETE rows* Code simple CREATE TABLE and CREATE VIEW statements
The DB2 books that you may wish to have to complement this course are:
* Understanding DB2(R): Learning Visually with Examples (2nd Edition)* DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition)
If you are interested in passing the DB2 9 Family Fundamentals certification exam (Test 730), you should notice that about 23% of the exam covers SQL knowledge. The book DB2 9 Fundamentals Certification Study Guide by Roger Sanders corresponds to the exam objectives and therefore covers the SQL that you need to pass the exam.
An interesting way to get a start on learning SQL is through the DB2 Games. Here are some details that I found on Kate Dawson's blog:
If you are a beginner, choose the IBM DB2 Detective GameIf you like watching crime investigation shows, this might just be the perfect game for you. Using a crime investigation theme, you will enforce your DB2 9 and SQL skills while learning relational database concepts and how they can be applied to real-life problems. I’ve played this game and highly recommend it.
If you have some existing DB2 skills, choose the IBM DB2 Business GameTry a “run your own business” scenario and put your DB2 and SQL skills to the test with the Business Game. Your company’s future depends on a key report needed to secure funds for a critical upgrade… can you put your DB2 skills into action and beat the game? Play now and find out.
Whenever I ask people who are SQL experts, they tell me that they rely heavily on these books:
* Graeme Birchall's DB2 SQL Cookbook* The SQL Reference for Cross-Platform Development* Product Docs for DB2 LUW* Product Docs for DB2 z/OS
When at conferences, I've noticed that the following books are popular:* Joe Celko's SQL for Smarties: Advanced SQL Programming Third Edition* SQL Demystified* SQL: The Complete Reference, Second Edition* SQL In A Nutshell, 2nd Edition* SQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipulation in SQL (2nd Edition)* SQL Pocket Guide
In writing this blog I realize how many resources are available for SQL. Clearly that means that it is a very important topic.... and one that you can continue to improve in.
Knowing SQL is a pretty important skill to have if you work with databases. This just in, a book for those just beginning to learn SQL: Simply SQL by Rudy Limeback.
I don't have a copy of the book yet, so I don't have personal experience with it yet. Here is the description from the book:
Learning SQL has never been easier. Packed with full color examples, this practical hands-on guide provides an easy to read step-by-step introduction to learning all about SQL - from syntax to security. Simply SQL is the perfect crash course for beginners.
Packed with full-color examples, Simply SQL is a step-by-step introduction to learning SQL. You'll discover how easy it is to use SQL to interact with best-practice, robust databases. Rather than bore you with theory, it focuses on the practical use of SQL with common databases and uses plenty of diagrams, easy-to-read text, and examples to help make learning SQL easy and fun.
Rudy Limeback is an independent consultant with over 20 years of SQL experience using DB2, SQL Server, Access, Oracle, and MySQL. He has written numerous articles on SQL for major online IT sites like TechTarget. Rudy is also a Web developer, one of the original evolt.org admins, with his own Web site since 1996. You can find more information at r937.com. Rudy lives in Toronto, Canada, where the weather allows you to play frisbee golf all year long.
For a list of other SQL books, see these blog entries.
Watch The DB2Night Show episode #5
Nov 12 11am EST
"SQL Snapshot Potluck Party"
with special IBM guest Chris Eaton
In this episode of The DB2Night Show, special guest Chris Eaton from IBM will share his TOP 10 Favorite SQL Snapshot commands, host Scott Hayes will throw in a few of his faves, and EVERYONE who contributes at least one of their own favorite SQL Snaps to the show will receive access to a FREE text/zip file containing ALL of the SQL Snaps on the Show! WOW - What a great way to build your toolbox of SQL Snapshots!!!
Click on the registration link for details on how to submit your SQL Snapshot to this potluck party.
Rumor has it that another special guest may make a cameo appearance as well - independent security consultant, published author, and now DB2 LUW Security blogger Rebecca Bond has threatened to share SQL commands with viewers that will help analyze DB2 Security! Have you discovered her new DB2 LUW security blog yet?
ALSO - are you following http://www.twitter.com/db2nightshow yet? YOU SHOULD BE! Set your "follow" to enable mobile messages - The DB2Night Show is now starting to give away Amazon.com gift certificates! Just be the first to directly and correctly answer DB2 trivia, sample certification, or other DB2 related questions, and you could win valuable prizes!
Visit http://www.DB2NightShow.com weekly for updates on upcoming shows and recorded replays. Here is a look at future shows that are currently being planned:
* Nov 20 "Free Application Development Tools - Data Studio vs Quest Toad" (tentative)
* Dec 4 "SQL Server versus DB2 LUW and FREE DB2" with special guests Paul Z and Leon K from IBM (tentative)
* Dec 11 "Managing the DB2 Workload Manager" with special guest Paul Bird from IBM --AND-- A REAL LIVE CUSTOMER that is using WLM! (confirmed)
* Dec 18 "Crunching the Numbers - Snapshot Analysis with Scott Hayes" We'll be looking at real data from real live production databases. (confirmed)
* Jan 8, 2010 "DEAR IBM, ..." Special guests include IBM senior executives and leaders Sal Vella, Tim Vincent, and Drew Bradstock. Send your praise, comments, feedback, questions, and requirements to the show! This is a virtual CAC of sorts with a guest panel of IBM DB2 LUW top shelf leaders! (confirmed)
Congratulations on reading this far! Here is your reward! The first five people to register for Episode #5 and who contribute a SQL Snapshot command will receive a $25 Amazon.com gift certificate in appreciation for your contribution to the Potluck Party.
The International DB2 User Group (IDUG) is a co-sponsor of The DB2Night Show.
DB2 9.7 brought the biggest infusion of SQL features since DB2 V2.1. In this presentation, learn about features that lead to a ten-fold reduction in enablement costs when Oracle-based applications are enabled for DB2. The virtual tech briefing covers the following:
Sheryl Larson top #DB2 SQL Expert, IBM GOLD Consultant, is our special guest on The DB2Night Show 8 October 2010 at 10am Central. Learn SQL tips from the master.
Free registration and details:
This week, the DB2Night Show is going "Cross Platform DB2" presented by Sheryl M. Larsen, IBM DB2 GOLD Consultant and President of SMLSQL (www.SMLSQL.com).
The Lessons Learned from SQL Performance Review presentation divulges discoveries and recommendations from various SQL performance review assignments across platforms. Come see if you have similar SQL performance issues and get the instructions on how to fix them. Issues discussed include non-optimal index design, access paths gone wild, residual predicates, misuse of SQL, excessive sorting, delayed filtering, lack of implementation of powerful new SQL features.
The DB2Night Show on Twitter: twitter.com/db2nightshow for the latest news about new episodes and interactive discussion. Use the hash tag #DB2Night in your Tweets.
If you’ve missed a show, remember that you can always get the recorded replay.
Congratulations to Serge Rielau for starting a new blog: SQL Tips for DB2 LUW
I think there are already 6 very complex and detailed entries... so if SQL is your thing... this is a blog you should follow.
Maybe I'll see if we can turn this into a book at one point in the future as well ???
*** NOTE: I've corrected the link.
svisser1 2700018UK9 Tags:  writing blogging presenting professional sql personal tedtalks tips 1 Comment 7,119 Views
It seems to me, given what I’m being sent in newsletters, that this is the time of year to give some thought to improving personal habits. The end of the year brings time for reflection on the year we just lived through and January is the perfect time to put in place new goals or plans for the coming year.
I like to discuss the articles I read with those who are closest to me at work and in my personal life, but in going through the list, I can’t see why these wouldn’t be of interest to a much larger audience. Here’s my list:
Five Things You Should Stop Doing in 2012 by Dorie Clark
I was drawn to this article by the title. Usually we think about what we’ll do better in the coming year, but doesn’t it make sense that you’ll need to drop something that you’re currently doing to fit in something you want to start doing. Face it, we only have so many hours in a day, so adding more to an already impossibly booked calendar makes no sense at all.
For me, email is becoming less relevant, so checking every 90 minutes makes sense to me and will allow me to focus on things that need full attention. I regularly unsubscribe to newsletters that are no longer interesting to me. I used to mail cards, but stopped a few years ago. There are still a few traditions that I take part in that could be dropped.
Dorie’s article points to another article that I liked:
Two Lists You Should Look at Every Morning by Peter Bregman
The lists Peter is talking about are 1) Focus list and 2) Ignore list. Doesn’t that make a lot of sense? I’m more of a social person than a gadget person, so Peter’s first story would never have happened to me. I’m more likely to make eye contact with everyone around me rather than giving my attention to my Blackberry. Figure out where you want to spend your time and consciously decide what you’ll ignore in order to focus on what you want to be focusing on.
Improve my Blogging Skills.
This one will only relate to those who are interested in blogging, but might actually coincide with the points above. Do you find that you repeat yourself over the course of a day or week, answering the same question, or giving the same advice to multiple people? If so, perhaps this content belongs in a blog where it can be shared among multiple people at once. If someone again asks the question, you can simply say.. read my blog!
Serge Rielau recently did this with his SQL Tips blog. Serge will benefit from writing this blog since he can put his effort into creating a well-written and thought out article about a topic that will benefit everyone who finds his blog and reads his tips. This is a much better use of his time than answering questions via email on a one on one basis.
If you are interested in blogging and want to learn how to do it the right way, the first time, I highly recommend this new book by Antonio Cangiano: Technical Blogging: Turn Your Expertise into a Remarkable Online Presence. I’ve been blogging for easily 6 years now and read this book as an official reviewer. I can tell you in all seriousness… that I learned a LOT. I haven’t put all the tips into practice yet, but I’m sure you’ll see my improvements over the coming year. Antonio has just created a blog about his book that you’ll want to subscribe to in order to get tips as he is able to share them: Technical Blogging.
I’m not sure if I’ve ever mentioned it in my blog or not, but I’m a huge fan of TedTalks.com. If you haven’t run across these videos yet, you’re in for a huge treat. TED is an acronym for Technology, Education, and Design. Three of my favourite topics in one. There are many recorded TED talks for you to find and watch that cover a huge range of topics. Here are a few of my all time favourites:
Jim points out a bad habit that most of us have: treating people as objects. He explains why this is not the way you should treat people and gives examples to make the point clear. I would suggest that this is a video we need to re-watch many times over the course of a year to keep ourselves on track.
The main thing I like about this video is the message that we need to master basic skills before we can try more complex ones. How many times do people try to jump ahead? Salman’s example about learning how to ride a unicycle after only a week on a 2-wheel bike shows the difficulty in not mastering lower level skills first. I also like how he’s developed something that is appealing to young children everywhere and makes learning seem like a game. I hope as a result, we’ll have a highly educated future population!
There are many TED videos for you to watch and enjoy. Warning: once you start, you may want to watch these videos all day long!
These tips are pretty basic and we all know them very well. Unfortunately, we tend to forget or ignore them. Do yourself a favour. Take these tips seriously and see if they make you happier.
There are two other books that I regularly mention that are related to professional development.
1) Sam Lightstone’s Making it Big in Software. I found this book to be a good read and very helpful in thinking about the direction your career is taking. Here are a few of the blog entries I’ve written since the book was published:
2) Roger Sanders’ From Idea to Print: How to Write a Technical Book or Article and Get It Published. Writing, presenting, and communication are the soft skills that are required for all of us to succeed. I remember writing a blog entry about these at one point, but can’t find it now. I’m hoping to work with a colleague in the coming year to pull together a comprehensive list of how to improve communication skills for technical professionals.
I hope you’ve enjoyed this list and are able to have a productive and healthy new year!
Congratulations to author and IBM Champion Tony Andrews on his new book:
DB2 SQL Tuning Tips for z/OS Developers
This well-organized, easy-to-understand reference brings together 102 SQL-related skills and techniques that any developer can use to build DB2 applications that deliver consistently superior performance. Legendary DB2 tuning expert Tony Andrews ("Tony the Tuner") draws on more than 23 years of DB2-related experience, empowering developers to take performance into their own hands - whether they're writing new software or tuning existing systems. He fully reflects the latest DB2 SQL programming best practices up to and including DB2 V9 and DB2 V10 on z/OS.
Buy directly from the publisher to save 35%, using discount code IBM8460 plus free ground shipping within the U.S.
If you're in Europe, you can purchase this book and many others in the IBM Press series at 35% off the retail price, plus free shipping in the UK and discounted in other countries.
More about the book:
We had 4 great presentations again this week! I’d really like to thank all participants... I know it isn’t always easy to present, but it is very important for us to share our knowledge with others!
Mikko - Summary Table Design & Monitoring
A little trouble following the story of the problem & solution. Summary tables are a huge topic. Well presented.
Umesha - Detailed steps to configure DB2 Distributed Data Facility (DDF) for z/OS
Good slides. Not practised? Went over time. Missing the “why”. Only “how” was covered in presentation.
Sreeharsha - High Data Availability: solutions and techniques
Environment clearly defined. Problem clearly defined. Presentation was well put togetehr and rehearsed. This is the way it’s done!
Armando - Dare to be Different (Against all Dogmas) SQL Performance Tuning
Be open minded on how to solve problems. You may find a creative solution that wasn't’ expected
Entertaining and engaging presentation with a great amount of style.
Congratulations to Sreeharsha, Armando, and Mikko for moving to the next level.
Be sure to join us next week to hear presentations from me, Martin, Klaas, and Martin. Your turn to evaluate us! Just for fun, of course. Come and have some fun!
Over 219,000 downloads of past DB2Night Show episodes! Congratulations Scott!!
If you missed the show, see the replay!
Be sure to fill out the survey when you do... you may be the lucky winner of a $25 certificate to use at Amazon.com. Perhaps there is a DB2 book you’d like to purchase?
As usual, IBM Champions are well represented at IDUG this year. Gain knowledge from this group of talented and hardworking people, who I consider IBM’s best friends!
I’ve done my best to pull out all the sessions that IBM Champions are taking part in at the
April 29th - May 3rd, 2013
If I missed any, please let me know and I’ll update this entry.
Monday April 29 - Full Day Educational Seminars
Tuesday April 30: Technical Sessions
Wednesday May 1: Technical Sessions
Thursday May 2: Technical Sessions
Friday May 3: Technical Sessions