SQL Operator part 2

An operator is a reserved word or a character that is used to query our database in a SQL expression. To query a database using operators, we use a WHERE clause. Operators are necessary to define a condition in SQL, as they act as a connector between two or more conditions.There are six types of SQL operators that we are going to cover: Arithmetic, Bitwise, Comparison, Compound, Logical and String.The most basic SQL (Structured Query Language) operations are often referred to as CRUD operations, which stands for Create, Read, Update, and Delete. These operations represent the fundamental actions that can be performed on a database. 1. Create (C): This operation involves adding new records (rows) to a table.SQL commands are mainly categorized into five categories:
DDL – Data Definition Language.
DQL – Data Query Language.
DML – Data Manipulation Language.
DCL – Data Control Language.
TCL – Transaction Control Language.
There is only one type of SQL (Structured Query Language), which is a standardized language used to manage relational databases. However, there are different flavors of SQL that are specific to different database management systems, such as MySQL, Oracle, PostgreSQL, SQL Server, etc SQL stands for Structured Query Language. SQL commands are the instructions used to communicate with a database to perform tasks, functions, and queries with data. SQL commands can be used to search the database and to do other functions like creating tables, adding data to tables, modifying data, and dropping tables