But the weekly quizzes continue(d): SQL, PL/SQL, Database Design, Logic and most recently a re-started weekly quiz on Oracle Application Express, made possible by Insum. And Oracle Database technologists kept on using the site to hone their skills. We are rapidly approaching 1,000,000 answers on the site.
That all sounds good, right? So why is the title of this post "Check out the Oracle Dev Gym!"?
Because the PL/SQL Challenge has, for a while, been in dire need or a "reboot"; not just a redesign built around the massively improved APEX5, but also a rethinking of how this quiz platform could best serve the needs of the community.
Rethinking the PL/SQL Challenge
It was clear, especially from the popularity of the daily PL/SQL quiz, that developers like to actively test their knowledge, and compete with others.
It was also clear that lots of people didn't want to compete; they just wanted to learn more about core Oracle Database technologies. For example, some people told me they found the use of the word "Challenge" was off-putting: "I'm not good enough to play the quizzes."
In addition, when we kicked off the PL/SQL Challenge, we were starting from scratch: writing all new quizzes each. We still do that, of course, for our competitions, but we also now have a library of over 2,000 quizzes that the vast majority of Oracle Database developers have never taken.
Yet the current website was not at all geared towards making all those quizzes easy to take, outside of the context of the weekly competitions. Sure, we'd built a Practice feature into the site, but it was too "heavy" - too complicated, too many toggles and switches....what you see below, for example, is just one of five pages in the Practice wizard. Wow!
In fact, "complicated" is a good way to describe the site all around; it had gotten weighed down with lots of features that people only used occasionally, and got in the way of clean, easy access to our content.
So we decided to rebuild the site using APEX5, the Universal Theme, and all the new goodies in that fantastic rapid application development tool. We also decided it was time to come up with a new name.
But a new name requires clarity around what the site offers its visitors: what makes it unique. So I went off to a remote cabin in the mountains and meditated long and hard. Well, no, actually, I took lots of walks in a nearby park.
And after a while, I had this realization:
You don't visit the PL/SQL Challenge to:
- get answers to questions - that's what Ask Tom is for (and the OTN Forums).
- download or run scripts demonstrating features of Oracle Database technology - that's what Live SQL is for.
You go to the PL/SQL Challenge to keep your knowledge and skills fresh, current, strong.
In other words, you go to the PL/SQL Challenge like you'd go to the gym. So we decided to design the new version of the PL/SQL Challenge around the paradigm of a fitness center. We even have a cool, new logo:
Oracle Dev Gym - Early Adaptor
We are initially making the Oracle Dev Gym available only through the PL/SQL Challenge. We are doing this because the first and most important thing we need to find out is: how do our current PL/SQL Challenge users think of the new approach?
When you visit the home page, you will now see this image on the right:
Click on it to start exploring the Dev Gym.
The Dev Gym runs on the same platform as the PL/SQL Challenge. So when you answer the weekly SQL quiz there, it's the same (well, it sure as heck should be the same) as answering it the "old way".
But you can do so much more, including easily take quizzes on any topic you'd like; takes tests and coding challenges, even set up customized workouts through the Personal Trainer.
Yes, that's right. The Dev Gym comes with a Personal Trainer.
I am tempted to tell you more about the Dev Gym, but I really would rather let the site tell its own story - and find out what you, loyal user of the PL/SQL Challenge, think of the new approach. I cannot, however, resist sharing our Exercise page with you:
Tell Us What You Think!
In whatever way is easiest for you:
- Add a comment to this blog post.
- Write me an email: steven dot feuerstein at oracle dot com.
- Click on the Feedback link in the top right of either site and give us your thoughts (and bug reports).
- Feel free to tweet about Oracle Dev Gym. Please use #oradevgym.
Don't worry about hurting my feelings. Just give it to me straight.
Game Plan for the Dev Gym
We plan to take the next several months to gather feedback from our users and also go on a wild binge of writing quizzes and attaching them to videos, blog posts and more (check out Personal Trainer and our generated workouts for an indication of how that will improve the Dev Gym experience).
We will also invite you to help us build out all that content by contributing and reviewing content in a community repository being added to the Oracle Learning Library (more to come on that in August).
Then we will announce to the world with great fanfare and widespread acclaim: the Oracle Dev Gym.
So Is PL/SQL Challenge Going To Disappear?
Not at all!
The Oracle Dev Gym does not offer all the functionality of the PL/SQL Challenge. It takes a long time and careful thought to reimplement a site that has been built up over six years, often in direct response to user requests. We're just getting started.
In addition, I expect that there will be a "hard core" bunch of users who like the traditional site, don't like change, and are not interested in switching to a different style.
Finally, we will continue to use the PL/SQL Challenge to submit, review, edit and approve quizzes for playing.
Assuming we get a positive response to the Dev Gym, we will gradually shift more and more functionality over (but also keep the new site clean and simple). But the PL/SQL Challenge will be around for a long time to come.
Run, Don't Walk, To The Dev Gym
If you want to build stronger Oracle Database muscles, if you want to get more flexible when it comes to leverage features packed into SQL and PL/SQL, then head over to the gym and work up a good (virtual) sweat. We offer a tour of the Dev Gym on the site, but here's a link to a video tour in case you just can't wait.