Related Content
 |
Window Functions in MySQL 8 Window functions are a new feature in MySQL 8. While most functions operate only on the data pertaining to a single row of data, Window functions operate over a “window” of data when performing a SQL query, and also for each query row. |
|
 |
Creating a New User in MySQL 8 In MySql 8, you may create a user that requires multiple authentication methods, uses a random password, with comments and attributes annotated with the user, and configured failed logins. |
|
 |
Common Table Expressions in MySQL 8 Common Table Expressions (CTEs) are a new feature in MySQL 8.0 to simplify SQL code related to result sets generated by subqueries, offering a better alternative to derived tables. |
|
 |
The New Data Dictionary in MySQL 8.0 The data dictionary tables do incur some operational and upgrade differences, but the benefits outweigh the overhead. |
|
 |
Human Resource Management, Multi-Tasking, and Waves Some tolerate multi-tasking better than others. Beyond tolerance and even the ability of some people to switch contexts more efficiently than others is an effect of multi-tasking that most of us have experienced but rarely discuss. |
|
 |
MySQL 8.0.x Offers New JSON Features MySQL database supports a native JSON data type in addition to several JSON related SQL/JSON functions. In this article, we will discuss some of the new JSON features in MySQL 8.x. |
|
 |
UAT Entrance Criteria: Don’t Negotiate Against Yourself An important component of any User Acceptance Testing (UAT) plan are the entry criteria. No complex data system will ever be perfect, but starting with lax entrance criteria puts the UAT team in a weak position. |
|
 |
New JVM Features in JDK 11 Java SE 11 is a recent LTS (Long Term Support) version of Java. Java 11 has introduced several other (non-language features), some of which we’ll discuss in this article. |
