Scribd
Upload
4 views1 page

04 SQL Database

This document provides a beginner-friendly reference for SQL and database basics. It covers fundamental operations such as SELECT, INSERT, UPDATE, and DELETE, along with example code for creating a users table and manipulating data. The emphasis is on understanding how to store and manage structured information in databases.

Uploaded by

micasahomes24
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views1 page

04 SQL Database

This document provides a beginner-friendly reference for SQL and database basics. It covers fundamental operations such as SELECT, INSERT, UPDATE, and DELETE, along with example code for creating a users table and manipulating data. The emphasis is on understanding how to store and manage structured information in databases.

Uploaded by

micasahomes24
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

SQL & Database Basics

Beginner-friendly coding reference

Database
A database stores structured information for applications.

SELECT
SELECT retrieves data from tables.

INSERT
INSERT adds new records.

UPDATE
UPDATE changes existing records.

DELETE
DELETE removes records; use WHERE carefully.

Example Code
CREATE TABLE users (
id INTEGER PRIMARY KEY,
name TEXT,
age INTEGER
);

INSERT INTO users (name, age)


VALUES ('Deepak', 25);

SELECT * FROM users;

UPDATE users
SET age = 26
WHERE id = 1;

You might also like