DBA Solution to Table creation exercise

Following the exercise on SQL Table creation, we provide here an example of implementation. Context No context so far except for the modelling of the data. Based on the given details we can picture some entities for our PDM (Physical Data Model) using JHipster JDL studio. You could use whatever PDM tool that suits you, […]

Bitwise AND operator with Programming implementation

The Bitwise AND (&) Operator allows us to process a multiplication on numeric values based on their binary representation bit per bit. Wikipedia actually explains it very well with examples covering the operations. Note that the operation must be applied to equal lengths numbers. Area of use We focus here on the bitwise and operator […]

DBA Exercise – Table creation

Today we will work on the creation of 3 tables with relationship. This one is not complex but you should be familiar with Database Normalization. You can read a brief about it on Guru99. More resources will be made available while browsing for the solution of this exercise. Context Request Build 3 tables covering the […]

Solution to SQL Aggregation exercise

Explain on mysql query

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

DBA Exercise – Aggregation

This is the last SQL training exercise of the series featuring the students business field. As a reminder, check out the 4 exercises : Select query DBA exercise – including the context data 3 best students select statement Group By Statement exercise More about Aggregation (current page) Context As usual load the context data provided […]

DBA – Solution to Exercise 4 on Select with Group By

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

DBA – Select Statement exercise 4 – Group By

DBA Database SQL

Yet another SQL exercise in the series using the same context data. This one is getting a bit more in depth in the business field, you might encounter such use case if you plan on making statistics about your students… You will again practice on a select statement with a group by clause. Context Please […]

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 – solution to exercise 2

Step by step we will solve the problem to the DBA exercise 2 I assume you’ve successfully loaded all data in your environment. Analyse We have 3 tables and we need to build a query which rely on fields present across all of them.  Obviously there is a need to make some SQL joins as […]

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 Note : As of […]

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

DBA – SQL update – Exercise 1

This it the first DBA (DataBase Administrator) exercise of a long series, in my opinion to be a better programmer, you need to practice regularly and the same affirmation stands for a DBA so I decided to introduce a new training exercise every week. Before I implement a fully working interface to make you benefit […]

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.