Lesson Overview

This lesson introduces learners to Structured Query Language (SQL) and its role in managing relational databases. Learners will explore how SQL is used to store, retrieve, manipulate, and manage data within database management systems. The lesson also examines common SQL operations and how SQL supports business systems, reporting, and automation processes in modern digital environments.

Lesson Outcomes

After completing this lesson, learners will be able to:

• Explain the purpose and function of SQL
• Describe how SQL is used in relational database systems
• Identify common SQL code constructs
• Explain how SQL is used to store, retrieve, and manipulate data
• Describe the role of SQL in automation and business systems

KT0301: SQL Programming Language

Structured Query Language (SQL) is a programming language used to communicate with relational databases.

SQL allows users and systems to:

• Store information
• Retrieve records
• Update data
• Delete records
• Create database structures
• Manage database access

SQL is widely used because relational databases store large amounts of structured information used by organisations.

Examples of systems that use SQL include:

• Banking systems
• Inventory systems
• Payroll systems
• Customer management systems
• Reporting platforms

SQL provides a standard method for interacting with databases across many different platforms.

Common relational database systems include:

• MySQL
• Microsoft SQL Server
• Oracle Database
• PostgreSQL

SQL is important in RPA environments because automation bots often interact with databases to process and retrieve information automatically.

KT0302: SQL Code Constructs to Perform Database Transactions

SQL uses different commands and code structures called constructs to perform database operations.

Common SQL Constructs

SELECT Statement

The SELECT statement retrieves information from a database.

Example:

SELECT * FROM Customers;

This retrieves all records from the Customers table.

INSERT Statement

The INSERT statement adds new records.

Example:

INSERT INTO Customers (Name, City)
VALUES ('John', 'Pretoria');

UPDATE Statement

The UPDATE statement changes existing data.

Example:

UPDATE Customers
SET City = 'Cape Town'
WHERE Name = 'John';

DELETE Statement

The DELETE statement removes records.

Example:

DELETE FROM Customers
WHERE Name = 'John';

These SQL constructs help organisations manage information efficiently.

KT0303: Storing, Retrieving, Managing and Manipulating Data Inside an RDBMS

An RDBMS (Relational Database Management System) is software used to manage relational databases.

Examples of RDBMS platforms include:

• MySQL
• Oracle
• Microsoft SQL Server
• PostgreSQL

SQL is used within an RDBMS to perform database operations.

Storing Data

Organisations store information in tables containing rows and columns.

Example table:

Retrieving Data

SQL queries retrieve specific information from databases.

Example:

SELECT Name FROM Customers;

This retrieves customer names only.

Managing Data

Database administrators manage:

• User access
• Database security
• Data backups
• Database performance
• System updates

Manipulating Data

Data manipulation refers to changing stored information.

Examples include:

• Updating records
• Deleting records
• Sorting data
• Filtering information

SQL allows businesses to manage information efficiently and accurately.

SQL in Business and Automation Environments

SQL is important because organisations rely on data for daily operations and decision-making.

SQL supports:

• Reporting systems
• Business intelligence
• Automation workflows
• Customer management systems
• Financial systems
• Inventory management

In RPA environments, bots may use SQL to:

• Extract information from databases
• Update records automatically
• Generate reports
• Process transactions
• Validate information

SQL improves operational efficiency by allowing systems to process large amounts of information quickly and accurately.

Advantages of SQL

Advantages of SQL include:

• Efficient data retrieval
• Standardised database communication
• Improved data management
• Support for automation
• Secure data access
• Scalability for large systems

SQL is widely used because it supports reliable and structured data management in modern digital systems.

Key Notes

• SQL stands for Structured Query Language.
• SQL is used to communicate with relational databases.
• Common SQL commands include SELECT, INSERT, UPDATE, and DELETE.
• An RDBMS manages relational databases and stored information.
• SQL allows organisations to store, retrieve, manage, and manipulate data.
• SQL supports reporting systems, automation workflows, and business intelligence.
• RPA bots often use SQL to process database information automatically.