Sou um engenheiro de telecomunicações formado pelo Instituto Federal de Santa Catarina (IFSC) com 2 anos de experiência em desenvolvimento de software, com foco e interesse no back-end.
Tabelas de habilidades
CREATE TABLE `developer` (
`idDeveloper` int NOT NULL AUTO_INCREMENT,
`name` VARCHAR(45) NOT NULL,
`email` VARCHAR(45) NOT NULL,
`phone` VARCHAR(45) NOT NULL,
PRIMARY KEY (`idDeveloper`),
UNIQUE INDEX `email_UNIQUE` (`email` ASC) VISIBLE,
UNIQUE INDEX `phone_UNIQUE` (`phone` ASC) VISIBLE
)
INSERT INTO `developer` VALUES (1,'Renan','renanrodolfo.dev@gmail.com','(48)996478132');
CREATE TABLE `skills` (
`idSkills` int NOT NULL AUTO_INCREMENT,
`stack` varchar(45) NOT NULL,
`level` varchar(45) DEFAULT NULL,
`category` varchar(45) NOT NULL,
`Developer_idDeveloper` int NOT NULL,
PRIMARY KEY (`idSkills`,`Developer_idDeveloper`),
UNIQUE KEY `stack_UNIQUE` (`stack`),
KEY `fk_Skills_Developer_idx` (`Developer_idDeveloper`)
)
INSERT INTO `skills` VALUES
(1,'HTML','beginner','Frontend',1),
(2,'CSS','beginner','Frontend',1),
(3,'Bootstrap','beginner','Frontend',1),
(4,'JavaScript','beginner','Frontend',1),
(5,'React','beginner','Frontend',1),
(6,'TypeScript','beginner','Frontend',1),
(7,'Java','Intermediate','Backend',1),
(8,'Spring Framework','Intermediate','Backend',1),
(9,'SQL','Intermediate','Backend',1),
(10,'MySQL','Intermediate','Backend',1),
(11,'PostgreSQL','Intermediate','Backend',1),
(12,'Python','Intermediate','Backend',1),
(13,'C++','Intermediate','Backend',1),
(14,'API REST','Advanced','Backend',1),
(15,'API RESTful','Advanced','Backend',1),
(16,'Flask','Intermediate','Backend',1),
(17,'FastAPI','Begginer','Backend',1),
(18,'Maven','Intermediate','Backend',1),
(19,'JPA','Intermediate','Backend',1),
(20,'Hibernate','Intermediate','Backend',1),
(21,'Redis','Intermediate','Backend',1),
(22,'Oracle Database','Intermediate','Backend',1),
(23,'Microservices','learning','Backend',1),
(24,'Docker','Intermediate','DevOps',1),
(25,'Kubernetes','learning','DevOps',1),
(26,'Shell Script','Intermediate','DevOps',1),
(27,'Linux','Intermediate','DevOps',1),
(28,'AWS','learning','DevOps',1),
(29,'Nginx','beginner','DevOps',1),
(30,'Kafka','learning','DevOps',1),
(31,'GitHub Actions','Intermediate','DevOps',1),
(32,'Mockito','Intermediate','Others',1),
(33,'JUnit','Intermediate','Others',1),
(34,'XML','Intermediate','Others',1),
(35,'JSON','Advanced','Others',1),
(36,'SQLite','Intermediate','Others',1),
(37,'Scrum','Advanced','Others',1),
(38,'Kanbam','Intermediate','Others',1),
(39,'GitHub','Advanced','Others',1),
(40,'JWT','Advanced','Others',1);SELECT
category,
GROUP_CONCAT(DISTINCT stack ORDER BY stack) AS stacks
FROM skills
WHERE Developer_idDeveloper = 1
GROUP BY category
ORDER BY category;
