Learn the basics of SQL for QA, Dev, & Analyst Roles

Learn the basics of SQL for QA, Dev, & Analyst Roles

Medium Article: https://thetestlead.medium.com/learn-enough-sql-to-get-you-the-job-sql-basics-for-qa-testing-analyst-roles-dea3ba1341d2

Website to practice:https://www.w3schools.com/sql/trysql.asp?filename=trysql_create_table
List Of Commands:
//Create
//create table
CREATE TABLE TestLeadSubscribers
(
Name varchar(255),
Address varchar(255),
City varchar(255)
);
//insert information into table
INSERT INTO TestLeadSubscribers (Name, Address, City)
VALUES (‘John’,’222-Youtube Road’, ‘NY’)
INSERT INTO TestLeadSubscribers (Name, Address, City)
VALUES (‘NotJohn’,’111-Youtube Road’, ‘NY’);

//View Data
select Name from TestLeadSubscribers
select * from TestLeadSubscribers
select * from TestLeadSubscribers
where name= ‘John’

//Change Data
UPDATE TestLeadSubscribers
SET Name = ‘TheTestLead’
WHERE Name = ‘John’
//view changes
select * from TestLeadSubscribers

//Delete Data
delete from TestLeadSubscribers where Name = ‘NotJohn’
//view changes
select * from TestLeadSubscribers
//Truncate
//Does not work on the website cuirrently(There is a bug)
TRUNCATE TABLE TestLeadSubscribers
//Drop
DROP TABLE TestLeadSubscribers;
select * from TestLeadSubscribers
Website:thetestinglead.com
Course: https://www.thetestinglead.com/courses

QA Must Know Vocab
PDF: https://www.thetestinglead.com/shop
Book:https://amzn.to/3rYbc3O

Careerist Bootcamp: https://crst.co/JUSTINBA-EE9779DE

Twitter: Juss_Bailey
Instagram: Juss_bailey
Instagram: TheTestLead
Threads:Juss_Bailey

Видео Learn the basics of SQL for QA, Dev, & Analyst Roles канала The Test Lead