The html5 from renaner123

やあ 👋

👨🏻‍💻 Sobre

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.

Tecnologias e ferramentas

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','[email protected]','(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;