fbpx

What is SQL?

SQL explained

As defined by W3Schools, a world-renowned web developer site...

SQL (Structured Query Language) is a standard language for accessing and manipulating databases.

SQL is a coding language used to interact with databases through the use of queries.

Picture this: a doctor’s office with a filing cabinet in the left corner containing relevant information to the office’s operation.

The filing cabinet has 3 drawers: Appointments, Clients, and Staff.

Each drawer contains papers with the same required information on each paper.

For example, each paper in the Appointments drawer contains (1) the date and time of the appointment, (2) the name of the client, (3) the name of the doctor, and (4) a description of the appointment.

The main components of SQL are databases, tables, and records.

In comparison to the doctor's office, the filing cabinet is the database. Each drawer is a table. Each paper is a record.

"A doctor’s office with a filing cabinet containing relevant information to the office’s operation." This is the database.

"The filing cabinet has 3 drawers: Appointments, Clients, and Staff." These are the tables.

"Each drawer contains papers with the same required information on each paper." These are the records.

"For example, each paper in the Appointments drawer contains (1) the date and time of the appointment, (2) the name of the client, (3) the name of the doctor, and (4) a description of the appointment." These are the fields of the Appointments table. Fields are essentially the columns of information contained in a table.

Attributes are essentially the specific values that each record contains corresponding to the table's fields.

Think of fields as table-specific. Each table has fields, or columns, like the date and time of the appointment, the name of the client, the name of the doctor, and a description of the appointment.

Think of attributes as record-specific. Each record has attributes, or values, for the columns corresponding to date and time of the appointment, the name of the client, the name of the doctor, and a description of the appointment.

Whenever an employee goes into the office to createreadupdate, or delete information from the filing cabinet, they are executing a query.

Now that you've got a conceptual understanding of how SQL works, let's start coding! Click SELECT & FROM below to learn the core statements of any SQL query!