DBMS 4/9/20, Sql Server

DBMS 4/9/20

Language: Layout:

--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

View schema
Execution time: 0,03 sec, rows selected: 15, rows affected: 4, absolute service time: 0,2 sec, absolute service time: 0,2 sec

	sql server version
1	Microsoft SQL Server 2014 - 12.0.2000.8 (Intel X86) Feb 20 2014 19:20:46 Copyright (c) Microsoft Corporation Express Edition on Windows NT 6.3 <X64> (Build 9600: ) (WOW64) (Hypervisor)

	id	Name	Skills	Experience	Certifications	Nationality
1	1	John Doe	Web, Android, ios	8	Google Android Developer	USA
2	2	Robert Oreilly	Website, SEO, Content Writing	3	NULL	Brazil
3	3	Jane Doe	Machine Learning, Deep Learning, Artificial Intelligence	6	PCAP	Europe

	id	Name	Skills	Experience	Certifications	Nationality
1	1	John Doe	Web, Android, ios	8	Google Android Developer	USA
2	3	Jane Doe	Machine Learning, Deep Learning, Artificial Intelligence	6	PCAP	Europe
3	2	Robert Oreilly	Website, SEO, Content Writing	3	NULL	Brazil

	id	Name	Skills
1	1	John Doe	Web, Android, ios
2	2	Robert Oreilly	Website, SEO, Content Writing

	id	Name	Skills
1	1	John Doe	Web, Android, ios
2	3	Jane Doe	Machine Learning, Deep Learning, Artificial Intelligence

	id	Name	Skills
1	2	Robert Oreilly	Website, SEO, Content Writing

	id	Name	Skills
1	1	John Doe	Web, Android, ios
2	3	Jane Doe	Machine Learning, Deep Learning, Artificial Intelligence

	id	Name	Skills
1	2	Robert Oreilly	Website, SEO, Content Writing