SELECT *
FROM Posts
WHERE Tags IN ('Exercises')

Sep
14
2015

Day 1 @ AdventureWorks, some basics about SELECT, JOINS and more

The first day of this journey we’ll work on the most basic statement I can think of, the SELECT statement. Exercises are growing in difficulty, from the most basic to others a bit more complicated, where you’d get data from more than on table in the…

Continue Reading »

Sep
13
2015

Day 0 @ AdventureWorks, setting up AdventureWorks sample database

I wasn’t planning writing this post, because there are tons of resources available on the internet, but since I want to create a comprehensive series of exercises, starting from the very basic, I understand most people interested on doing them, might have limited…

Continue Reading »

Sep
9
2015

Welcome to your new office!

Hi there! Welcome on board, you’re the candidate we have chosen to cover the junior DBA opening. Does it sound any good? Perfect, it doesn’t really matter whether you have some knowledge on relational databases because here I’ll try to cover most…

Continue Reading »