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

Dockerize Maven Jdk8 & Jdk11 LTS

Today we will talk about a way to build a docker image shipping the following tools : Maven (latest version) OpenJdk 8 Openjdk 11 lts In a next article, we will see how to use this image in order to build a multi modules Java project. Finally we will go through the Continuous Integration process […]

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

Implement a Timer in JS ES6+

This page is more like an exercise on coding in Javascript. You should be able to learn about the bind functionality and how to deal with a timer via the setInterval function. The codebase is fully written using the syntax provided since 2015 with the ECMA script norms. You can browse the new features by following […]

Recursive files update by extension in Python

We are going to implement a script in Python to update recursively many html files at once. A more generic codebase has been built in order to take other similar cases. We will walk through the lines on this page. At any moment you can retrieve the Python classes onto Github Python snippets repository. I’ve […]

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

DBA – SQL update – Exercise 1

This it the first DBA (DataBase Administrator) exercise of a long serie, 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 each week. Before I implement a fully working interface to make you benefit […]

Git commands you should know

Today, I’ll show you the Git commands I’m using on a daily basis with my team mates. As for the Docker commands article, I won’t repeat the most basic ones, you can just browse the Git documentation or various tutorials that fit you on the web. Summary Git Status & logs File manipulation Commit cancellation […]

HTML Auto-Hiding menu with lock

We will build from scratch a navigation menu which can appear on mouse hover and auto hide otherwise.  Locking / Unlocking the menu will also be possible when clicking on a button on top of the menu. Checkout the result before diving into the code : Don’t bother the ugly template, just add some icons […]

Docker Network and Containers communication

When you deal with docker containers with some basic configuration without services nor docker-compose, you may need to test their interaction, that’s the topic of this tutorial. Let’s keep it simple. It’s an example of use out of the docker documentation. Demystification of network communication between containers  Let’s first review what network you have on […]

Docker commands you should know

Let’s start a Docker tutorial series by the most common commands you will ever type while working on your Dev-ops tasks. I assume that you’ve at least followed the Docker Guide onto docs.docker.com Here you will find some commands to manipulate your images, containers, services, volumes and networks. And for more details or deep learning, […]

Quick and Easy Magento 2 set up

We assume you know how to set up a virtualhost with Apache 2.4 and where to store your Magento 2 project directory. Here we provide a quick guide to set up a Magento 2.2 e-commerce website with a custom theme. This article will be more of a try/test to learn about the development of a […]

Working with blocks in Magento2 – Theme integration

Today we will dive into theming Magento2 by using blocks which are available on the client side (backoffice) and used within our templates and layout in our brand new Theme. Let’s start by creating a block from the backend of our website. Create a block on Magento2 Create a module to handle our block $ […]

Transfer wordpress posts from one database to the other

Sometimes you need to access your WordPress database in order to modify things quickly and “dirtily” you could use a plugin but when you enjoy dealing with source code without worrying about installing any third part applications, why not just doing it ! Where are our posts inside our WordPress Database ? Get yourself onto […]

How to build a wordpress theme in 5 steps

This tutorial is more like a personal reference of my own to quickly get myself on tracks while building a new WordPress theme. So if you need more details on building up your own theme, then you will have to follow the guildelines on WordPress.org. There is also a nice infographic highlighting the anatomy of […]

Adding array elements into a form using Zend 3

Form collection Zend 3 tutorial

You already know how to add elements to a form and attach filters and validators to them, but often you will need to add new elements dynamically or add several elements with the same name. In HTML it will end up with a name followed by square brackets [] : As an example check out […]

Ajax, Json and autocomplete form input example with Jquery

Autocomplete event - jquery ui example

We have a demo page for this so no worries about it – Today we implement several features to deal with a form input : Autocomplete of the input Ajax call to an external url using JQuery Parsing JSON data from the external url We will follow the tutorial on appending form inputs with Jquery […]

Appending form inputs within a form using Jquery

Append form inputs jquery

Learning by examples is the way we do and as we often ask us about JQuery tutorials, today we are adding a new one which will be followed with further integration such as Ajax calls and API programming. Example of appending form inputs inside a form JQuery offers such a powerful tools’ set, it would […]

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.