One month and everything is fine... unless? After your last misadventure with Bob, you learn to be careful with Isolation in your transaction. Times flies, and you have been in charge of several small reports. And now you are in order of a much more ...
A brand new job Imagine you are a brand new Data Analyst at The Coffee Company. Like every Data Analyst, you know SQL well and are in charge of writing new queries to understand the business better. You want to discover the database and decides to wr...
Introduction Today we are going to see a really important concept when working with data and how you represent data. We are going to talk about Pivot Table indeed representing data in columns instead of rows is often more readable. Example Let's say ...
Introduction Indexes are something that you have most probably heard of and use in your app if you use a relational database in it. In this article, I will dive into the basic of indexes in SQL, and how we can create one index on data on our database...
Introduction Let's dive into ruby! There is a really useful gem that we do not notice but is kind of the savior for us developers. There is no suspense by the title it is obvious I talk about the DidYouMean gem which is now shipped into ruby directly...
Introduction Sometimes you reach a point where you connect dots between different things. Indeed I am currently digging into SQL, and for each new concept that I learned I tried to illustrate it with a ruby project. Here is the thing, I love ruby it ...