Posted in databases

SQL for dummies

do-somethingkind-today-2

…and when I say dummies – I’m thinking about myself a while ago.

As a tester – I was a complete ignorant when it comes to databases. At the beginning of my career path SQL wasn’t so needed for me. It appeared here and there, but we’ve never had a true romance. But then… suddenly… at a glimpse… love exploded 🙂

No, well, to be honest, I just decided to stop being dummy and put myself together. And I- Kinga Witko – learned it by heart and – basically – by myself. How did I do that?

Today I’ll give you some useful tips, that might help all SQL beginners to start their database adventure. If I managed to learn it – why couldn’t you?

Where should I start?

Most of you probably know that the one and only knowledge source is W3Schools website. SQL course is there as well. It is vast, full of examples and great exercises. The whole necessary knowledge is there, but for me – it wasn’t enough and I lack some structure in that course.

Level up

Some time ago I started to get familiar with CodeShool. They have awesome online courses – each of them – which is basically adorable – has A SONG(!) about the language you’re learning. There is a song about SQL too :).

Their online course is divided into to parts: one of them is free -for the other one – ‘The Sequel to SQL’ – you have to pay a few $, but it’s worth it. Not only the knowledge is structured, but also supported with great examples and opportunity to go deeper into SQL.

That was it – nitty gritty online course. It was also just the beginning.

After the CodeSchool course I was familiar with SQL enough to get back to W3Schools and practice more. But it still wasn’t enough. I wanted to have some  real database to make and brake (in worst case scenario).

How to practice?

I was recommended to install a free database named PostgreSQL. It is easy to install and really great. When you go through setting up your own database, tables and so on, you’ll eventually learn a lot. Believe me.

If you’re a ‘mobile’ person like I am – I would also recommend you a great Android app (not very pretty, but valuable) – LearnSQL. I was going through several free Android applications for SQL learning and this one was the best. Well done, chaps!

Where to find correct queries?

Try this website. It’s about SQLite, but the whole queries stuff is represented by simple graphics and allows you to learn more and to get familiar with all useful possibilities that SQL gives you.

So – your mission for today. Stop being dummy as I was and learn SQL. It is not as hard as you might think. Good luck!

Should you find other great SQL learning-related online stuff please let me know 🙂

kkksqlu

 

Advertisements