This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
use empresa_jose_vitor; | |
-- 1. Retornar os nomes dos funcionários do departamento 4 que trabalham mais de 9 horas por semana no projeto Informatização. | |
select FUNCIONARIO.Pnome, FUNCIONARIO.Unome | |
from | |
FUNCIONARIO join TRABALHA_EM on FUNCIONARIO.Cpf = TRABALHA_EM.Fcpf | |
join PROJETO on TRABALHA_EM.Pnr = PROJETO.Projnumero | |
where FUNCIONARIO.Dnr = 4 and TRABALHA_EM.Horas > 9 and PROJETO.Projnome = 'Informatização'; | |
-- 2. Retornar os nomes de todos os funcionários que possuem pelo menos um dependente com o mesmo sexo do funcionário. | |
select FUNCIONARIO.Pnome as 'primeiro nome', FUNCIONARIO.Unome |
With increasing scalability comes the need to use strategies and approaches to ensure the availability of our services. Here I list some very important tools and concepts to achieve these goals.
Most of these tools are multifunctional.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--- | |
version: '3' | |
services: | |
elasticsearch: | |
image: docker.elastic.co/elasticsearch/elasticsearch:8.3.2 | |
environment: | |
- bootstrap.memory_lock=true | |
- ELASTIC_PASSWORD=changeme | |
- discovery.type=single-node |