SELECT * FROM Posts WHERE Tags IN ('AdventureWorks')
It’s been a while since I published Day 1 questions and I guess it’s time to post the answers I came up with. That doesn’t mean my solutions are the only possibles, and in some cases I’ll provide more than one answer taking different approaches….
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…
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…
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…