Following the database design championship playoff over on the PL/SQL Challenge, one player asked:
“Could you please advise me some resources (boooks, courses) so that I can improve?”
Of course I can! This is what I love to hear – people looking for resources they can use to increase their skills. This is information I’m sure others will benefit from, so here goes:
where topic = 'Database design';
The results of the first ever database design championship playoff were announced today. Huge congratulations to Sean Molloy, Pavel Zeman and Justin Cave for taking the top three spots. Also thanks to everyone else who’s taken part in the quiz, answering questions, adding to the discusions and pointing out my mistakes ;)
With this in mind here’s a some of the facts and figures from 2014’s database design quizzes, along with related trivia:
Here’s another six SQL brainteasers. This time the SQL is a clue to the power(s) of a superhero. Who is each superhero?
insert into body (skeleton)
set strength = 'superhuman'
where emotion = 'anger';
delete from powers
where location = 'near Kryptonite';
set exoskeleton = 'ferrous material';
where equipment = 'noosed rope of veracity';
insert into boy (more...)
There’s a problem most people who’ve had to do production datafixes have encountered at some point: you need to update a dataset. Unfortunately there’s a trigger on the target table. The trigger either prevents the update outright or just has some unwanted side effects (firing off a business process, etc.). The trigger is necessary for the application to function correctly, so you can’t just drop it.
How do you apply the changes?
You can (more...)
Some more SQL clues, this time to chocolate bars.
where capital_city = 'Taipei'
and 9 = roman;
where position = 4;
where age = 'prepubescent';
where crew = 'mutinous';
where that_is = 'Eboracum';
When you’ve got them, put your answers in the comments!
set employer = 'Oracle',
job_title = 'Database Evangelist'
where name = 'Chris Saxon';
That’s right, as of last week I’m now an Oracle employee! I’m joining Steven Feuerstein’s database evangelist team, a hugely exciting opportunity I’m honoured to be a part of. I’ll be joining Natalka, Dan and Todd in helping people customers get the most out of their Oracle databases.
My focus will be SQL and Oracle’s differentiating features (more...)
Another batch of SQL brainteasers. This time the clues are to the powers of mythical creatures – the task is to guess the creature!
There’s six in all, can you get them all? Put your answers in the comments!
set state = 'stone';
delete from creature
where appendage = 'head';
insert into creature (appendage)
insert into creature (appendage)
Continuing the nation theme, here’s another six SQL clues to countries. Can you get them all?
where business = 'abbreviated';
where contents in ('beef', 'kidney beans');
where actor = 'Tom Green';
where allegiance = 'Confederate';
where second_person = 'female';
As always, put your answers (more...)
Same concept, different theme. All the SQL statements below are clues to the English spelling of countries.
Can you get them all?
As always, put your answers in the comments!
where anaphylaxis = 'sexually transmitted';
where atomic_number = 47;
where able_to = 'influence PL/SQL';
Today celebrates one year of the database design quiz on the PL/SQL Challenge!
Here’s a look back at some of the stats for the quiz to date with some trivia related to the numbers :)