SQL
-
Core Java
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 » -
Software Development
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 » -
Enterprise Java
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 » -
DevOps
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 » -
Scala
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 » -
Software Development
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 » -
Software Development
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 » -
Software Development
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 » -
Software Development
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 »
