Technology

SQL Script

We will learn SQL From khan academy. Go to https://tinyurl.com/newscript25

Go to the next slide to open the link

New SQL script | Computer programming | Khan Academy

You can open this webpage in a new tab.

Copy link

Open in new tab

Steps if creating a SQL script

• 1. Think what data you are gonna insert

• Use the command CREATE TABLE Name (id INTEGER PRIMARY KEY, name TEXT, quantity INTEGER, aisle INTEGER); to create a table

• Insert data with this command INSERT INTO Name VALUES (1, "Data", 4, 7);

• To give a comment use --

• 1 more way to give a comment is /** /**

• These are all requried

Example

Go to the next page and view an example of a SQL script. Click open in new tab.

TheTechyChips Help | Computer programming | Khan Academy

You can open this webpage in a new tab.

Copy link

Open in new tab

Get khan academy lessons for free

View the new page to get khan academy SQL lessons.

Intro to SQL: Querying and managing data | Khan Academy

You can open this webpage in a new tab.

Copy link

Open in new tab