How To Study And Pass The PSD-I Assessment From Scrum.org

The Scrum.org Professional Scrum Developer I assessment is a 60 minute time boxed test where you answer 80 multiple choice type questions. It costs $200 to take and the passing score is 85%.

I took the test September 14, 2016 and passed. My Score was 71 points (or 88.8%)

Scrum.org PSD-I Certificate

Here’s how I studied:

Install Recoll.

Create a directory  where you store any studied Scrum.org document. Setup an appropriate indexing strategy so that Recoll search is rebuilt every time you add a new document to your Scrum study folder.

Study the following documents:

Save the above documents into your study folder.

Read posts in the Scrum.org forum.

Once a day, for at least a few weeks, do the SCRUM OPEN, PRODUCT OWNER OPEN, and DEVELOPER OPEN assessments. When you finish an open assessment it will let you print a summary of your results. Save every summary in your study folder.

Keep doing the open assessments until you consistently get 100% every time

Keep doing the open assessments until you’ve seen every possible question.

The day before doing the test, take the time to create a single open assessments master document. Copy, paste (and study) all the information from all the open assessment summaries into the master document. When creating your master document avoid duplicate questions. Having to search through duplicates will slow you down.

Ignore any resource that doesn’t come from Scrum.org

When you’re ready, pay money to do the test, use your Recoll index to search for help when you don’t know an answer.

Good luck.

Spellcheck English + French At The Same Time On Android

On Android you can spellcheck multiple languages by switching to them, on-the-fly, using the space bar:

spellcheck-settings-04

To set up this feature go into settings under “Language & input” then select “Google Keyboard:”

spellcheck-settings-01

Select “Languages:”

spellcheck-settings-02

Disable “Use system language” and select the languages you want to spellcheck against:

spellcheck-settings-03

Merci!

MySQL Dump Full Structure, Partial Data, With Triggers & Routines.

You want to do a MySQL dump. You want the entire structure of the database but you want to exclude some tables because they are too big, have sensitive data, or other reasons. Your MySQL database has triggers, routines, and all that good stuff because it’s 2016.

When I went looking for a solution I read a tutorial that wrongly suggested dumping triggers and schema together in the first step. The problem with this approach is when you import your data, the ON INSERT triggers are executed, and this can lead to primary key conflicts or other weird issues. I learned the hard way.

A better way:

  • Schema first
  • Data next
  • Triggers and routines last
mysqldump --no-data --skip-triggers DATABASE > FILE.sql

mysqldump --no-create-db --no-create-info --skip-triggers --ignore-table=TABLE1--ignore-table=TABLE2 DATABASE >> FILE.sql

mysqldump --no-create-db --no-create-info --no-data  --routines --triggers --skip-opt DATABASE >> FILE.sql

Good times.

Free Online Scrum Training

These Scrum Training Series videos are my favourite. The site also offers a nice Scrum reference card. Choice quote:

Doing Scrum, or Pretending to Do Scrum? Scrum’s relentless reality checks expose dysfunctional constraints in individuals, teams, and organizations. Many people claiming to do Scrum modify the parts that require breaking through organizational impediments and end up robbing themselves of most of the benefits.