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