Query Databases Using Java Streams

In this article, you will learn how you can write pure Java applications, that are able to work with data…

Read More »

SQL Interview Questions and Answers – The ULTIMATE List

This is a summary of numerous important questions that have the potential to be asked in an SQL related job…

Read More »

JPA persistence.xml SQL script definitions

You can define and link to SQL scripts in a JPA persistence context definition that will be executed at runtime.…

Read More »

Testing Dockerized SQL Databases

One of the big advantages of using Docker for testing is that you don’t need to install the required dependencies of…

Read More »

SQL Data Access in Play using Scala

Today’s modern application frameworks come with apromise of easy sql data access. There is no wonder why we have so…

Read More »

Creating a SQL Database Project for Isolated Development

Introduction Working with a team of developers often poses challenges and causes frustrations with managing the development database. There are…

Read More »

Fixed-Point and Floating-Point: Two Things That Don’t Go Well Together

One of the more challenging aspects of software development can be dealing with floating-point numbers. David Goldberg‘s 1991 Computing Surveys…

Read More »

Apache Drill SQL Queries on Parquet Data

In this week’s Whiteboard Walkthrough Parth Chandra, Chair of PMC for Apache Drill project and member of MapR engineering team,…

Read More »

How to remove duplicate rows from a table in SQL

There are a couple of ways to remove duplicate rows from a table in SQL e.g. you can use a…

Read More »