Video Resources

How Web Applications Use Databases and SQL

A three-part learning path on how web applications store and manage data with databases and SQL. Learn how relational databases organize data into tables, rows, columns, and data types, and how application requests become SQL queries. Then practice the full CRUD cycle: adding records with INSERT, retrieving and filtering data with SELECT and WHERE, and safely modifying or removing records with UPDATE and DELETE.

Frequently Asked Questions

What this playlist answers

9 questions this playlist covers — skim them for a quick takeaway, or dive into the videos above for the full picture.

This three-part learning path explains how web applications use databases and SQL. It covers database fundamentals such as tables, rows, columns, and data types, and the four CRUD operations: INSERT, SELECT, UPDATE, and DELETE.

SQL, or Structured Query Language, is the standard language for communicating with relational databases. It is used to retrieve data with SELECT, add records with INSERT, change records with UPDATE, and remove records with DELETE.

Web applications store information such as user accounts, posts, and transactions in databases. When a user takes an action, the application sends a request that is translated into a SQL query, and the database returns the results to display in the interface.

Tables are the structures that store data in a relational database. Each row represents an individual record and each column represents an attribute, such as a name, date, or ID, with a data type that defines what kind of value it can hold.

Data types define what kind of value a column can store, such as integers, text, or dates. They keep data consistent and prevent errors like inserting text into a numeric field, which protects database integrity.

CRUD stands for Create, Read, Update, and Delete, the four fundamental database actions. In SQL they map to INSERT, SELECT, UPDATE, and DELETE, and together they give applications full control over how data is stored and managed.

INSERT adds new records to a table by specifying the table, columns, and values, for example when a user signs up. SELECT retrieves data without modifying it, and the WHERE clause filters results to return only the records that meet a condition.

UPDATE changes values in existing records using the SET keyword, while DELETE permanently removes entire rows from a table. UPDATE is used to correct or change data, and DELETE is used when data is no longer needed.

The WHERE clause limits UPDATE and DELETE to specific rows. Without it, the operation applies to every record in the table, which can cause accidental data loss or unintended bulk changes in production systems.

Featured:

Turn AI anxiety into action

Featured:

Bolstering technical skills development in MENA

Featured:

Explore new digital career pathways

Featured:

Take action on generative AI

Featured:

Hear what the experts have to say

How Web Applications Use Databases and SQL

What this playlist answers

Proprietary research. Actionable frameworks.

Bridging the skills gap: The power of digital apprenticeships in a rapidly evolving economy

Leveraging AI to uncover $50M in revenue growth and $500K in savings

Data illiteracy: A hidden threat

Using customized training solutions to create new career pathways

Creating an AI talent ecosystem in Latin America

ADP: AI skills power great customer experiences