DBMS 4/9/20, Sql Server

DBMS 4/9/20

--Sql Server 2014 Express Edition
--Batches are separated by 'go'

select @@version as 'sql server version'

CREATE TABLE Global_Developers(id INTEGER,
                             Name VARCHAR(36),
                             Skills VARCHAR(100),
                             Experience INTEGER,
                             Certifications VARCHAR(100),
                             Nationality VARCHAR(50)
                            )
INSERT INTO Global_Developers values (1, 'John Doe', 'Web, Android, ios', 8, 'Google Android Developer', 'USA'),
                                     (2, 'Robert Oreilly', 'Website, SEO, Content Writing',3 , 'Nothing', 'Brazil'),
                                     (3, 'Jane Doe', 'Machine Learning, Deep Learning, Artificial Intelligence', 6, 'PCAP', 'Europe')                                     
UPDATE Global_Developers set Certifications = null where id = 2

SELECT * FROM Global_Developers 
SELECT * FROM Global_Developers ORDER BY Experience DESC
SELECT id,Name,Skills FROM Global_Developers Where Skills LIKE '%Web%'
SELECT id,Name,Skills FROM Global_Developers Where Nationality='USA' or Experience>5
SELECT id,Name,Skills FROM Global_Developers Where Nationality='Brazil' and Experience=3
SELECT id,Name,Skills FROM Global_Developers Where Certifications is NOT null
SELECT id,Name,Skills FROM Global_Developers Where Certifications is  null


run \| edit \| history \| help	0