Structured Query Language (Basics 1 video)

▶️ Watch on 3Speak

This video is a tutorial on SQL basics where I talk on some basic concepts. This serves as a reference material for the post I made on SQL

Code used:

CREATE DATABASE Friend_list

USE Friend_list;


/** C R U D
*/
CREATE TABLE friends( First_name VARCHAR(50), Last_name VARCHAR(50), Age INT, contact INT );
SELECT * FROM friends
INSERT INTO friends(First_name,Last_name,Age,contact) VALUES( 'Abdul Kahar', 'Gunu', 80, 0123456789 );
INSERT INTO friends(First_name,Last_name,Age,contact) VALUES( 'Abdul Rahman', 'Kudus', 50, 1234567890 );
SELECT First_name, Last_name FROM friends WHERE contact = 1234567890 SELECT Age FROM friends WHERE contact = 1234567890 SELECT Last_name AS [FIRST NAME],First_name AS [LAST NAME] FROM friends WHERE contact = 1234567890
UPDATE friends SET Age = 12 WHERE contact = 123456789
DELETE FROM friends WHERE contact = 1234567890


▶️ 3Speak