SQL Server Blog
PostgreSQL is a powerful Open Source Object-Relational Database System. It has over 15 years of the active development phase and a proven architecture that has earned a good reputation for...
PreambleMongodb compass graphic client: For work with MongoDB, you can use the official graphic client Compass. If you didn’t install MongoDB, Mongo Compass, you can download it by going to...
PreambleThe whole model of the database device in MongoDB can be presented as follows:If in the relational databases the contents are tables, then in the working with databases consists of...
MySQL is the most popular open-source relational database management system. It is fast, easy to use, scalable, and an integral part of the popular LAMP and LEMP stacks.This article explains...
In this article, I will talk in detail, especially for beginner programmers, about how to create a database in Microsoft SQL Server, as well as what you should know before creating a...
PostgreSQL Comparison Operators are used in the WHERE sentence to determine which entries to choose. Here is a list of comparison statements that you can use in PostgreSQL :Comparison...
PostgreSQL EXISTS condition is used in combination with a subquery and is considered "satisfied" if the subquery returns at least one line. It can be used in SELECT, INSERT, UPDATE, or DELETE...
PostgreSQL BETWEEN condition is used to obtain values in the range in SELECT, INSERT, UPDATE, or DELETE operator. The syntax for BETWEEN condition in PostgreSQL expression BETWEEN value1_id AND...
PostgreSQL IS NOT NULL condition is used to check the value of NOT NULL in SELECT, INSERT, UPDATE or DELETE operators. The syntax for IS NOT NULL condition in PostgreSQL expression IS NOT...
PostgreSQL IS NULL condition is used to check the value of NULL in SELECT, INSERT, UPDATE or DELETE operators. The syntax for IS NULL condition in PostgreSQL IS expression NULL Parameters and...
The PostgreSQL NOT condition (also called the NOT operator) is used to deny the condition in SELECT, INSERT, UPDATE or DELETE. The syntax for NOT condition in PostgreSQL NOT...
PostgreSQL IN condition is used to reduce the need to use multiple OR conditions in SELECT, INSERT, UPDATE, or DELETE. The syntax for IN condition in PostgreSQL expression IN (value1_id,...
Before starting to create an SQL table, it is necessary to define the database model. Design an ER diagram in which to define the entities, attributes, and relationships. Basic...
Database security is a key factor for any application that includes very sensitive data, such as financial and health reports.Data protection can be achieved through encryption at various levels,...
PostgreSQL LIKE condition allows using wildcards (metacharacters) in WHERE proposal of SELECT, INSERT, UPDATE or DELETE operator. This allows for pattern matching. The syntax for the LIKE...
PostgreSQL condition OR is used to check two or more conditions under which records are returned when any of these conditions are met. It can be used in SELECT, INSERT, UPDATE, or DELETE...