User management and permissions are essential to SQL database security. Typically, SQL database security schemes consist of one or more users, their authentication, and permissions.
In relational database systems, a database index is an extremely powerful tool for data retrieval. In this guide, you learn about unique indexes, primary keys, and composite primary keys.
One of the most powerful aspects of SQL is the ability to perform data aggregation. Two of the most powerful SQL data aggregation tools are grouping and totaling.
Choosing the proper data type for a table column is an important decision. It reduces the need for data type conversions, enhances the performance of database queries, and minimizes storage requirements.
Traditionally, you pull data from two or more tables using a WHERE clause in a query.
In today’s world of increased digitization, big data, and cloud computing, data management is amongst the most important skills a software engineer can have.
Databases power nearly every digital platform on the planet: From websites, to blogs, to social media, to streaming services.
Many programs need to save or store data for later use and read data that is recorded.
Ubuntu users have a choice between two reliable Relational Database Management Systems (RDBMS), MySQLand MariaDB. MySQL has a long-standing edge in popularity, but there has been increased interest in MariaDB due to its performance advantages and added features.
This guide shows you how to connect to a remote MySQL or MariaDB database using the command line.
This guide provides the commands you can use to list tables in MySQL and MariaDB. It also includes instructions on how to list tables using MySQL Workbench.
The MySQLis a relational database management system that is one of the most popular open-source projects.
MySQL MySQL is an open-source relational database management system. This guide will show you how to secure and audit a MySQL server.
A subquery is an SQL (Structured Query Language) query that is nested within another SQL query.
A view in MySQL is a named query that can be triggered to display data stored in other tables.
A trigger is a pre-defined SQL command that is automatically executed when specific actions occur in the database.
Stored procedures are user-defined SQL statements that are stored in a MySQL database and executed on-demand to perform a specific database operation.
What is Metabase Metabase provides an interface to query data on your browser.
While the mysqldump tool is the preferred backup method for a MariaDB or MySQL database or database system it only works when the database server is accessible and running.
MySQLand MariaDBinclude the mysqldumputility to simplify the process to create a backup of a database or system of databases.
MySQL Workbench is a feature-rich graphical tool used to model data, build SQL queries, manage MySQL servers, and more.
This guide will show you how to get started using MySQL Workbench, a graphical tool for working with MySQL databases.
MySQL is a popular database management system used for web and server applications. However, MySQL is no longer in CentOS’s repositories and MariaDB has become the default database system offered.
MySQL is a popular database management system used for web and server applications.
Running MySQL at optimal settings for specific resources helps handle larger server loads and prevents server slowdown.
What is MySQL Master-Master Replication?
phpMyAdmin is a web application that provides a GUI to aid in MySQL database administration.
MySQL is a popular database management system, used as the data storage provider for thousands of web and server applications.
phpMyAdmin is a web application that provides a GUI to aid in MySQL database administration. It supports multiple MySQL servers and is a robust and easy alternative to using the MySQL command line client.
MySQL is a popular database management system used for web and server applications. This guide will introduce how to install, configure and manage MySQL on a Linode running Ubuntu 12.
MySQL is a relational database management system (RDBMS) that is used as a backend for countless web and server applications.
phpMyAdmin is an open source web application written in PHP that provides a GUI to aid in MySQL database administration.
MySQL is an open source relational database management system (DBMS) which is frequently deployed in a wide assortment of contexts.
This guide will show you how to make a secure connection to your remote MySQL or MariaDB server from your local computer, using an SSH tunnel.
In some kinds of deployments, particularly where rich dynamic applications rely on a large database, separating the database server from the application server can permit your application to scale and accommodate a much larger user base.
Bummer! The page you were looking for wasn't found. You can
browse our articles
or try searching.