My SQL query structure guide.

Back when I started to really sink my teeth into SQL at work, I made this guide for myself to illustrate how various terms could be used. I’m sure there are more terms, but these are the ones I use in my own work, bearing in mind that I’m not a database administrator or anything. I recently shared this guide with my colleagues at work, and now I’d like to share it with the internet. I’ve embedded it as a PDF, with a link below if you’d like to download it for your own reference.

Download SQL-Structure.pdf (PDF, 60KB)

If you have any suggestions or additions, please do let me know in the comments!



The next #OTalk (26/11/13) will be on my dissertation topic, video games in rehabilitation!

This is just a quick update to publicise the upcoming #OTalk, which will be on Games in Rehabilitation. As some of you may remember, I did my OT dissertation on virtual reality video games for rehabilitating children with cerebral palsy, so this is one of those talks I will come out of hiding to participate in.

The talk will be led by Rachel Proffitt (@Games4RehabOT), who has prepared this blog post to introduce the subject.

My dissertation was published back in March 2012, and at the time, my findings were summarised as such:

Cerebral palsy (CP) is a common childhood disability, with 1 in 400 babies born each year resulting in a diagnosis. Occupational therapists (OTs) aim to improve daily function while engaging children with CP in typical childhood occupations, such as play. Motion-sensing virtual reality (VR) interventions could allow children with CP to engage in realistic playful environments while practicing repetitive movements and developing functional motor skills. OTs need to embrace technology, but an evidence base is needed before new technology, like VR, can be used in interventions.

The evidence base for motion-sensing VR is emerging, with limited evidence to support the use of VR in practice. However, reviewed articles suggest that VR is possibly on par with current standard treatment for developing upper extremity motor skills. Stronger evidence is needed, but there is potential. No studies have used a VR system that tracks the movements of a handheld remote, only systems that track hands.

Not that you need to get this, but I have made my dissertation available to anyone who wants it at

I look forward to seeing some of you in my Twitter feed on Tuesday at 8pm, UK time!

Excuse me for the slight change of topic!

I started this blog while I was a student studying occupational therapy. Understandably, my posts centred around OT and being a student. The few readers I accumulated were also OTs or OT students, so now I feel a bit unsure as to how I should progress with this blog, or whether I should rather. I graduated almost a year ago with my degree in occupational therapy, and that seems to be where the OT adventure ended. I mean, I still apply OT principles and skills to my work, but I wouldn’t call myself an occupational therapist. And because of that, I feel like I’m letting down the friends and readers I’ve gathered along my journey.

However, this blog is ultimately mine, and about my life. I still want a space to update with my experiences. And I also want to keep the occupational therapy resources on here that many have found useful, such as my posts on reasoning types and models. I didn’t expect to have such great feedback from people about them!

So I hope you don’t mind my change of subjects, and I understand if people stop looking in my direction.

However, who knows, you might find you also enjoy programming, web design and the like! I didn’t think I would, but it inspires me to be able to create and improve technology for others to enjoy and use, and I do like a good challenge.