Learn about the popular database system MySQL, including its uses, benefits, and features in this database programming tutorial.

We highlight some of the best certifications for database administrators. Learn about the top DBA certifications.

Learn structured query language from our hand-selected list of the best online courses to learn SQL. Learn more about database programming.

MariaDB and MySQL are top-ranked databases. But how do they compare? Read our relational database comparison.

We highlight some of the best database administration courses for database admins and developers. Learn more.

MongoDB and MySQL are top-ranked databases. But how do they compare? Read our database comparison and feature review.

SQL*Plus and PL/SQL have been at odds for years -- cases abound where how a task is performed using SQL*Plus differs from how that same or similar task is

A long-standing discussion in Oracle forums and newsgroups has been the efficiency of using count(*) to return a rowcount from a given table. A new

By Manoj Debnath Tables in a SQL database may contain enormous amount of data, but they are not always in a useful format to be readily used. The volume

Oracle introduced a new feature, group by elimination, for queries where the group by column is also the table's unique key. As with many new features

The road of progress can be rough at times. Oracle versions 18 and 19 are no exception. Up until version 18.x Oracle had no issues with marking columns as

Database tables are not static entities; besides the usual insert/update/delete events, occasional DDL can be executed to add columns, drop columns or add

SQL Server has a lot of configuration values. One of these configuration values is the “Cost Threshold for Parallelism”. This configuration

How many different database applications exist? Many people can name the most common ones such as MySQL, Microsoft SQL Server, and Oracle. Most good DBAs

In the processes of executing a query the database optimizer calculates an estimate at the cost to run the query. This cost is determined based on

In one of the article, Considerations for Deploying Azure SQL Database Managed Instances, recently published on this site, basic characteristics of Azure

Do you get tired of having your CREATE PROCEDURE statement failing if the stored procedure already exists? If you are like me then you probably hate this

Microsoft provides a number of different deployment options for its Azure SQL Database offerings. We have reviewed a number of them on this forum,