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.
How to INSERT Multiple Records in SQL
URL: https://www.progressiverobot.com/sql-insert-multiple-rows/ Hey, folks! In this article we will be focusing on ways to Insert Multiple rows in SQL. Need of SQL Insert INTO Multiple rows query [SQL INSERT query](/community/tutorials/sql-insert-query) inserts data into the columns of a particular table. The normal SQL INSERT query inputs the data values in a single row. In case when […]
How To Use Constraints in 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 a constraint to a column or table, any attempts to add…
How To Use CASE Expressions in SQL
CASE expressions are a feature in Structured Query Language (SQL) that allow you to apply similar logic to database queries and set conditions on how you want to return or display the values in your result set. In this tutorial, you’ll learn how to use the CASE expression to set conditions on your data using WHEN, THEN, ELSE, and END keywords.
How To Use GROUP BY and ORDER BY in SQL
Learn how to use GROUP BY and ORDER BY in SQL to organize and sort data with practical examples and best practices.
How To Use Functions in SQL
When working with relational databases and Structured Query Language (SQL), you can store, manage, and retrieve data from the relational database management system. SQL can also perform calculations and manipulate data through the use of functions. In this tutorial, you’ll use different SQL functions to perform mathematical calculations, manipulate strings and dates, and calculate summaries using aggregate functions.
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 Use Triggers in MySQL
When working with relational databases and SQL, most operations on the data are performed as a result of explicitly executed queries, such as SELECT, INSERT, or UPDATE. However, SQL databases can also be instructed to perform pre-defined actions automatically every time a specific event occurs through triggers. In this tutorial, you’ll use different SQL triggers to automatically perform actions where rows are inserted, updated, or deleted.
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 […]
SQL TIMESTAMP() Function – All you need to know!
URL: https://www.progressiverobot.com/sql-timestamp/ Hey, all. In our series of [SQL DATE and TIME functions](/community/tutorials/sql-date-time), in this article, we will learn the SQL TIMESTAMP() function in detail. The SQL DATE and TIME functions enable us to deal date-time data. Moreover, using these functions, we can extract a portion of the date and time from the datetime expressions. […]
