SQL
-
Software Development
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 » -
Enterprise Java
[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 » -
Enterprise Java
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 » -
Enterprise Java
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 » -
Enterprise Java
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 » -
Enterprise Java
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 » -
Software Development
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 » -
Career
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 » -
Enterprise Java
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 »