-
One of the most fundamental parts of working with databases is the practice of retrieving information about the data held within them. In relational database management systems, any operation used to retrieve informat...
•
By
Mark Drake
SQL
Databases
Interactive
-
Tutorial
When working on a large SQL project, you must maintain the accuracy and consistency of data across all tables using foreign keys. This is where referential integrity comes into play. Referential integrity ensures all ...
•
By
FRANCIS NDUNGU
Ubuntu
SQL
Databases
Development
MySQL
System Tools
-
When working with a database, there may be times when you need to change data that's already been inserted into it; you may need to correct a misspelled entry, or perhaps you have information to add to an incomplete r...
•
By
Mark Drake
SQL
Databases
Interactive
-
SQL provides a great deal of flexibility in terms of how it allows you to insert data into tables. You can specify individual rows of data with the VALUES keyword, copy entire sets of data from existing tables with SE...
•
By
Mark Drake
Databases
SQL
Interactive
-
In Structured Query Language (SQL) statements, WHERE clauses limit what rows the given operation will affect. This guide will go over the general syntax used in WHERE clauses. It will also outline how to combine multi...
•
By
Mark Drake
SQL
Databases
Interactive
-
As the name implies, DELETE operations irreversibly delete one or more rows of data from a database table. Being such a fundamental aspect of data management, it's important for SQL users to understand how the DELETE ...
•
By
Mark Drake
Databases
SQL
Interactive
-
Tutorial
Flask is a framework for building web applications using the Python language, and SQLite is a database engine that can be used with Python to store application data. In this tutorial, you'll modify items in an applica...
•
By
Abdelhadi Dyouri
Flask
Python
Python Frameworks
SQL
Databases
SQLite
-
Like many computer languages, SQL allows the use of various wildcard characters. Wildcards are special placeholder characters that can represent one or more other characters or values. This is a convenient feature in ...
•
By
Mark Drake
Databases
SQL
Interactive
-
Tutorial series
Series Description
Structured Query Language (https://en.wikipedia.org/wiki/SQL) — commonly known as SQL — is a language used to define, control, manipulate, and query data held in a relational database. SQL has been ...
•
By
Mark Drake
Databases
Conceptual
SQL
Interactive
-
In certain Structured Query Language (SQL) statements, WHERE clauses can be used to limit what rows the given operation will affect. SQL allows users to retrieve granular result sets by providing a variety of differen...
•
By
Mark Drake
SQL
Databases
Interactive
-
Tutorial
In this tutorial, you will install OpenEMR on Ubuntu 20.04 along with its dependencies Apache, MySQL, and PHP.
•
By
Erin Glass
SQL
LAMP Stack
Ubuntu
-
In certain Structured Query Language (SQL) statements, WHERE clauses can be used to limit what rows the given operation will affect. SQL allows users to retrieve granular result sets by providing a variety of differen...
•
By
Mark Drake
SQL
Databases
Interactive
-
Tutorial
The relational model is an abstract model used to organize data within a database. In order to control access to a database, write data, run queries, or perform any other tasks related to database management, a databa...
•
By
Mark Drake
Databases
Glossary
SQL
-
Tables are the primary organizational structure in SQL databases. They consist of any number of columns, which reflect individual attributes of each row, or record, in the table. Being such a fundamental aspect of dat...
•
By
Mark Drake
Databases
SQL
Interactive
-
Tutorial
MariaDB is an open-source relational database management system. As with other relational databases, MariaDB stores data in tables made up of rows and columns. Users can define, manipulate, control, and query data usi...
•
By
Mark Drake
Glossary
MariaDB
Databases
SQL
-
When designing an SQL database, there may be cases where you want to impose restrictions on what data can be added to certain columns in a table. SQL makes this possible through the use of constraints. After applying ...
•
By
Mark Drake
SQL
Databases
Interactive
-
Many database designs separate information into different tables based on how certain data points relate to one another. Even in cases like this, it's likely that there will be times when someone will want to retrieve...
•
By
Mark Drake
Databases
SQL
Interactive
-
Relational database management systems allow you to control what data gets added to a table with constraints. A constraint is a special rule that applies to one or more columns — or to an entire table — that restricts...
•
By
Mark Drake
Databases
SQL
Conceptual
-
Tutorial
Structured Query Language — commonly known as SQL — is a language used to define, control, manipulate, and query data held in a relational database.
•
By
Mark Drake
SQL
Glossary
-
Question
I have a custom site running on an Ubuntu LAMP 16.04 droplet. The site is built with PHP and has entries in a SQL database.
What's the best way to clone this droplet as-is (SQL database and all) and run it locally? On...
Accepted Answer:
Hello,
It would depend on what OS you are using on your local environment. For example, if you have a Windows PC, you could install the WAMP stack which would allow you to have Apache/PHP/MySQL on your laptop. If you ...
1
•
•
By
gregbarbosa
Ubuntu 16.04
LAMP Stack
PHP
SQL
Git
GitHub Actions