DBA – Solution to exercise 3

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 […]

DBA – SQL SELECT QUERY – EXERCISE 3

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 […]

DBA – SQL Select query – Exercise 2

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 Now some dummy data […]

DBA SQL Update – Solution to exercise 1

SQL Update exercise

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 […]

Want more information?

Related links will be displayed within articles for you to pick up another good spot to get more details about software development, deployment & monitoring.

Stay tuned by following us on Youtube.