Posts

Showing posts from May, 2025

Handle relational databases using standard Structured Query Language (SQL)

Image
  1.1 Selected DBMS Installed and Setup   What is a DBMS? A Database Management System (DBMS) is software used to store, manage, and retrieve data from a database. Common DBMS examples: MySQL (Open source) Microsoft SQL Server Oracle DB PostgreSQL Steps to Install a DBMS (e.g., MySQL) Download Installer Go to the official MySQL website and download the installer. Run Installer Follow the wizard to install the MySQL server. Set Root Password During installation, you will set the admin (root) password. Start the DBMS Service Use MySQL Workbench or Command Line Client to connect. Verify Installation Run a simple SQL query like: SELECT VERSION();   1.2 User Logged into DBMS as per SOP   What is SOP? SOP = Standard Operating Procedure . It is the step-by-step instruction followed to log in securely. 2.1 Database Created as Required To create a new data...