Privileges in MySQL are an important part of the database. In this guide, you’ll learn: what privileges are and what they do the privileges that are available how to give and take privileges from individual users and groups of users how to see privileges available for a user Let’s get into it. What Are Privileges … MySQL Privileges The Ultimate Guide Read More ..read more

Working with timezones can be one of the hardest things in a database. In this guide, you’ll learn: Why timezones are hard to work with A rule that covers almost all situations An exception to this rule Let’s get into it.   What is the Issue? Whenever you want to store date and time information … Database Timezones: The Ultimate Guide Read More ..read more

If you’ve worked with Oracle databases recently, you may have heard of the terms “pluggable database” and “container database”. In this guide, you’ll learn: what these terms mean the benefits of this new architecture how to connect to a container or pluggable database how to switch between these databases how to create a container or … A Guide to Oracle PDB (Pluggable Database) and CDB (Container Database) Read More ..read more

The ENUM data type in MySQL is a helpful data type for specifying a valid range of values. In this guide, you’ll learn all about the MySQL ENUM feature, including: what the ENUM feature is how to use it on your database some disadvantages of this feature Let’s get into it.   What is the … MySQL ENUM: The Ultimate Guide Read More ..read more

Do you want to change a user’s password on a MySQL database? If so, then this guide is what you need. You’ll learn: a brief summary of the command how to use the command to change the user’s password an alternative method if you happen to be running an older version of MySQL Let’s take … How to Change User Password in MySQL Read More ..read more

If you’re interested in the process to backup and restore a MySQL database, then mysqldump is the tool to use. In this guide, you’ll learn: what mysqldump is how to use it to backup your database in different ways how to restore your database from a backup file Let’s get into the guide. What is … Use mysqldump to Backup and Restore a MySQL Database Read More ..read more

Do you want to learn how to generate pivoted data or pivot tables in MySQL? In this article, you’ll learn: what the pivot concept is how to generate a pivot table in MySQL how to generate the column headings dynamically Let’s get into the guide.   What is PIVOT? The concept of a “pivot” is … MySQL Pivot: How To Generate a Pivot Table Read More ..read more

In this article, you’ll learn: what the PIVOT feature is in SQL Server a few examples of using PIVOT how to use the UNPIVOT feature Sometimes you’ll need to pivot your data if it’s stored in a different way to how you’d like it displayed. You can use the SQL Server PIVOT feature to do … SQL Server PIVOT and UNPIVOT Explained with Examples Read More ..read more

If you want to set up Flyway DB on your database, you’ve come to the right place. In this guide, you’ll learn: What Flyway is A step-by-step guide to setting it up on your database Create a couple of SQL scripts to demonstrate the process Let’s get into it. What is Flyway DB? Flyway DB … Flyway DB Tutorial: How to Set Up Flyway Read More ..read more

Do you want to, or need to, learn how to use GitHub for your SQL files? GitHub is a commonly-used service for application development. But it can also be used for your SQL scripts and other files used in development. In this guide, you’ll learn: how to sign up to GitHub how to create a … GitHub Tutorial for SQL Files Read More ..read more