You are now entering the PC Anatomy portal

SQL, or Structured Query Language, is a programming language for managing and manipulating data in a relational database. It uses commands like SELECT, INSERT, UPDATE, and DELETE to retrieve, add, modify, and remove data from databases. SQL is a special-purpose language used across many applications and organizations, from creating tables and databases to controlling data access and performing complex queries.

Key functions

Data Query Language (DQL): Used to retrieve and analyze data from a database.

SELECT: Extracts data from a database.

Data Manipulation Language (DML): Used to manage data within schema objects.

INSERT: Adds new data into a database.

UPDATE: Changes existing data.

DELETE: Removes data from a database.

Data Definition Language (DDL): Used to define and modify the database structure.

CREATE TABLE: Creates a new table in the database.

ALTER TABLE: Modifies an existing table.

DROP TABLE: Deletes a table.

Data Control Language (DCL): Used to control access to data within the database.