This is the solution to the last SQL exercise from the series covering the students/disciplines field. The Third one from the series featured a WITH AS and GROUP BY clause, today we are working more on SQL aggregations such as : MIN MAX AVG Same Context Solution Here is what you should obtain as a […]

I hope that you played the game and try 1 or more SQL queries to answer the request from the Database Administrator provided activity. Once again we try on an approach easy to understand with a real world use case. Do not hesitate to post a comment to discuss about it. Context reminder Using your […]

Today we solve the exercise 3 by introducing a select statement and sharing our analyse with some arguments. I assume that you already loaded the context data in order to try the query.  The solution Let’s say that we only know about the name of the discipline to compute the query. This way we need […]

Following the DBA exercise 2, we continue the series with a new SQL select statement to compute. Context You will use the same data for this training exercise, you can also reuse the index you’ve likely introduced if you have been through the solution. Request Let’s say I want to retrieve the 3 best students […]

Following the exercise 1 on sql update, today we introduce a new problem to train yourself on a select query. The context provided will be valid for the 4 next exercises. Context 3 SQL tables with some relation which you can create using the below scripts. Student table Discipline Exam score Note : As of […]

Let’s answer the first exercise you have been working on (DBA SQL Update exercise). Before any update, you may use a SQL select query if you are not sure and with even more safety and furthermore if you are in production, then make a dump of your base before applying any update ! Here is […]