Posts

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...

Perform basic operations of cloud computing including internet and email services -Unit 5

Image
    1. Accessing Internet Services The Internet is a global network that allows users to browse websites, send emails, download files, and communicate in real time. To use the Internet effectively, you need to understand basic operations such as using a web browser, searching for information, downloading content, and managing browser settings. 1.1 Selecting & Opening a Web Browser A web browser is a software application that allows users to access and interact with websites. Popular Web Browsers: Google Chrome – Fast, widely used, syncs with Google account. Mozilla Firefox – Secure, privacy-focused, customizable. Microsoft Edge – Default browser in Windows, integrated with Bing AI.   Safari – Default browser for Apple devices (Mac, iPhone, iPad). Opera – Has a built-in VPN and ad blocker for secure browsing. How to Open a Web Browser? Windows Users: Click on the browser icon on the desktop or taskbar . Press Windows Key + R , type chrome ...