Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

The Best of the Week (July 28): SQL Zone

DZone's Guide to

The Best of the Week (July 28): SQL Zone

· Java Zone ·
Free Resource

Verify, standardize, and correct the Big 4 + more– name, email, phone and global addresses – try our Data Quality APIs now at Melissa Developer Portal!

Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone (August 22 to 28). Here they are, in order of popularity:

1. JPA Hibernate Alternatives: When JPA & Hibernate Aren't Right for Your Project

Today we will talk about situations in which the use of the JPA/Hibernate is not recommended. What problems do JPA/Hibernate present, what are some solutions, and what alternatives do we have outside of the JPA world?

2. A Wonderful SQL Feature: Quantified Comparison Predicates (ANY, ALL)

Have you ever wondered about the use-case behind SQL’s ANY (also: SOME) and ALL keywords? You have probably not yet encountered these keywords in the wild. Yet they can be extremely useful. But first, let’s see how they’re defined in the SQL standard.

3. Sequence Values in NuoDB

Ever wonder why your Sequence numbers in NuoDB are not necessarily assigned in sequential order?

4. Math and SQL Part 5: Projection and Selection

The SELECT statement is the workhorse of SQL. Updates and inserts are necessary, but selects are where the power is. One of the issues many people have in understanding these and using them is a clear understanding of the math involved, because there are a large number of implicit possibilities in the syntax.

5. 5 Great New Features From Percona Cloud Tools for MySQL

Percona Cloud Tools for MySQL is a hosted service providing access to query performance insights for all MySQL uses. After a brief setup, unlock new information about your database and how to improve your applications. There’s a lot more, but let’s just look at these five new features…


Developers! Quickly and easily gain access to the tools and information you need! Explore, test and combine our data quality APIs at Melissa Developer Portal – home to tools that save time and boost revenue. Our APIs verify, standardize, and correct the Big 4 + more – name, email, phone and global addresses – to ensure accurate delivery, prevent blacklisting and identify risks in real-time.

Topics:

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}