What is SQL?
Structured Query Language — commonly known as SQL — is a language used to define, control, manipulate, and query data held in a relational database.
Databases Checkpoint
This checkpoint is intended to help you assess what you learned from our introductory articles to Databases, where we defined databases and introduced common database management systems.
How To Work with Dates and Times in SQL
In this tutorial, you will learn how to use dates and times in SQL. You’ll begin by performing arithmetic and using various functions with dates and times using only the SELECT statement. Then you’ll practice by running queries on sample data, and you’ll learn how to implement the CAST function to make the output more digestible to read.
What is the Relational Model?
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 database management system must have some kind of underlying model that defines how…
How DuckDB Complements Pandas for Large-Scale Analytics
DuckDB extends Pandas for large-scale analytics by enabling fast, in-memory SQL queries, efficient data processing, and seamless integration for Python.
Setting up a Multi-Region Deployment of HarperDB on the cloud provider
URL: https://www.progressiverobot.com/setting-up-a-multi-region-deployment-of-harperdb-on-cloud-provider-6e27b178-a4aa-4986-b475-d7d9423332d5/ HarperDB, a globally distributed data and application platform, is now available on the the cloud provider Marketplace, giving the cloud provider users a fast way to bootstrap HarperDB. HarperDB is unique because it combines a high-performance database, user-built custom applications, and real-time data streaming into a single platform. The technology was built with […]
How To Create and Manage Tables in 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 data organization, creating and managing tables are common tasks for anyone who builds or maintains databases. This guide outlines how to create tables in SQL, as well as how to modify and delete existing tables.
SQL Between, MySQL Between Dates, Not Between
URL: https://www.progressiverobot.com/sql-between-mysql-between-dates-not/ The SQL BETWEEN operator is used along with [WHERE](/community/tutorials/sql-where-clause) clause for providing a range of values. The values can be the numeric value, text value, and date. SQL BETWEEN operator is almost like [SQL IN](/community/tutorials/sql-in-sql-not-in) operators used in a sequential manner. The values are defined as part of the BETWEEN range are inclusive […]
How To Install OpenEMR on Ubuntu 20.04 with a LAMP Stack (Apache, MySQL, PHP)
In this tutorial, you will install OpenEMR on Ubuntu 20.04 along with its dependencies Apache, MySQL, and PHP.
SQL Commit And Rollback
URL: https://www.progressiverobot.com/sql-commit-sql-rollback/ The most important aspect of a database is the ability to store data and the ability to manipulate data. COMMIT and ROLLBACK are two such keywords which are used in order store and revert the process of data storage. These keywords are usually used in context with a transaction. Let's try to understand the […]
