Examples of RDBMS

• MySQL: An open-source RDBMS known for its reliability and ease of use.
• PostgreSQL: An open-source RDBMS with advanced features and compliance with SQL standards.
• Oracle Database: A proprietary RDBMS known for its scalability and robust features.
• Microsoft SQL Server: A proprietary RDBMS from Microsoft known for its integration with other Microsoft products.
• SQLite: A lightweight, file-based RDBMS often used in embedded systems and applications.

Basic Operations in RDBMS

Creating a Table

CREATE TABLE Employees (
    EmployeeID INT PRIMARY KEY,
    FirstName VARCHAR(50) NOT NULL,
    LastName VARCHAR(50) NOT NULL,
    DepartmentID INT,
    Salary DECIMAL(10, 2),
    HireDate DATE
);

Inserting Data

INSERT INTO Employees (EmployeeID, FirstName, LastName, DepartmentID, Salary, HireDate)
    VALUES (1, 'John', 'Doe', 1, 60000.00, '2020-01-15'),
    (2, 'Jane', 'Smith', 2, 65000.00, '2019-03-22'),
    (3, 'Emily', 'Jones', 3, 55000.00, '2021-06-30');

Querying Data

SELECT * FROM Employees;

Updating Data

UPDATE Employees
SET Salary = 70000.00
WHERE EmployeeID = 1;

Deleting Data

DELETE FROM Employees
WHERE EmployeeID = 1;