SQL GROUP BY and HAVING Example – Write SQL Query to find Duplicate Emails – LeetCode Solution

Write a SQL query to find all duplicate emails in a table named Person. +----+---------+ | Id | Email |…

Read More »

[MEGA DEAL] The Ultimate SQL Bootcamp Certification Bundle (98%)

Manage Tasks & Databases Like a Pro with 6 Courses on SQL Lite, Microsoft SQL, MySQL, PostgreSQL, Rest API, and…

Read More »

SQL as a Service

I’ve been thinking about this since 2007, somewhere around the time S3 was launched by Amazon. I even tried to…

Read More »

Read replicas and Spring Data Part 4: Configuring the read repository

Previously we set up two EntityManagers in the same application. One for the reads and one for the writes. Now…

Read More »

Read replicas and Spring Data Part 3: Configuring two entity managers

Our previous setup works as expected. What we shall do now is to get one step further and configure two…

Read More »

Read replicas and Spring Data Part 2: Configuring the base project

In our previous post we set up multiple PostgreSQL instances with the same data.Our next step would be to configure…

Read More »

Golang – The database/sql package

This post is part of a series where I do my best to organize my thoughts around Go: its paradigms…

Read More »

Coding Skills That Will Elevate Your Digital Marketing Career

Digital marketing platforms are teeming with an ever-increasing array of marketing software that you can use to stay competitive and…

Read More »

Fully working prototypes with Spring Boot and H2

We do use a lot of h2 with spring especially for unit tests. However instead of unit tests we might…

Read More »